为保障数据库的可靠性，我们会对数据库进行备份，一般用的最多的是逻辑备份，常用的备份工具为“mysqldump”或者“mydumper”。但是逻辑备份有较明显的缺陷——恢复较慢，物理备份则满足了运维人员对于“快速恢复数据”的要求，该工具就是MySQL数据库物理备份的佼佼者。
xtrabackup与innobackupex
在搜xtrabackup的相关资料时，在网上看到很多人都是用的innobackupex，官网上给出的说法是，新版本的innobackupex是xtrabackup的链接符号。
常用命令
备份
普通备份
innobackupex --defaults-file=/etc/my.cnf --user=root --password='root$123' /mysql/backuptest/
常用选项：
--defaults-file指定使用my.cnf的路径，默认是读取/etc/my.cnf。--no-timestamp不带这个选项时，备份将会在指定目录下生成一个时间戳命名的文件夹，例如：2020-10-10_16-43-50；这个选项使用后，不会在指定路径下生成以时间戳命名的文件。
压缩备份
源数据目录大小为:4.7G
innobackupex自带备份命令
只需要在命令中加入--compress选项即可。
[root@node15 backuptest]# innobackupex --defaults-file=/etc/my.cnf --no-timestamp --user root --password 'root$123' --compress /mysql/backuptest/
输出：
xtrabackup: recognized server arguments: --server-id=1133015 --datadir=/mysql/data --innodb_buffer_pool_size=512M --innodb_file_per_table=1 --innodb_data_home_dir=/mysql/data --innodb_data_file_path=ibdata1:1G:autoextend --innodb_log_group_home_dir=/mysql/data/ --innodb_log_files_in_group=3 --innodb_log_file_size=1G --innodb_log_buffer_size=32M --innodb_flush_log_at_trx_commit=2 --innodb_io_capacity=2000 --innodb_max_dirty_pages_pct=40 --open_files_limit=65535 --log_bin=/mysql/log/mysql-bin
xtrabackup: recognized client arguments:
201010 15:14:16 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
201010 15:14:16 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/mysql/data/mysql.sock' as 'root' (using password: YES).
201010 15:14:16 version_check Connected to MySQL server
201010 15:14:16 version_check Executing a version check against the server...
201010 15:14:16 version_check Done.
201010 15:14:16 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /mysql/data/mysql.sock
Using server version 5.7.28-log
innobackupex version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /mysql/data
xtrabackup: open files limit requested 65535, set to 65536
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = /mysql/data
xtrabackup: innodb_data_file_path = ibdata1:1G:autoextend
xtrabackup: innodb_log_group_home_dir = /mysql/data/
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 1073741824
InnoDB: Number of pools: 1
201010 15:14:17 >> log scanned up to (742343485)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0
201010 15:14:17 [01] Compressing /mysql/data/ibdata1 to /mysql/backuptest/ibdata1.qp
201010 15:14:18 >> log scanned up to (742343485)
201010 15:14:19 >> log scanned up to (742343485)
201010 15:14:20 >> log scanned up to (742343485)
201010 15:14:21 >> log scanned up to (742343485)
201010 15:14:22 >> log scanned up to (742343485)
201010 15:14:23 >> log scanned up to (742343485)
201010 15:14:24 >> log scanned up to (742343485)
201010 15:14:24 [01] ...done
201010 15:14:24 [01] Compressing ./mysql/plugin.ibd to /mysql/backuptest/mysql/plugin.ibd.qp
201010 15:14:24 [01] ...done
201010 15:14:24 [01] Compressing ./mysql/servers.ibd to /mysql/backuptest/mysql/servers.ibd.qp
201010 15:14:24 [01] ...done
201010 15:14:24 [01] Compressing ./mysql/help_topic.ibd to /mysql/backuptest/mysql/help_topic.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/help_category.ibd to /mysql/backuptest/mysql/help_category.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/help_relation.ibd to /mysql/backuptest/mysql/help_relation.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/help_keyword.ibd to /mysql/backuptest/mysql/help_keyword.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/time_zone_name.ibd to /mysql/backuptest/mysql/time_zone_name.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/time_zone.ibd to /mysql/backuptest/mysql/time_zone.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/time_zone_transition.ibd to /mysql/backuptest/mysql/time_zone_transition.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/time_zone_transition_type.ibd to /mysql/backuptest/mysql/time_zone_transition_type.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/time_zone_leap_second.ibd to /mysql/backuptest/mysql/time_zone_leap_second.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/innodb_table_stats.ibd to /mysql/backuptest/mysql/innodb_table_stats.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/innodb_index_stats.ibd to /mysql/backuptest/mysql/innodb_index_stats.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/slave_relay_log_info.ibd to /mysql/backuptest/mysql/slave_relay_log_info.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 >> log scanned up to (742343485)
201010 15:14:25 [01] Compressing ./mysql/slave_master_info.ibd to /mysql/backuptest/mysql/slave_master_info.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/slave_worker_info.ibd to /mysql/backuptest/mysql/slave_worker_info.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/gtid_executed.ibd to /mysql/backuptest/mysql/gtid_executed.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/server_cost.ibd to /mysql/backuptest/mysql/server_cost.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./mysql/engine_cost.ibd to /mysql/backuptest/mysql/engine_cost.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./sys/sys_config.ibd to /mysql/backuptest/sys/sys_config.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./webchat/medical.ibd to /mysql/backuptest/webchat/medical.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./webchat/medical_detail.ibd to /mysql/backuptest/webchat/medical_detail.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./webchat/hospital.ibd to /mysql/backuptest/webchat/hospital.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./webchat/person.ibd to /mysql/backuptest/webchat/person.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./webchat/hospital_bak.ibd to /mysql/backuptest/webchat/hospital_bak.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./webchat/p_person.ibd to /mysql/backuptest/webchat/p_person.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./webchat/p_hospital.ibd to /mysql/backuptest/webchat/p_hospital.ibd.qp
201010 15:14:25 [01] ...done
201010 15:14:25 [01] Compressing ./webchat/p_medical.ibd to /mysql/backuptest/webchat/p_medical.ibd.qp
201010 15:14:26 >> log scanned up to (742343485)
201010 15:14:27 >> log scanned up to (742343485)
201010 15:14:28 >> log scanned up to (742343485)
201010 15:14:29 >> log scanned up to (742343485)
201010 15:14:30 >> log scanned up to (742343485)
201010 15:14:30 [01] ...done
201010 15:14:30 [01] Compressing ./webchat/p_medical_detail.ibd to /mysql/backuptest/webchat/p_medical_detail.ibd.qp
201010 15:14:31 >> log scanned up to (742343485)
201010 15:14:32 >> log scanned up to (742343485)
201010 15:14:33 >> log scanned up to (742343485)
201010 15:14:34 >> log scanned up to (742343485)
201010 15:14:35 >> log scanned up to (742343485)
201010 15:14:36 >> log scanned up to (742343485)
201010 15:14:37 >> log scanned up to (742343485)
201010 15:14:38 >> log scanned up to (742343485)
201010 15:14:39 >> log scanned up to (742343485)
201010 15:14:40 >> log scanned up to (742343485)
201010 15:14:41 >> log scanned up to (742343485)
201010 15:14:42 >> log scanned up to (742343485)
201010 15:14:43 >> log scanned up to (742343485)
201010 15:14:44 >> log scanned up to (742343485)
201010 15:14:44 [01] ...done
201010 15:14:45 >> log scanned up to (742343485)
201010 15:14:45 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
201010 15:14:45 Executing FLUSH TABLES WITH READ LOCK...
201010 15:14:45 Starting to backup non-InnoDB tables and files
201010 15:14:45 [01] Compressing ./mysql/db.opt to /mysql/backuptest/mysql/db.opt.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/db.frm to /mysql/backuptest/mysql/db.frm.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/db.MYI to /mysql/backuptest/mysql/db.MYI.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/db.MYD to /mysql/backuptest/mysql/db.MYD.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/user.frm to /mysql/backuptest/mysql/user.frm.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/user.MYI to /mysql/backuptest/mysql/user.MYI.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/user.MYD to /mysql/backuptest/mysql/user.MYD.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/func.frm to /mysql/backuptest/mysql/func.frm.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/func.MYI to /mysql/backuptest/mysql/func.MYI.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/func.MYD to /mysql/backuptest/mysql/func.MYD.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/plugin.frm to /mysql/backuptest/mysql/plugin.frm.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/servers.frm to /mysql/backuptest/mysql/servers.frm.qp
201010 15:14:45 [01] ...done
201010 15:14:45 [01] Compressing ./mysql/tables_priv.frm to /mysql/backuptest/mysql/tables_priv.frm.qp
201010 15:14:45 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/tables_priv.MYI to /mysql/backuptest/mysql/tables_priv.MYI.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/tables_priv.MYD to /mysql/backuptest/mysql/tables_priv.MYD.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/columns_priv.frm to /mysql/backuptest/mysql/columns_priv.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/columns_priv.MYI to /mysql/backuptest/mysql/columns_priv.MYI.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/columns_priv.MYD to /mysql/backuptest/mysql/columns_priv.MYD.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/help_topic.frm to /mysql/backuptest/mysql/help_topic.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/help_category.frm to /mysql/backuptest/mysql/help_category.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/help_relation.frm to /mysql/backuptest/mysql/help_relation.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/help_keyword.frm to /mysql/backuptest/mysql/help_keyword.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/time_zone_name.frm to /mysql/backuptest/mysql/time_zone_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/time_zone.frm to /mysql/backuptest/mysql/time_zone.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/time_zone_transition.frm to /mysql/backuptest/mysql/time_zone_transition.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/time_zone_transition_type.frm to /mysql/backuptest/mysql/time_zone_transition_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/time_zone_leap_second.frm to /mysql/backuptest/mysql/time_zone_leap_second.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/proc.frm to /mysql/backuptest/mysql/proc.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/proc.MYI to /mysql/backuptest/mysql/proc.MYI.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/proc.MYD to /mysql/backuptest/mysql/proc.MYD.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/procs_priv.frm to /mysql/backuptest/mysql/procs_priv.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/procs_priv.MYI to /mysql/backuptest/mysql/procs_priv.MYI.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/procs_priv.MYD to /mysql/backuptest/mysql/procs_priv.MYD.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/general_log.frm to /mysql/backuptest/mysql/general_log.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/general_log.CSM to /mysql/backuptest/mysql/general_log.CSM.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/general_log.CSV to /mysql/backuptest/mysql/general_log.CSV.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/slow_log.frm to /mysql/backuptest/mysql/slow_log.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/slow_log.CSM to /mysql/backuptest/mysql/slow_log.CSM.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/slow_log.CSV to /mysql/backuptest/mysql/slow_log.CSV.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/event.frm to /mysql/backuptest/mysql/event.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/event.MYI to /mysql/backuptest/mysql/event.MYI.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/event.MYD to /mysql/backuptest/mysql/event.MYD.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/ndb_binlog_index.frm to /mysql/backuptest/mysql/ndb_binlog_index.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/ndb_binlog_index.MYI to /mysql/backuptest/mysql/ndb_binlog_index.MYI.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/ndb_binlog_index.MYD to /mysql/backuptest/mysql/ndb_binlog_index.MYD.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/innodb_table_stats.frm to /mysql/backuptest/mysql/innodb_table_stats.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/innodb_index_stats.frm to /mysql/backuptest/mysql/innodb_index_stats.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/slave_relay_log_info.frm to /mysql/backuptest/mysql/slave_relay_log_info.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/slave_master_info.frm to /mysql/backuptest/mysql/slave_master_info.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/slave_worker_info.frm to /mysql/backuptest/mysql/slave_worker_info.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/gtid_executed.frm to /mysql/backuptest/mysql/gtid_executed.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/server_cost.frm to /mysql/backuptest/mysql/server_cost.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/engine_cost.frm to /mysql/backuptest/mysql/engine_cost.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/proxies_priv.frm to /mysql/backuptest/mysql/proxies_priv.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/proxies_priv.MYI to /mysql/backuptest/mysql/proxies_priv.MYI.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./mysql/proxies_priv.MYD to /mysql/backuptest/mysql/proxies_priv.MYD.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/db.opt to /mysql/backuptest/performance_schema/db.opt.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/cond_instances.frm to /mysql/backuptest/performance_schema/cond_instances.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_waits_current.frm to /mysql/backuptest/performance_schema/events_waits_current.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_waits_history.frm to /mysql/backuptest/performance_schema/events_waits_history.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_waits_history_long.frm to /mysql/backuptest/performance_schema/events_waits_history_long.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_waits_summary_by_instance.frm to /mysql/backuptest/performance_schema/events_waits_summary_by_instance.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /mysql/backuptest/performance_schema/events_waits_summary_by_host_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /mysql/backuptest/performance_schema/events_waits_summary_by_user_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /mysql/backuptest/performance_schema/events_waits_summary_by_account_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /mysql/backuptest/performance_schema/events_waits_summary_by_thread_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_waits_summary_global_by_event_name.frm to /mysql/backuptest/performance_schema/events_waits_summary_global_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/file_instances.frm to /mysql/backuptest/performance_schema/file_instances.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/file_summary_by_event_name.frm to /mysql/backuptest/performance_schema/file_summary_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/file_summary_by_instance.frm to /mysql/backuptest/performance_schema/file_summary_by_instance.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/socket_instances.frm to /mysql/backuptest/performance_schema/socket_instances.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/socket_summary_by_instance.frm to /mysql/backuptest/performance_schema/socket_summary_by_instance.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/socket_summary_by_event_name.frm to /mysql/backuptest/performance_schema/socket_summary_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/host_cache.frm to /mysql/backuptest/performance_schema/host_cache.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/mutex_instances.frm to /mysql/backuptest/performance_schema/mutex_instances.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/objects_summary_global_by_type.frm to /mysql/backuptest/performance_schema/objects_summary_global_by_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/performance_timers.frm to /mysql/backuptest/performance_schema/performance_timers.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/rwlock_instances.frm to /mysql/backuptest/performance_schema/rwlock_instances.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/setup_actors.frm to /mysql/backuptest/performance_schema/setup_actors.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/setup_consumers.frm to /mysql/backuptest/performance_schema/setup_consumers.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/setup_instruments.frm to /mysql/backuptest/performance_schema/setup_instruments.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/setup_objects.frm to /mysql/backuptest/performance_schema/setup_objects.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/setup_timers.frm to /mysql/backuptest/performance_schema/setup_timers.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/table_io_waits_summary_by_index_usage.frm to /mysql/backuptest/performance_schema/table_io_waits_summary_by_index_usage.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/table_io_waits_summary_by_table.frm to /mysql/backuptest/performance_schema/table_io_waits_summary_by_table.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/table_lock_waits_summary_by_table.frm to /mysql/backuptest/performance_schema/table_lock_waits_summary_by_table.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/threads.frm to /mysql/backuptest/performance_schema/threads.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_stages_current.frm to /mysql/backuptest/performance_schema/events_stages_current.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_stages_history.frm to /mysql/backuptest/performance_schema/events_stages_history.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_stages_history_long.frm to /mysql/backuptest/performance_schema/events_stages_history_long.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /mysql/backuptest/performance_schema/events_stages_summary_by_thread_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /mysql/backuptest/performance_schema/events_stages_summary_by_host_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /mysql/backuptest/performance_schema/events_stages_summary_by_user_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /mysql/backuptest/performance_schema/events_stages_summary_by_account_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_stages_summary_global_by_event_name.frm to /mysql/backuptest/performance_schema/events_stages_summary_global_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_current.frm to /mysql/backuptest/performance_schema/events_statements_current.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_history.frm to /mysql/backuptest/performance_schema/events_statements_history.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_history_long.frm to /mysql/backuptest/performance_schema/events_statements_history_long.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /mysql/backuptest/performance_schema/events_statements_summary_by_thread_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /mysql/backuptest/performance_schema/events_statements_summary_by_host_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /mysql/backuptest/performance_schema/events_statements_summary_by_user_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /mysql/backuptest/performance_schema/events_statements_summary_by_account_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_summary_global_by_event_name.frm to /mysql/backuptest/performance_schema/events_statements_summary_global_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_transactions_current.frm to /mysql/backuptest/performance_schema/events_transactions_current.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_transactions_history.frm to /mysql/backuptest/performance_schema/events_transactions_history.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_transactions_history_long.frm to /mysql/backuptest/performance_schema/events_transactions_history_long.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /mysql/backuptest/performance_schema/events_transactions_summary_by_thread_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /mysql/backuptest/performance_schema/events_transactions_summary_by_host_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /mysql/backuptest/performance_schema/events_transactions_summary_by_user_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /mysql/backuptest/performance_schema/events_transactions_summary_by_account_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_transactions_summary_global_by_event_name.frm to /mysql/backuptest/performance_schema/events_transactions_summary_global_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/hosts.frm to /mysql/backuptest/performance_schema/hosts.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/users.frm to /mysql/backuptest/performance_schema/users.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/accounts.frm to /mysql/backuptest/performance_schema/accounts.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/memory_summary_global_by_event_name.frm to /mysql/backuptest/performance_schema/memory_summary_global_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/memory_summary_by_thread_by_event_name.frm to /mysql/backuptest/performance_schema/memory_summary_by_thread_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/memory_summary_by_account_by_event_name.frm to /mysql/backuptest/performance_schema/memory_summary_by_account_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/memory_summary_by_host_by_event_name.frm to /mysql/backuptest/performance_schema/memory_summary_by_host_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/memory_summary_by_user_by_event_name.frm to /mysql/backuptest/performance_schema/memory_summary_by_user_by_event_name.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_summary_by_digest.frm to /mysql/backuptest/performance_schema/events_statements_summary_by_digest.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/events_statements_summary_by_program.frm to /mysql/backuptest/performance_schema/events_statements_summary_by_program.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/prepared_statements_instances.frm to /mysql/backuptest/performance_schema/prepared_statements_instances.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/replication_connection_configuration.frm to /mysql/backuptest/performance_schema/replication_connection_configuration.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/replication_group_member_stats.frm to /mysql/backuptest/performance_schema/replication_group_member_stats.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/replication_group_members.frm to /mysql/backuptest/performance_schema/replication_group_members.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/replication_connection_status.frm to /mysql/backuptest/performance_schema/replication_connection_status.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/replication_applier_configuration.frm to /mysql/backuptest/performance_schema/replication_applier_configuration.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/replication_applier_status.frm to /mysql/backuptest/performance_schema/replication_applier_status.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/replication_applier_status_by_coordinator.frm to /mysql/backuptest/performance_schema/replication_applier_status_by_coordinator.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/replication_applier_status_by_worker.frm to /mysql/backuptest/performance_schema/replication_applier_status_by_worker.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/session_connect_attrs.frm to /mysql/backuptest/performance_schema/session_connect_attrs.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/session_account_connect_attrs.frm to /mysql/backuptest/performance_schema/session_account_connect_attrs.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/table_handles.frm to /mysql/backuptest/performance_schema/table_handles.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/metadata_locks.frm to /mysql/backuptest/performance_schema/metadata_locks.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/user_variables_by_thread.frm to /mysql/backuptest/performance_schema/user_variables_by_thread.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/variables_by_thread.frm to /mysql/backuptest/performance_schema/variables_by_thread.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/global_variables.frm to /mysql/backuptest/performance_schema/global_variables.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/session_variables.frm to /mysql/backuptest/performance_schema/session_variables.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/status_by_thread.frm to /mysql/backuptest/performance_schema/status_by_thread.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/status_by_user.frm to /mysql/backuptest/performance_schema/status_by_user.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/status_by_host.frm to /mysql/backuptest/performance_schema/status_by_host.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/status_by_account.frm to /mysql/backuptest/performance_schema/status_by_account.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/global_status.frm to /mysql/backuptest/performance_schema/global_status.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./performance_schema/session_status.frm to /mysql/backuptest/performance_schema/session_status.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/db.opt to /mysql/backuptest/sys/db.opt.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/version.frm to /mysql/backuptest/sys/version.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/sys_config.frm to /mysql/backuptest/sys/sys_config.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/statements_with_full_table_scans.frm to /mysql/backuptest/sys/statements_with_full_table_scans.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/sys_config_insert_set_user.TRN to /mysql/backuptest/sys/sys_config_insert_set_user.TRN.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/processlist.frm to /mysql/backuptest/sys/processlist.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/sys_config.TRG to /mysql/backuptest/sys/sys_config.TRG.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/statements_with_sorting.frm to /mysql/backuptest/sys/statements_with_sorting.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/sys_config_update_set_user.TRN to /mysql/backuptest/sys/sys_config_update_set_user.TRN.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024statements_with_sorting.frm to /mysql/backuptest/sys/x@0024statements_with_sorting.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/innodb_buffer_stats_by_schema.frm to /mysql/backuptest/sys/innodb_buffer_stats_by_schema.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/schema_index_statistics.frm to /mysql/backuptest/sys/schema_index_statistics.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024innodb_buffer_stats_by_schema.frm to /mysql/backuptest/sys/x@0024innodb_buffer_stats_by_schema.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/statements_with_temp_tables.frm to /mysql/backuptest/sys/statements_with_temp_tables.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/innodb_buffer_stats_by_table.frm to /mysql/backuptest/sys/innodb_buffer_stats_by_table.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024ps_schema_table_statistics_io.frm to /mysql/backuptest/sys/x@0024ps_schema_table_statistics_io.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024innodb_buffer_stats_by_table.frm to /mysql/backuptest/sys/x@0024innodb_buffer_stats_by_table.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/host_summary.frm to /mysql/backuptest/sys/host_summary.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/innodb_lock_waits.frm to /mysql/backuptest/sys/innodb_lock_waits.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024host_summary.frm to /mysql/backuptest/sys/x@0024host_summary.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024innodb_lock_waits.frm to /mysql/backuptest/sys/x@0024innodb_lock_waits.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/waits_by_user_by_latency.frm to /mysql/backuptest/sys/waits_by_user_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/schema_object_overview.frm to /mysql/backuptest/sys/schema_object_overview.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/user_summary_by_file_io_type.frm to /mysql/backuptest/sys/user_summary_by_file_io_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/schema_auto_increment_columns.frm to /mysql/backuptest/sys/schema_auto_increment_columns.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/user_summary_by_file_io.frm to /mysql/backuptest/sys/user_summary_by_file_io.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024schema_flattened_keys.frm to /mysql/backuptest/sys/x@0024schema_flattened_keys.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024user_summary_by_file_io.frm to /mysql/backuptest/sys/x@0024user_summary_by_file_io.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/schema_redundant_indexes.frm to /mysql/backuptest/sys/schema_redundant_indexes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/user_summary_by_statement_type.frm to /mysql/backuptest/sys/user_summary_by_statement_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/ps_check_lost_instrumentation.frm to /mysql/backuptest/sys/ps_check_lost_instrumentation.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/latest_file_io.frm to /mysql/backuptest/sys/latest_file_io.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/waits_by_host_by_latency.frm to /mysql/backuptest/sys/waits_by_host_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024latest_file_io.frm to /mysql/backuptest/sys/x@0024latest_file_io.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/waits_global_by_latency.frm to /mysql/backuptest/sys/waits_global_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/io_by_thread_by_latency.frm to /mysql/backuptest/sys/io_by_thread_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/user_summary_by_stages.frm to /mysql/backuptest/sys/user_summary_by_stages.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024io_by_thread_by_latency.frm to /mysql/backuptest/sys/x@0024io_by_thread_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024user_summary_by_stages.frm to /mysql/backuptest/sys/x@0024user_summary_by_stages.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/io_global_by_file_by_bytes.frm to /mysql/backuptest/sys/io_global_by_file_by_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024schema_index_statistics.frm to /mysql/backuptest/sys/x@0024schema_index_statistics.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024io_global_by_file_by_bytes.frm to /mysql/backuptest/sys/x@0024io_global_by_file_by_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/user_summary.frm to /mysql/backuptest/sys/user_summary.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/io_global_by_file_by_latency.frm to /mysql/backuptest/sys/io_global_by_file_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/schema_table_statistics.frm to /mysql/backuptest/sys/schema_table_statistics.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024io_global_by_file_by_latency.frm to /mysql/backuptest/sys/x@0024io_global_by_file_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024user_summary.frm to /mysql/backuptest/sys/x@0024user_summary.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/io_global_by_wait_by_bytes.frm to /mysql/backuptest/sys/io_global_by_wait_by_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024schema_table_statistics.frm to /mysql/backuptest/sys/x@0024schema_table_statistics.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024io_global_by_wait_by_bytes.frm to /mysql/backuptest/sys/x@0024io_global_by_wait_by_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/host_summary_by_file_io_type.frm to /mysql/backuptest/sys/host_summary_by_file_io_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/io_global_by_wait_by_latency.frm to /mysql/backuptest/sys/io_global_by_wait_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/schema_table_statistics_with_buffer.frm to /mysql/backuptest/sys/schema_table_statistics_with_buffer.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024io_global_by_wait_by_latency.frm to /mysql/backuptest/sys/x@0024io_global_by_wait_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/host_summary_by_file_io.frm to /mysql/backuptest/sys/host_summary_by_file_io.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/memory_by_user_by_current_bytes.frm to /mysql/backuptest/sys/memory_by_user_by_current_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/schema_table_lock_waits.frm to /mysql/backuptest/sys/schema_table_lock_waits.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024memory_by_user_by_current_bytes.frm to /mysql/backuptest/sys/x@0024memory_by_user_by_current_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024host_summary_by_file_io.frm to /mysql/backuptest/sys/x@0024host_summary_by_file_io.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/memory_by_host_by_current_bytes.frm to /mysql/backuptest/sys/memory_by_host_by_current_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024schema_table_lock_waits.frm to /mysql/backuptest/sys/x@0024schema_table_lock_waits.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024memory_by_host_by_current_bytes.frm to /mysql/backuptest/sys/x@0024memory_by_host_by_current_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/statement_analysis.frm to /mysql/backuptest/sys/statement_analysis.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/memory_by_thread_by_current_bytes.frm to /mysql/backuptest/sys/memory_by_thread_by_current_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024statement_analysis.frm to /mysql/backuptest/sys/x@0024statement_analysis.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 >> log scanned up to (742343485)
201010 15:14:46 [01] Compressing ./sys/x@0024memory_by_thread_by_current_bytes.frm to /mysql/backuptest/sys/x@0024memory_by_thread_by_current_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/host_summary_by_statement_type.frm to /mysql/backuptest/sys/host_summary_by_statement_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/memory_global_by_current_bytes.frm to /mysql/backuptest/sys/memory_global_by_current_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/statements_with_errors_or_warnings.frm to /mysql/backuptest/sys/statements_with_errors_or_warnings.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024memory_global_by_current_bytes.frm to /mysql/backuptest/sys/x@0024memory_global_by_current_bytes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/metrics.frm to /mysql/backuptest/sys/metrics.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/memory_global_total.frm to /mysql/backuptest/sys/memory_global_total.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/host_summary_by_stages.frm to /mysql/backuptest/sys/host_summary_by_stages.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024memory_global_total.frm to /mysql/backuptest/sys/x@0024memory_global_total.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/session.frm to /mysql/backuptest/sys/session.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024schema_table_statistics_with_buffer.frm to /mysql/backuptest/sys/x@0024schema_table_statistics_with_buffer.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024statements_with_errors_or_warnings.frm to /mysql/backuptest/sys/x@0024statements_with_errors_or_warnings.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/schema_tables_with_full_table_scans.frm to /mysql/backuptest/sys/schema_tables_with_full_table_scans.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/schema_unused_indexes.frm to /mysql/backuptest/sys/schema_unused_indexes.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024schema_tables_with_full_table_scans.frm to /mysql/backuptest/sys/x@0024schema_tables_with_full_table_scans.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024host_summary_by_stages.frm to /mysql/backuptest/sys/x@0024host_summary_by_stages.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024statements_with_full_table_scans.frm to /mysql/backuptest/sys/x@0024statements_with_full_table_scans.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024ps_digest_avg_latency_distribution.frm to /mysql/backuptest/sys/x@0024ps_digest_avg_latency_distribution.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /mysql/backuptest/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/statements_with_runtimes_in_95th_percentile.frm to /mysql/backuptest/sys/statements_with_runtimes_in_95th_percentile.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /mysql/backuptest/sys/x@0024statements_with_runtimes_in_95th_percentile.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024statements_with_temp_tables.frm to /mysql/backuptest/sys/x@0024statements_with_temp_tables.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024user_summary_by_file_io_type.frm to /mysql/backuptest/sys/x@0024user_summary_by_file_io_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024user_summary_by_statement_type.frm to /mysql/backuptest/sys/x@0024user_summary_by_statement_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/user_summary_by_statement_latency.frm to /mysql/backuptest/sys/user_summary_by_statement_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024user_summary_by_statement_latency.frm to /mysql/backuptest/sys/x@0024user_summary_by_statement_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024host_summary_by_file_io_type.frm to /mysql/backuptest/sys/x@0024host_summary_by_file_io_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024host_summary_by_statement_type.frm to /mysql/backuptest/sys/x@0024host_summary_by_statement_type.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/host_summary_by_statement_latency.frm to /mysql/backuptest/sys/host_summary_by_statement_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024host_summary_by_statement_latency.frm to /mysql/backuptest/sys/x@0024host_summary_by_statement_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/wait_classes_global_by_avg_latency.frm to /mysql/backuptest/sys/wait_classes_global_by_avg_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024wait_classes_global_by_avg_latency.frm to /mysql/backuptest/sys/x@0024wait_classes_global_by_avg_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/wait_classes_global_by_latency.frm to /mysql/backuptest/sys/wait_classes_global_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024wait_classes_global_by_latency.frm to /mysql/backuptest/sys/x@0024wait_classes_global_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024waits_by_user_by_latency.frm to /mysql/backuptest/sys/x@0024waits_by_user_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024waits_by_host_by_latency.frm to /mysql/backuptest/sys/x@0024waits_by_host_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024waits_global_by_latency.frm to /mysql/backuptest/sys/x@0024waits_global_by_latency.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024processlist.frm to /mysql/backuptest/sys/x@0024processlist.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/x@0024session.frm to /mysql/backuptest/sys/x@0024session.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./sys/session_ssl_status.frm to /mysql/backuptest/sys/session_ssl_status.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/db.opt to /mysql/backuptest/webchat/db.opt.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/medical.frm to /mysql/backuptest/webchat/medical.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/medical_detail.frm to /mysql/backuptest/webchat/medical_detail.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/hospital.frm to /mysql/backuptest/webchat/hospital.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/person.frm to /mysql/backuptest/webchat/person.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/hospital_bak.frm to /mysql/backuptest/webchat/hospital_bak.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/p_person.frm to /mysql/backuptest/webchat/p_person.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/p_hospital.frm to /mysql/backuptest/webchat/p_hospital.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/p_medical.frm to /mysql/backuptest/webchat/p_medical.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 [01] Compressing ./webchat/p_medical_detail.frm to /mysql/backuptest/webchat/p_medical_detail.frm.qp
201010 15:14:46 [01] ...done
201010 15:14:46 Finished backing up non-InnoDB tables and files
201010 15:14:46 [00] Compressing /mysql/backuptest/xtrabackup_binlog_info.qp
201010 15:14:46 [00] ...done
201010 15:14:46 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '742343476'
xtrabackup: Stopping log copying thread.
.201010 15:14:46 >> log scanned up to (742343485)
201010 15:14:46 Executing UNLOCK TABLES
201010 15:14:46 All tables unlocked
201010 15:14:46 [00] Compressing ib_buffer_pool to /mysql/backuptest/ib_buffer_pool.qp
201010 15:14:46 [00] ...done
201010 15:14:46 Backup created in directory '/mysql/backuptest/'
MySQL binlog position: filename 'mysql-bin.000094', position '81517132', GTID of the last change 'e2c01e98-128a-11ea-af5f-000c298b9c0b:1-618'
201010 15:14:46 [00] Compressing /mysql/backuptest/backup-my.cnf.qp
201010 15:14:46 [00] ...done
201010 15:14:46 [00] Compressing /mysql/backuptest/xtrabackup_info.qp
201010 15:14:46 [00] ...done
xtrabackup: Transaction log of lsn (742343476) to (742343485) was copied.
201010 15:14:47 completed OK!
查看经过官方命令压缩的备份大小：
[root@node15 backuptest]# du -sh
325M .
利用管道、gzip压缩的备份
[root@node15 backuptest]# innobackupex --defaults-file=/etc/my.cnf --no-timestamp --user root --password 'root$123' --stream=tar /mysql/data | gzip - > /mysql/backuptest/backup.tar.gz
输出：
xtrabackup: recognized server arguments: --server-id=1133015 --datadir=/mysql/data --innodb_buffer_pool_size=512M --innodb_file_per_table=1 --innodb_data_home_dir=/mysql/data --innodb_data_file_path=ibdata1:1G:autoextend --innodb_log_group_home_dir=/mysql/data/ --innodb_log_files_in_group=3 --innodb_log_file_size=1G --innodb_log_buffer_size=32M --innodb_flush_log_at_trx_commit=2 --innodb_io_capacity=2000 --innodb_max_dirty_pages_pct=40 --open_files_limit=65535 --log_bin=/mysql/log/mysql-bin
xtrabackup: recognized client arguments:
201010 15:12:12 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
201010 15:12:12 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/mysql/data/mysql.sock' as 'root' (using password: YES).
201010 15:12:12 version_check Connected to MySQL server
201010 15:12:12 version_check Executing a version check against the server...
201010 15:12:12 version_check Done.
201010 15:12:12 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /mysql/data/mysql.sock
Using server version 5.7.28-log
innobackupex version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /mysql/data
xtrabackup: open files limit requested 65535, set to 65536
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = /mysql/data
xtrabackup: innodb_data_file_path = ibdata1:1G:autoextend
xtrabackup: innodb_log_group_home_dir = /mysql/data/
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 1073741824
InnoDB: Number of pools: 1
201010 15:12:12 >> log scanned up to (742343485)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0
201010 15:12:13 [01] Streaming /mysql/data/ibdata1
201010 15:12:13 >> log scanned up to (742343485)
201010 15:12:14 >> log scanned up to (742343485)
201010 15:12:15 >> log scanned up to (742343485)
201010 15:12:16 >> log scanned up to (742343485)
201010 15:12:17 >> log scanned up to (742343485)
201010 15:12:18 >> log scanned up to (742343485)
201010 15:12:19 >> log scanned up to (742343485)
201010 15:12:20 >> log scanned up to (742343485)
201010 15:12:21 >> log scanned up to (742343485)
201010 15:12:22 >> log scanned up to (742343485)
201010 15:12:23 >> log scanned up to (742343485)
201010 15:12:24 >> log scanned up to (742343485)
201010 15:12:25 >> log scanned up to (742343485)
201010 15:12:26 >> log scanned up to (742343485)
201010 15:12:27 >> log scanned up to (742343485)
201010 15:12:28 >> log scanned up to (742343485)
201010 15:12:29 >> log scanned up to (742343485)
201010 15:12:30 >> log scanned up to (742343485)
201010 15:12:31 >> log scanned up to (742343485)
201010 15:12:32 >> log scanned up to (742343485)
201010 15:12:33 >> log scanned up to (742343485)
201010 15:12:34 >> log scanned up to (742343485)
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/plugin.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/servers.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/help_topic.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/help_category.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/help_relation.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/help_keyword.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/time_zone_name.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/time_zone.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/time_zone_transition.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/time_zone_transition_type.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/time_zone_leap_second.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/innodb_table_stats.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/innodb_index_stats.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/slave_relay_log_info.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/slave_master_info.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/slave_worker_info.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/gtid_executed.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/server_cost.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./mysql/engine_cost.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./sys/sys_config.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./webchat/medical.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./webchat/medical_detail.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./webchat/hospital.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./webchat/person.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./webchat/hospital_bak.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./webchat/p_person.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./webchat/p_hospital.ibd
201010 15:12:35 [01] ...done
201010 15:12:35 [01] Streaming ./webchat/p_medical.ibd
201010 15:12:35 >> log scanned up to (742343485)
201010 15:12:36 >> log scanned up to (742343485)
201010 15:12:38 >> log scanned up to (742343485)
201010 15:12:39 >> log scanned up to (742343485)
201010 15:12:40 >> log scanned up to (742343485)
201010 15:12:41 >> log scanned up to (742343485)
201010 15:12:42 >> log scanned up to (742343485)
201010 15:12:43 >> log scanned up to (742343485)
201010 15:12:44 >> log scanned up to (742343485)
201010 15:12:45 >> log scanned up to (742343485)
201010 15:12:46 >> log scanned up to (742343485)
201010 15:12:47 >> log scanned up to (742343485)
201010 15:12:48 >> log scanned up to (742343485)
201010 15:12:49 >> log scanned up to (742343485)
201010 15:12:50 >> log scanned up to (742343485)
201010 15:12:50 [01] ...done
201010 15:12:50 [01] Streaming ./webchat/p_medical_detail.ibd
201010 15:12:51 >> log scanned up to (742343485)
201010 15:12:52 >> log scanned up to (742343485)
201010 15:12:53 >> log scanned up to (742343485)
201010 15:12:54 >> log scanned up to (742343485)
201010 15:12:55 >> log scanned up to (742343485)
201010 15:12:56 >> log scanned up to (742343485)
201010 15:12:57 >> log scanned up to (742343485)
201010 15:12:58 >> log scanned up to (742343485)
201010 15:12:59 >> log scanned up to (742343485)
201010 15:13:00 >> log scanned up to (742343485)
201010 15:13:01 >> log scanned up to (742343485)
201010 15:13:02 >> log scanned up to (742343485)
201010 15:13:03 >> log scanned up to (742343485)
201010 15:13:04 >> log scanned up to (742343485)
201010 15:13:05 >> log scanned up to (742343485)
201010 15:13:06 >> log scanned up to (742343485)
201010 15:13:07 >> log scanned up to (742343485)
201010 15:13:08 >> log scanned up to (742343485)
201010 15:13:09 >> log scanned up to (742343485)
201010 15:13:10 >> log scanned up to (742343485)
201010 15:13:11 >> log scanned up to (742343485)
201010 15:13:12 >> log scanned up to (742343485)
201010 15:13:13 >> log scanned up to (742343485)
201010 15:13:14 >> log scanned up to (742343485)
201010 15:13:15 >> log scanned up to (742343485)
201010 15:13:16 >> log scanned up to (742343485)
201010 15:13:17 >> log scanned up to (742343485)
201010 15:13:18 >> log scanned up to (742343485)
201010 15:13:19 >> log scanned up to (742343485)
201010 15:13:20 >> log scanned up to (742343485)
201010 15:13:21 >> log scanned up to (742343485)
201010 15:13:22 >> log scanned up to (742343485)
201010 15:13:23 >> log scanned up to (742343485)
201010 15:13:24 >> log scanned up to (742343485)
201010 15:13:25 >> log scanned up to (742343485)
201010 15:13:26 >> log scanned up to (742343485)
201010 15:13:27 >> log scanned up to (742343485)
201010 15:13:28 >> log scanned up to (742343485)
201010 15:13:29 >> log scanned up to (742343485)
201010 15:13:30 >> log scanned up to (742343485)
201010 15:13:31 >> log scanned up to (742343485)
201010 15:13:32 >> log scanned up to (742343485)
201010 15:13:33 >> log scanned up to (742343485)
201010 15:13:34 >> log scanned up to (742343485)
201010 15:13:34 [01] ...done
201010 15:13:35 >> log scanned up to (742343485)
201010 15:13:35 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
201010 15:13:35 Executing FLUSH TABLES WITH READ LOCK...
201010 15:13:35 Starting to backup non-InnoDB tables and files
201010 15:13:35 [01] Streaming ./mysql/db.opt to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/db.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/db.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/db.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/user.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/user.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/user.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/func.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/func.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/func.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/plugin.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/servers.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/tables_priv.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/tables_priv.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/tables_priv.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/columns_priv.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/columns_priv.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/columns_priv.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/help_topic.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/help_category.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/help_relation.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/help_keyword.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/time_zone_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/time_zone.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/time_zone_transition.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/time_zone_transition_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/time_zone_leap_second.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/proc.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/proc.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/proc.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/procs_priv.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/procs_priv.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/procs_priv.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/general_log.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/general_log.CSM to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/general_log.CSV to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/slow_log.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/slow_log.CSM to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/slow_log.CSV to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/event.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/event.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/event.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/ndb_binlog_index.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/ndb_binlog_index.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/ndb_binlog_index.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/innodb_table_stats.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/innodb_index_stats.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/slave_relay_log_info.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/slave_master_info.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/slave_worker_info.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/gtid_executed.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/server_cost.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/engine_cost.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/proxies_priv.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/proxies_priv.MYI to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./mysql/proxies_priv.MYD to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/db.opt to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/cond_instances.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_waits_current.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_waits_history.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_waits_history_long.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_waits_summary_by_instance.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_waits_summary_by_host_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_waits_summary_by_user_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_waits_summary_by_account_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_waits_summary_global_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/file_instances.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/file_summary_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/file_summary_by_instance.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/socket_instances.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/socket_summary_by_instance.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/socket_summary_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/host_cache.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/mutex_instances.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/objects_summary_global_by_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/performance_timers.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/rwlock_instances.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/setup_actors.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/setup_consumers.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/setup_instruments.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/setup_objects.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/setup_timers.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/table_io_waits_summary_by_index_usage.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/table_io_waits_summary_by_table.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/table_lock_waits_summary_by_table.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/threads.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_stages_current.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_stages_history.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_stages_history_long.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_stages_summary_by_host_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_stages_summary_by_user_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_stages_summary_by_account_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_stages_summary_global_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_current.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_history.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_history_long.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_summary_by_host_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_summary_by_user_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_summary_by_account_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_summary_global_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_transactions_current.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_transactions_history.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_transactions_history_long.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_transactions_summary_global_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/hosts.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/users.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/accounts.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/memory_summary_global_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/memory_summary_by_thread_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/memory_summary_by_account_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/memory_summary_by_host_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/memory_summary_by_user_by_event_name.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_summary_by_digest.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/events_statements_summary_by_program.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/prepared_statements_instances.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/replication_connection_configuration.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/replication_group_member_stats.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/replication_group_members.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/replication_connection_status.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/replication_applier_configuration.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/replication_applier_status.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/replication_applier_status_by_coordinator.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/replication_applier_status_by_worker.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/session_connect_attrs.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/session_account_connect_attrs.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/table_handles.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/metadata_locks.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/user_variables_by_thread.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/variables_by_thread.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/global_variables.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/session_variables.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/status_by_thread.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/status_by_user.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/status_by_host.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/status_by_account.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/global_status.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./performance_schema/session_status.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/db.opt to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/version.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/sys_config.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/statements_with_full_table_scans.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/sys_config_insert_set_user.TRN to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/processlist.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/sys_config.TRG to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/statements_with_sorting.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/sys_config_update_set_user.TRN to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024statements_with_sorting.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/innodb_buffer_stats_by_schema.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/schema_index_statistics.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024innodb_buffer_stats_by_schema.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/statements_with_temp_tables.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/innodb_buffer_stats_by_table.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024ps_schema_table_statistics_io.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024innodb_buffer_stats_by_table.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/host_summary.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/innodb_lock_waits.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024host_summary.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024innodb_lock_waits.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/waits_by_user_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/schema_object_overview.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/user_summary_by_file_io_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/schema_auto_increment_columns.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/user_summary_by_file_io.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024schema_flattened_keys.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024user_summary_by_file_io.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/schema_redundant_indexes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/user_summary_by_statement_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/ps_check_lost_instrumentation.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/latest_file_io.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/waits_by_host_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024latest_file_io.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/waits_global_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/io_by_thread_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/user_summary_by_stages.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024io_by_thread_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024user_summary_by_stages.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/io_global_by_file_by_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024schema_index_statistics.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024io_global_by_file_by_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/user_summary.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/io_global_by_file_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/schema_table_statistics.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024io_global_by_file_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024user_summary.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/io_global_by_wait_by_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024schema_table_statistics.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024io_global_by_wait_by_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/host_summary_by_file_io_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/io_global_by_wait_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/schema_table_statistics_with_buffer.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024io_global_by_wait_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/host_summary_by_file_io.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/memory_by_user_by_current_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/schema_table_lock_waits.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024memory_by_user_by_current_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024host_summary_by_file_io.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/memory_by_host_by_current_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024schema_table_lock_waits.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024memory_by_host_by_current_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/statement_analysis.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/memory_by_thread_by_current_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024statement_analysis.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024memory_by_thread_by_current_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/host_summary_by_statement_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/memory_global_by_current_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/statements_with_errors_or_warnings.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024memory_global_by_current_bytes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/metrics.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/memory_global_total.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/host_summary_by_stages.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024memory_global_total.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/session.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024schema_table_statistics_with_buffer.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024statements_with_errors_or_warnings.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/schema_tables_with_full_table_scans.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/schema_unused_indexes.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024schema_tables_with_full_table_scans.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024host_summary_by_stages.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024statements_with_full_table_scans.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024ps_digest_avg_latency_distribution.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/statements_with_runtimes_in_95th_percentile.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024statements_with_temp_tables.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024user_summary_by_file_io_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024user_summary_by_statement_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/user_summary_by_statement_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024user_summary_by_statement_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024host_summary_by_file_io_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024host_summary_by_statement_type.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/host_summary_by_statement_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024host_summary_by_statement_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/wait_classes_global_by_avg_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024wait_classes_global_by_avg_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/wait_classes_global_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024wait_classes_global_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024waits_by_user_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024waits_by_host_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024waits_global_by_latency.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024processlist.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/x@0024session.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./sys/session_ssl_status.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/db.opt to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/medical.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/medical_detail.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/hospital.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/person.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/hospital_bak.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/p_person.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/p_hospital.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/p_medical.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 [01] Streaming ./webchat/p_medical_detail.frm to <STDOUT>
201010 15:13:35 [01] ...done
201010 15:13:35 Finished backing up non-InnoDB tables and files
201010 15:13:35 [00] Streaming <STDOUT>
201010 15:13:35 [00] ...done
201010 15:13:35 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '742343476'
xtrabackup: Stopping log copying thread.
.201010 15:13:35 >> log scanned up to (742343485)
201010 15:13:36 Executing UNLOCK TABLES
201010 15:13:36 All tables unlocked
201010 15:13:36 [00] Streaming ib_buffer_pool to <STDOUT>
201010 15:13:36 [00] ...done
201010 15:13:36 Backup created in directory '/mysql/data/'
MySQL binlog position: filename 'mysql-bin.000094', position '81517132', GTID of the last change 'e2c01e98-128a-11ea-af5f-000c298b9c0b:1-618'
201010 15:13:36 [00] Streaming <STDOUT>
201010 15:13:36 [00] ...done
201010 15:13:36 [00] Streaming <STDOUT>
201010 15:13:36 [00] ...done
xtrabackup: Transaction log of lsn (742343476) to (742343485) was copied.
201010 15:13:36 completed OK!
[root@node15 backuptest]# ll
总用量 223364
-rw-r--r-- 1 root root 228722890 10月 10 15:13 backup.tar.gz
查看该备份的大小：
[root@node15 backuptest]# du -sh
219M .
恢复
普通恢复
预热
[root@node15 2020-10-10_17-20-39]# innobackupex --apply-log /mysql/backuptest/2020-10-10_17-20-39/
xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:1G:autoextend --innodb_log_files_in_group=3 --innodb_log_file_size=1073741824 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=1133015 --redo-log-version=1
xtrabackup: recognized client arguments:
201012 09:17:40 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints "completed OK!".
innobackupex version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056)
xtrabackup: cd to /mysql/backuptest/2020-10-10_17-20-39/
xtrabackup: This target seems to be already prepared.
InnoDB: Number of pools: 1
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:1G:autoextend
xtrabackup: innodb_log_group_home_dir = .
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 1073741824
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:1G:autoextend
xtrabackup: innodb_log_group_home_dir = .
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 1073741824
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: PUNCH HOLE support available
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Uses event mutexes
InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
InnoDB: Compressed tables use zlib 1.2.7
InnoDB: Number of pools: 1
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
InnoDB: Completed initialization of buffer pool
InnoDB: page_cleaner coordinator priority: -20
InnoDB: Highest supported file format is Barracuda.
InnoDB: Removed temporary tablespace data file: "ibtmp1"
InnoDB: Creating shared tablespace for temporary tables
InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
InnoDB: File './ibtmp1' size is now 12 MB.
InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active.
InnoDB: 32 non-redo rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.7.26 started; log sequence number 742346792
InnoDB: xtrabackup: Last MySQL binlog file position 81517132, file name mysql-bin.000094
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 742346811
InnoDB: Number of pools: 1
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:1G:autoextend
xtrabackup: innodb_log_group_home_dir = .
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 1073741824
InnoDB: PUNCH HOLE support available
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Uses event mutexes
InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
InnoDB: Compressed tables use zlib 1.2.7
InnoDB: Number of pools: 1
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
InnoDB: Completed initialization of buffer pool
InnoDB: page_cleaner coordinator priority: -20
InnoDB: Highest supported file format is Barracuda.
InnoDB: Removed temporary tablespace data file: "ibtmp1"
InnoDB: Creating shared tablespace for temporary tables
InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
InnoDB: File './ibtmp1' size is now 12 MB.
InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active.
InnoDB: 32 non-redo rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.7.26 started; log sequence number 742346811
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 742346830
201012 09:17:45 completed OK!
恢复
目录必须为空目录，否则无法恢复：
[root@node15 2020-10-10_17-20-39]# innobackupex --copy-back /mysql/
backuptest/ data/ data_bak/ lock/ log/ service/
[root@node15 2020-10-10_17-20-39]# innobackupex --copy-back /mysql/backuptest/2020-10-10_17-20-39/
xtrabackup: recognized server arguments: --server-id=1133015 --datadir=/mysql/data --innodb_buffer_pool_size=512M --innodb_file_per_table=1 --innodb_data_home_dir=/mysql/data --innodb_data_file_path=ibdata1:1G:autoextend --innodb_log_group_home_dir=/mysql/data/ --innodb_log_files_in_group=3 --innodb_log_file_size=1G --innodb_log_buffer_size=32M --innodb_flush_log_at_trx_commit=2 --innodb_io_capacity=2000 --innodb_max_dirty_pages_pct=40 --open_files_limit=65535 --log_bin=/mysql/log/mysql-bin
xtrabackup: recognized client arguments:
201012 09:21:25 innobackupex: Starting the copy-back operation
IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex
prints "completed OK!".
innobackupex version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056)
Original data directory /mysql/data is not empty!
正常恢复流程：
[root@node15 2020-10-10_17-20-39]# innobackupex --copy-back /mysql/backuptest/2020-10-10_17-20-39/
xtrabackup: recognized server arguments: --server-id=1133015 --datadir=/mysql/data --innodb_buffer_pool_size=512M --innodb_file_per_table=1 --innodb_data_home_dir=/mysql/data --innodb_data_file_path=ibdata1:1G:autoextend --innodb_log_group_home_dir=/mysql/data/ --innodb_log_files_in_group=3 --innodb_log_file_size=1G --innodb_log_buffer_size=32M --innodb_flush_log_at_trx_commit=2 --innodb_io_capacity=2000 --innodb_max_dirty_pages_pct=40 --open_files_limit=65535 --log_bin=/mysql/log/mysql-bin
xtrabackup: recognized client arguments:
201012 09:21:38 innobackupex: Starting the copy-back operation
IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex
prints "completed OK!".
innobackupex version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056)
201012 09:21:38 [01] Copying ib_logfile0 to /mysql/data/ib_logfile0
201012 09:21:50 [01] ...done
201012 09:21:50 [01] Copying ib_logfile1 to /mysql/data/ib_logfile1
201012 09:21:57 [01] ...done
201012 09:21:57 [01] Copying ib_logfile2 to /mysql/data/ib_logfile2
201012 09:22:02 [01] ...done
201012 09:22:02 [01] Copying ibdata1 to /mysql/data/ibdata1
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/plugin.ibd to /mysql/data/mysql/plugin.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/servers.ibd to /mysql/data/mysql/servers.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/help_topic.ibd to /mysql/data/mysql/help_topic.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/help_category.ibd to /mysql/data/mysql/help_category.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/help_relation.ibd to /mysql/data/mysql/help_relation.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/help_keyword.ibd to /mysql/data/mysql/help_keyword.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone_name.ibd to /mysql/data/mysql/time_zone_name.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone.ibd to /mysql/data/mysql/time_zone.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone_transition.ibd to /mysql/data/mysql/time_zone_transition.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone_transition_type.ibd to /mysql/data/mysql/time_zone_transition_type.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone_leap_second.ibd to /mysql/data/mysql/time_zone_leap_second.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/innodb_table_stats.ibd to /mysql/data/mysql/innodb_table_stats.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/innodb_index_stats.ibd to /mysql/data/mysql/innodb_index_stats.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/slave_relay_log_info.ibd to /mysql/data/mysql/slave_relay_log_info.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/slave_master_info.ibd to /mysql/data/mysql/slave_master_info.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/slave_worker_info.ibd to /mysql/data/mysql/slave_worker_info.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/gtid_executed.ibd to /mysql/data/mysql/gtid_executed.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/server_cost.ibd to /mysql/data/mysql/server_cost.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/engine_cost.ibd to /mysql/data/mysql/engine_cost.ibd
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/db.opt to /mysql/data/mysql/db.opt
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/db.frm to /mysql/data/mysql/db.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/db.MYI to /mysql/data/mysql/db.MYI
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/db.MYD to /mysql/data/mysql/db.MYD
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/user.frm to /mysql/data/mysql/user.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/user.MYI to /mysql/data/mysql/user.MYI
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/user.MYD to /mysql/data/mysql/user.MYD
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/func.frm to /mysql/data/mysql/func.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/func.MYI to /mysql/data/mysql/func.MYI
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/func.MYD to /mysql/data/mysql/func.MYD
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/plugin.frm to /mysql/data/mysql/plugin.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/servers.frm to /mysql/data/mysql/servers.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/tables_priv.frm to /mysql/data/mysql/tables_priv.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/tables_priv.MYI to /mysql/data/mysql/tables_priv.MYI
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/tables_priv.MYD to /mysql/data/mysql/tables_priv.MYD
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/columns_priv.frm to /mysql/data/mysql/columns_priv.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/columns_priv.MYI to /mysql/data/mysql/columns_priv.MYI
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/columns_priv.MYD to /mysql/data/mysql/columns_priv.MYD
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/help_topic.frm to /mysql/data/mysql/help_topic.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/help_category.frm to /mysql/data/mysql/help_category.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/help_relation.frm to /mysql/data/mysql/help_relation.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/help_keyword.frm to /mysql/data/mysql/help_keyword.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone_name.frm to /mysql/data/mysql/time_zone_name.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone.frm to /mysql/data/mysql/time_zone.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone_transition.frm to /mysql/data/mysql/time_zone_transition.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone_transition_type.frm to /mysql/data/mysql/time_zone_transition_type.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/time_zone_leap_second.frm to /mysql/data/mysql/time_zone_leap_second.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/proc.frm to /mysql/data/mysql/proc.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/proc.MYI to /mysql/data/mysql/proc.MYI
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/proc.MYD to /mysql/data/mysql/proc.MYD
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/procs_priv.frm to /mysql/data/mysql/procs_priv.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/procs_priv.MYI to /mysql/data/mysql/procs_priv.MYI
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/procs_priv.MYD to /mysql/data/mysql/procs_priv.MYD
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/general_log.frm to /mysql/data/mysql/general_log.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/general_log.CSM to /mysql/data/mysql/general_log.CSM
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/general_log.CSV to /mysql/data/mysql/general_log.CSV
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/slow_log.frm to /mysql/data/mysql/slow_log.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/slow_log.CSM to /mysql/data/mysql/slow_log.CSM
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/slow_log.CSV to /mysql/data/mysql/slow_log.CSV
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/event.frm to /mysql/data/mysql/event.frm
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/event.MYI to /mysql/data/mysql/event.MYI
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/event.MYD to /mysql/data/mysql/event.MYD
201012 09:22:10 [01] ...done
201012 09:22:10 [01] Copying ./mysql/ndb_binlog_index.frm to /mysql/data/mysql/ndb_binlog_index.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/ndb_binlog_index.MYI to /mysql/data/mysql/ndb_binlog_index.MYI
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/ndb_binlog_index.MYD to /mysql/data/mysql/ndb_binlog_index.MYD
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/innodb_table_stats.frm to /mysql/data/mysql/innodb_table_stats.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/innodb_index_stats.frm to /mysql/data/mysql/innodb_index_stats.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/slave_relay_log_info.frm to /mysql/data/mysql/slave_relay_log_info.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/slave_master_info.frm to /mysql/data/mysql/slave_master_info.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/slave_worker_info.frm to /mysql/data/mysql/slave_worker_info.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/gtid_executed.frm to /mysql/data/mysql/gtid_executed.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/server_cost.frm to /mysql/data/mysql/server_cost.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/engine_cost.frm to /mysql/data/mysql/engine_cost.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/proxies_priv.frm to /mysql/data/mysql/proxies_priv.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/proxies_priv.MYI to /mysql/data/mysql/proxies_priv.MYI
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./mysql/proxies_priv.MYD to /mysql/data/mysql/proxies_priv.MYD
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/sys_config.ibd to /mysql/data/sys/sys_config.ibd
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/db.opt to /mysql/data/sys/db.opt
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/version.frm to /mysql/data/sys/version.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/sys_config.frm to /mysql/data/sys/sys_config.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/statements_with_full_table_scans.frm to /mysql/data/sys/statements_with_full_table_scans.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/sys_config_insert_set_user.TRN to /mysql/data/sys/sys_config_insert_set_user.TRN
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/processlist.frm to /mysql/data/sys/processlist.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/sys_config.TRG to /mysql/data/sys/sys_config.TRG
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/statements_with_sorting.frm to /mysql/data/sys/statements_with_sorting.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/sys_config_update_set_user.TRN to /mysql/data/sys/sys_config_update_set_user.TRN
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024statements_with_sorting.frm to /mysql/data/sys/x@0024statements_with_sorting.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /mysql/data/sys/innodb_buffer_stats_by_schema.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/schema_index_statistics.frm to /mysql/data/sys/schema_index_statistics.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /mysql/data/sys/x@0024innodb_buffer_stats_by_schema.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/statements_with_temp_tables.frm to /mysql/data/sys/statements_with_temp_tables.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /mysql/data/sys/innodb_buffer_stats_by_table.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /mysql/data/sys/x@0024ps_schema_table_statistics_io.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /mysql/data/sys/x@0024innodb_buffer_stats_by_table.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/host_summary.frm to /mysql/data/sys/host_summary.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/innodb_lock_waits.frm to /mysql/data/sys/innodb_lock_waits.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024host_summary.frm to /mysql/data/sys/x@0024host_summary.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /mysql/data/sys/x@0024innodb_lock_waits.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/waits_by_user_by_latency.frm to /mysql/data/sys/waits_by_user_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/schema_object_overview.frm to /mysql/data/sys/schema_object_overview.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/user_summary_by_file_io_type.frm to /mysql/data/sys/user_summary_by_file_io_type.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/schema_auto_increment_columns.frm to /mysql/data/sys/schema_auto_increment_columns.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/user_summary_by_file_io.frm to /mysql/data/sys/user_summary_by_file_io.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /mysql/data/sys/x@0024schema_flattened_keys.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /mysql/data/sys/x@0024user_summary_by_file_io.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/schema_redundant_indexes.frm to /mysql/data/sys/schema_redundant_indexes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/user_summary_by_statement_type.frm to /mysql/data/sys/user_summary_by_statement_type.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /mysql/data/sys/ps_check_lost_instrumentation.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/latest_file_io.frm to /mysql/data/sys/latest_file_io.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/waits_by_host_by_latency.frm to /mysql/data/sys/waits_by_host_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024latest_file_io.frm to /mysql/data/sys/x@0024latest_file_io.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/waits_global_by_latency.frm to /mysql/data/sys/waits_global_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/io_by_thread_by_latency.frm to /mysql/data/sys/io_by_thread_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/user_summary_by_stages.frm to /mysql/data/sys/user_summary_by_stages.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /mysql/data/sys/x@0024io_by_thread_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /mysql/data/sys/x@0024user_summary_by_stages.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /mysql/data/sys/io_global_by_file_by_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024schema_index_statistics.frm to /mysql/data/sys/x@0024schema_index_statistics.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /mysql/data/sys/x@0024io_global_by_file_by_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/user_summary.frm to /mysql/data/sys/user_summary.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/io_global_by_file_by_latency.frm to /mysql/data/sys/io_global_by_file_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/schema_table_statistics.frm to /mysql/data/sys/schema_table_statistics.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /mysql/data/sys/x@0024io_global_by_file_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024user_summary.frm to /mysql/data/sys/x@0024user_summary.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /mysql/data/sys/io_global_by_wait_by_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024schema_table_statistics.frm to /mysql/data/sys/x@0024schema_table_statistics.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /mysql/data/sys/x@0024io_global_by_wait_by_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/host_summary_by_file_io_type.frm to /mysql/data/sys/host_summary_by_file_io_type.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /mysql/data/sys/io_global_by_wait_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /mysql/data/sys/schema_table_statistics_with_buffer.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /mysql/data/sys/x@0024io_global_by_wait_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/host_summary_by_file_io.frm to /mysql/data/sys/host_summary_by_file_io.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /mysql/data/sys/memory_by_user_by_current_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/schema_table_lock_waits.frm to /mysql/data/sys/schema_table_lock_waits.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /mysql/data/sys/x@0024memory_by_user_by_current_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /mysql/data/sys/x@0024host_summary_by_file_io.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /mysql/data/sys/memory_by_host_by_current_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /mysql/data/sys/x@0024schema_table_lock_waits.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /mysql/data/sys/x@0024memory_by_host_by_current_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/statement_analysis.frm to /mysql/data/sys/statement_analysis.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /mysql/data/sys/memory_by_thread_by_current_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024statement_analysis.frm to /mysql/data/sys/x@0024statement_analysis.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /mysql/data/sys/x@0024memory_by_thread_by_current_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/host_summary_by_statement_type.frm to /mysql/data/sys/host_summary_by_statement_type.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/memory_global_by_current_bytes.frm to /mysql/data/sys/memory_global_by_current_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /mysql/data/sys/statements_with_errors_or_warnings.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /mysql/data/sys/x@0024memory_global_by_current_bytes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/metrics.frm to /mysql/data/sys/metrics.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/memory_global_total.frm to /mysql/data/sys/memory_global_total.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/host_summary_by_stages.frm to /mysql/data/sys/host_summary_by_stages.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024memory_global_total.frm to /mysql/data/sys/x@0024memory_global_total.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/session.frm to /mysql/data/sys/session.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /mysql/data/sys/x@0024schema_table_statistics_with_buffer.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /mysql/data/sys/x@0024statements_with_errors_or_warnings.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /mysql/data/sys/schema_tables_with_full_table_scans.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/schema_unused_indexes.frm to /mysql/data/sys/schema_unused_indexes.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /mysql/data/sys/x@0024schema_tables_with_full_table_scans.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /mysql/data/sys/x@0024host_summary_by_stages.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /mysql/data/sys/x@0024statements_with_full_table_scans.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /mysql/data/sys/x@0024ps_digest_avg_latency_distribution.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /mysql/data/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /mysql/data/sys/statements_with_runtimes_in_95th_percentile.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /mysql/data/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /mysql/data/sys/x@0024statements_with_temp_tables.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /mysql/data/sys/x@0024user_summary_by_file_io_type.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /mysql/data/sys/x@0024user_summary_by_statement_type.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/user_summary_by_statement_latency.frm to /mysql/data/sys/user_summary_by_statement_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /mysql/data/sys/x@0024user_summary_by_statement_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /mysql/data/sys/x@0024host_summary_by_file_io_type.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /mysql/data/sys/x@0024host_summary_by_statement_type.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/host_summary_by_statement_latency.frm to /mysql/data/sys/host_summary_by_statement_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /mysql/data/sys/x@0024host_summary_by_statement_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /mysql/data/sys/wait_classes_global_by_avg_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /mysql/data/sys/x@0024wait_classes_global_by_avg_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/wait_classes_global_by_latency.frm to /mysql/data/sys/wait_classes_global_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /mysql/data/sys/x@0024wait_classes_global_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /mysql/data/sys/x@0024waits_by_user_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /mysql/data/sys/x@0024waits_by_host_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /mysql/data/sys/x@0024waits_global_by_latency.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024processlist.frm to /mysql/data/sys/x@0024processlist.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/x@0024session.frm to /mysql/data/sys/x@0024session.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./sys/session_ssl_status.frm to /mysql/data/sys/session_ssl_status.frm
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./webchat/medical.ibd to /mysql/data/webchat/medical.ibd
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./webchat/medical_detail.ibd to /mysql/data/webchat/medical_detail.ibd
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./webchat/hospital.ibd to /mysql/data/webchat/hospital.ibd
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./webchat/person.ibd to /mysql/data/webchat/person.ibd
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./webchat/hospital_bak.ibd to /mysql/data/webchat/hospital_bak.ibd
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./webchat/p_person.ibd to /mysql/data/webchat/p_person.ibd
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./webchat/p_hospital.ibd to /mysql/data/webchat/p_hospital.ibd
201012 09:22:11 [01] ...done
201012 09:22:11 [01] Copying ./webchat/p_medical.ibd to /mysql/data/webchat/p_medical.ibd
201012 09:22:17 [01] ...done
201012 09:22:17 [01] Copying ./webchat/p_medical_detail.ibd to /mysql/data/webchat/p_medical_detail.ibd
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/db.opt to /mysql/data/webchat/db.opt
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/medical.frm to /mysql/data/webchat/medical.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/medical_detail.frm to /mysql/data/webchat/medical_detail.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/hospital.frm to /mysql/data/webchat/hospital.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/person.frm to /mysql/data/webchat/person.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/hospital_bak.frm to /mysql/data/webchat/hospital_bak.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/p_person.frm to /mysql/data/webchat/p_person.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/p_hospital.frm to /mysql/data/webchat/p_hospital.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/p_medical.frm to /mysql/data/webchat/p_medical.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./webchat/p_medical_detail.frm to /mysql/data/webchat/p_medical_detail.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/db.opt to /mysql/data/performance_schema/db.opt
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/cond_instances.frm to /mysql/data/performance_schema/cond_instances.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/events_waits_current.frm to /mysql/data/performance_schema/events_waits_current.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/events_waits_history.frm to /mysql/data/performance_schema/events_waits_history.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/events_waits_history_long.frm to /mysql/data/performance_schema/events_waits_history_long.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /mysql/data/performance_schema/events_waits_summary_by_instance.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /mysql/data/performance_schema/events_waits_summary_by_host_by_event_name.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /mysql/data/performance_schema/events_waits_summary_by_user_by_event_name.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /mysql/data/performance_schema/events_waits_summary_by_account_by_event_name.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /mysql/data/performance_schema/events_waits_summary_by_thread_by_event_name.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /mysql/data/performance_schema/events_waits_summary_global_by_event_name.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/file_instances.frm to /mysql/data/performance_schema/file_instances.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /mysql/data/performance_schema/file_summary_by_event_name.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/file_summary_by_instance.frm to /mysql/data/performance_schema/file_summary_by_instance.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/socket_instances.frm to /mysql/data/performance_schema/socket_instances.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /mysql/data/performance_schema/socket_summary_by_instance.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /mysql/data/performance_schema/socket_summary_by_event_name.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/host_cache.frm to /mysql/data/performance_schema/host_cache.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/mutex_instances.frm to /mysql/data/performance_schema/mutex_instances.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /mysql/data/performance_schema/objects_summary_global_by_type.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/performance_timers.frm to /mysql/data/performance_schema/performance_timers.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/rwlock_instances.frm to /mysql/data/performance_schema/rwlock_instances.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/setup_actors.frm to /mysql/data/performance_schema/setup_actors.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/setup_consumers.frm to /mysql/data/performance_schema/setup_consumers.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/setup_instruments.frm to /mysql/data/performance_schema/setup_instruments.frm
201012 09:22:35 [01] ...done
201012 09:22:35 [01] Copying ./performance_schema/setup_objects.frm to /mysql/data/performance_schema/setup_objects.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/setup_timers.frm to /mysql/data/performance_schema/setup_timers.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /mysql/data/performance_schema/table_io_waits_summary_by_index_usage.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /mysql/data/performance_schema/table_io_waits_summary_by_table.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /mysql/data/performance_schema/table_lock_waits_summary_by_table.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/threads.frm to /mysql/data/performance_schema/threads.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_stages_current.frm to /mysql/data/performance_schema/events_stages_current.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_stages_history.frm to /mysql/data/performance_schema/events_stages_history.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_stages_history_long.frm to /mysql/data/performance_schema/events_stages_history_long.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /mysql/data/performance_schema/events_stages_summary_by_thread_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /mysql/data/performance_schema/events_stages_summary_by_host_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /mysql/data/performance_schema/events_stages_summary_by_user_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /mysql/data/performance_schema/events_stages_summary_by_account_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /mysql/data/performance_schema/events_stages_summary_global_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_current.frm to /mysql/data/performance_schema/events_statements_current.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_history.frm to /mysql/data/performance_schema/events_statements_history.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_history_long.frm to /mysql/data/performance_schema/events_statements_history_long.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /mysql/data/performance_schema/events_statements_summary_by_thread_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /mysql/data/performance_schema/events_statements_summary_by_host_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /mysql/data/performance_schema/events_statements_summary_by_user_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /mysql/data/performance_schema/events_statements_summary_by_account_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /mysql/data/performance_schema/events_statements_summary_global_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_transactions_current.frm to /mysql/data/performance_schema/events_transactions_current.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_transactions_history.frm to /mysql/data/performance_schema/events_transactions_history.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_transactions_history_long.frm to /mysql/data/performance_schema/events_transactions_history_long.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /mysql/data/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /mysql/data/performance_schema/events_transactions_summary_by_host_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /mysql/data/performance_schema/events_transactions_summary_by_user_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /mysql/data/performance_schema/events_transactions_summary_by_account_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /mysql/data/performance_schema/events_transactions_summary_global_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/hosts.frm to /mysql/data/performance_schema/hosts.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/users.frm to /mysql/data/performance_schema/users.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/accounts.frm to /mysql/data/performance_schema/accounts.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /mysql/data/performance_schema/memory_summary_global_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /mysql/data/performance_schema/memory_summary_by_thread_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /mysql/data/performance_schema/memory_summary_by_account_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /mysql/data/performance_schema/memory_summary_by_host_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /mysql/data/performance_schema/memory_summary_by_user_by_event_name.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /mysql/data/performance_schema/events_statements_summary_by_digest.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /mysql/data/performance_schema/events_statements_summary_by_program.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/prepared_statements_instances.frm to /mysql/data/performance_schema/prepared_statements_instances.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/replication_connection_configuration.frm to /mysql/data/performance_schema/replication_connection_configuration.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/replication_group_member_stats.frm to /mysql/data/performance_schema/replication_group_member_stats.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/replication_group_members.frm to /mysql/data/performance_schema/replication_group_members.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/replication_connection_status.frm to /mysql/data/performance_schema/replication_connection_status.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/replication_applier_configuration.frm to /mysql/data/performance_schema/replication_applier_configuration.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/replication_applier_status.frm to /mysql/data/performance_schema/replication_applier_status.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /mysql/data/performance_schema/replication_applier_status_by_coordinator.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /mysql/data/performance_schema/replication_applier_status_by_worker.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/session_connect_attrs.frm to /mysql/data/performance_schema/session_connect_attrs.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /mysql/data/performance_schema/session_account_connect_attrs.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/table_handles.frm to /mysql/data/performance_schema/table_handles.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/metadata_locks.frm to /mysql/data/performance_schema/metadata_locks.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/user_variables_by_thread.frm to /mysql/data/performance_schema/user_variables_by_thread.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/variables_by_thread.frm to /mysql/data/performance_schema/variables_by_thread.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/global_variables.frm to /mysql/data/performance_schema/global_variables.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/session_variables.frm to /mysql/data/performance_schema/session_variables.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/status_by_thread.frm to /mysql/data/performance_schema/status_by_thread.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/status_by_user.frm to /mysql/data/performance_schema/status_by_user.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/status_by_host.frm to /mysql/data/performance_schema/status_by_host.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/status_by_account.frm to /mysql/data/performance_schema/status_by_account.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/global_status.frm to /mysql/data/performance_schema/global_status.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./performance_schema/session_status.frm to /mysql/data/performance_schema/session_status.frm
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./ib_buffer_pool to /mysql/data/ib_buffer_pool
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./xtrabackup_info to /mysql/data/xtrabackup_info
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./xtrabackup_binlog_pos_innodb to /mysql/data/xtrabackup_binlog_pos_innodb
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./xtrabackup_master_key_id to /mysql/data/xtrabackup_master_key_id
201012 09:22:36 [01] ...done
201012 09:22:36 [01] Copying ./ibtmp1 to /mysql/data/ibtmp1
201012 09:22:36 [01] ...done
201012 09:22:36 completed OK!
官方压缩下的恢复
压缩时，使用了--compress,恢复时需要使用--decompress。
[root@node15 backuptest]# innobackupex --defaults-file=/mysql/my.cnf --user root --password 'root$123' --decompress --redo-only /mysql/backuptest/
xtrabackup: recognized server arguments: --server-id=1133015 --datadir=/mysql/data_bak --innodb_buffer_pool_size=512M --innodb_file_per_table=1 --innodb_data_home_dir=/mysql/data_bak --innodb_data_file_path=ibdata1:1G:autoextend --innodb_log_group_home_dir=/mysql/data/ --innodb_log_files_in_group=3 --innodb_log_file_size=1G --innodb_log_buffer_size=32M --innodb_flush_log_at_trx_commit=2 --innodb_io_capacity=2000 --innodb_max_dirty_pages_pct=40 --open_files_limit=65535 --log_bin=/mysql/log/mysql-bin
xtrabackup: recognized client arguments:
201010 15:15:05 innobackupex: Starting the decrypt and decompress operation
IMPORTANT: Please check that the decrypt and decompress run completes successfully.
At the end of a successful decrypt and decompress run innobackupex
prints "completed OK!".
innobackupex version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: c8b4056)
201010 15:15:05 [01] decompressing ./xtrabackup_logfile.qp
sh: qpress: 未找到命令
Error: decrypt and decompress thread 0 failed.
这里报了个错误，qpress命令未找到。
我们可以看到，备份后的目录结构如图所示：
qp文件需要用到qpress进行解压，需要下载安装该插件，比较麻烦，官方链接：
http://www.quicklz.com/
270
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
