首页 > 代码库 > MySQL使用Xtrabackup进行增量热备
MySQL使用Xtrabackup进行增量热备
增量热备是基于全备的，需要先进行一次全备
1.全备：
#innobackupex --defaults-file=/etc/my.cnf --user=backup --password=123456 --host=127.0.0.1 --port=3306 /mysqlback/hotback
2.在库中修改数据
mysql> insert into test(name) values (‘test5‘),(‘test6‘),(‘test7‘),(‘test8‘);
Query OK, 4 rows affected (5.12 sec)
Records: 4 Duplicates: 0 Warnings: 0
3.创建第一次增量备份
[root@CentOS6 ~]# innobackupex --defaults-file=/etc/my.cnf --user=backup --password=123456 \
> --host=127.0.0.1 --port=3306 --incremental /mysqlbackdata/hotbackup/increase1/ \
> --incremental-basedir=/mysqlbackdata/hotbackup/
2017-01-31_22-26-42/ increase1/
> --incremental-basedir=/mysqlbackdata/hotbackup/
2017-01-31_22-26-42/ increase1/
> --incremental-basedir=/mysqlbackdata/hotbackup/ --parallel=2
innobackupex: [Warning] option ‘innodb_page_size‘: signed value 1024 adjusted to 4096
170203 16:04:22 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!".
xtrabackup: Error: cannot open /mysqlbackdata/hotbackup//xtrabackup_checkpoints
xtrabackup: error: failed to read metadata from /mysqlbackdata/hotbackup//xtrabackup_checkpoints
[root@CentOS6 ~]# innobackupex --defaults-file=/etc/my.cnf --user=backup --password=123456 --host=127.0.0.1 --port=3306 --incremental /mysqlbackdata/hotbackup/increase1/ --incremental-basedir=/mysqlbackdata/hotbackup/2017-01-31_22-26-42/ --parallel=2
innobackupex: [Warning] option ‘innodb_page_size‘: signed value 1024 adjusted to 4096
170203 16:04:54 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!".
170203 16:04:54 version_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup;host=127.0.0.1;port=3306;mysql_socket=/tmp/mysql.sock‘ as ‘backup‘ (using password: YES).
170203 16:04:54 version_check Connected to MySQL server
170203 16:04:54 version_check Executing a version check against the server...
170203 16:04:54 version_check Done.
170203 16:04:54 Connecting to MySQL server host: 127.0.0.1, user: backup, password: set, port: 3306, socket: /tmp/mysql.sock
Using server version 5.7.16-log
innobackupex version 2.4.5 based on MySQL server 5.7.13 Linux (x86_64) (revision id: e41c0be)
incremental backup from 1885074 is enabled.
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /mysqldata/mysql_data
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = /mysqldata/mysql_data/
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 8589934592
xtrabackup: using O_DIRECT
InnoDB: Number of pools: 1
170203 16:04:54 >> log scanned up to (1890659)
InnoDB: Opened 3 undo tablespaces
InnoDB: 0 undo tablespaces made active
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 24 for sys/sys_config, old maximum was 3
xtrabackup: using the full scan for incremental backup
xtrabackup: Starting 2 threads for parallel data files transfer
170203 16:04:55 [01] Copying ./ibdata1 to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/ibdata1.delta
170203 16:04:55 [02] Copying /mysqldata/mysql_data//undo001 to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/undo001.delta
170203 16:04:55 [02] ...done
170203 16:04:55 [02] Copying /mysqldata/mysql_data//undo002 to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/undo002.delta
170203 16:04:55 [01] ...done
170203 16:04:55 [02] ...done
170203 16:04:55 [01] Copying /mysqldata/mysql_data//undo003 to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/undo003.delta
170203 16:04:55 [02] Copying ./sys/sys_config.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/sys_config.ibd.delta
170203 16:04:55 [02] ...done
170203 16:04:55 [01] ...done
170203 16:04:55 [02] Copying ./test/test.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/test/test.ibd.delta
170203 16:04:55 [01] Copying ./mysql/time_zone_name.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone_name.ibd.delta
170203 16:04:55 [02] ...done
170203 16:04:55 [01] ...done
170203 16:04:55 [01] Copying ./mysql/innodb_index_stats.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/innodb_index_stats.ibd.delta
170203 16:04:55 [02] Copying ./mysql/help_topic.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/help_topic.ibd.delta
170203 16:04:55 [01] ...done
170203 16:04:55 [01] Copying ./mysql/slave_relay_log_info.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/slave_relay_log_info.ibd.delta
170203 16:04:55 [01] ...done
170203 16:04:55 [02] ...done
170203 16:04:55 [01] Copying ./mysql/servers.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/servers.ibd.delta
170203 16:04:55 [02] Copying ./mysql/gtid_executed.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/gtid_executed.ibd.delta
170203 16:04:55 [01] ...done
170203 16:04:55 [02] ...done
170203 16:04:55 [02] Copying ./mysql/help_keyword.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/help_keyword.ibd.delta
170203 16:04:55 [01] Copying ./mysql/time_zone.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone.ibd.delta
170203 16:04:55 [01] ...done
170203 16:04:55 [02] ...done
170203 16:04:55 [02] Copying ./mysql/slave_master_info.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/slave_master_info.ibd.delta
170203 16:04:55 [01] Copying ./mysql/help_relation.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/help_relation.ibd.delta
170203 16:04:55 [02] ...done
170203 16:04:55 [01] ...done
170203 16:04:55 [02] Copying ./mysql/plugin.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/plugin.ibd.delta
170203 16:04:55 [01] Copying ./mysql/time_zone_transition.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone_transition.ibd.delta
170203 16:04:55 [02] ...done
170203 16:04:55 [01] ...done
170203 16:04:55 [02] Copying ./mysql/engine_cost.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/engine_cost.ibd.delta
170203 16:04:55 [01] Copying ./mysql/time_zone_leap_second.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone_leap_second.ibd.delta
170203 16:04:55 [02] ...done
170203 16:04:55 [01] ...done
170203 16:04:55 [01] Copying ./mysql/server_cost.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/server_cost.ibd.delta
170203 16:04:55 [02] Copying ./mysql/time_zone_transition_type.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone_transition_type.ibd.delta
170203 16:04:55 [01] ...done
170203 16:04:55 [02] ...done
170203 16:04:55 [01] Copying ./mysql/slave_worker_info.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/slave_worker_info.ibd.delta
170203 16:04:55 [02] Copying ./mysql/innodb_table_stats.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/innodb_table_stats.ibd.delta
170203 16:04:55 [01] ...done
170203 16:04:55 [02] ...done
170203 16:04:55 [02] Copying ./mysql/help_category.ibd to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/help_category.ibd.delta
170203 16:04:55 [02] ...done
170203 16:04:55 >> log scanned up to (1890659)
170203 16:04:56 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
170203 16:04:56 Executing FLUSH TABLES WITH READ LOCK...
170203 16:04:56 Starting to backup non-InnoDB tables and files
170203 16:04:56 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/objects_summary_global_by_type.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_stages_summary_by_user_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_waits_history.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_waits_history.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_waits_current.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_waits_current.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/cond_instances.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/cond_instances.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/file_summary_by_instance.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/file_summary_by_instance.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/host_cache.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/host_cache.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_waits_summary_by_account_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/table_handles.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/table_handles.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_transactions_summary_by_account_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/status_by_account.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/status_by_account.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_transactions_summary_global_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/replication_applier_status.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/replication_applier_status.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_transactions_current.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_transactions_current.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/mutex_instances.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/mutex_instances.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/session_account_connect_attrs.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/replication_group_member_stats.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/replication_group_member_stats.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_stages_current.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_stages_current.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_stages_history.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_stages_history.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/table_lock_waits_summary_by_table.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/replication_group_members.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/replication_group_members.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_summary_global_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/session_variables.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/session_variables.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/replication_applier_status_by_worker.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/metadata_locks.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/metadata_locks.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_waits_summary_by_instance.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/socket_instances.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/socket_instances.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/status_by_user.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/status_by_user.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/table_io_waits_summary_by_index_usage.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/hosts.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/hosts.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/replication_connection_configuration.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/replication_connection_configuration.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/setup_consumers.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/setup_consumers.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/status_by_host.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/status_by_host.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/replication_applier_configuration.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/replication_applier_configuration.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_history.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_history.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/status_by_thread.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/status_by_thread.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_waits_summary_by_user_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_summary_by_thread_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/accounts.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/accounts.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_summary_by_host_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_summary_by_user_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_stages_history_long.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_stages_history_long.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_stages_summary_global_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/file_instances.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/file_instances.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_history_long.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_history_long.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_waits_summary_by_thread_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/performance_timers.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/performance_timers.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/threads.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/threads.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/variables_by_thread.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/variables_by_thread.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/memory_summary_by_host_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_transactions_history_long.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_transactions_history_long.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/db.opt to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/db.opt
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_transactions_history.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_transactions_history.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/session_connect_attrs.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/session_connect_attrs.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/socket_summary_by_instance.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/memory_summary_global_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/prepared_statements_instances.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/prepared_statements_instances.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/session_status.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/session_status.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/file_summary_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_current.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_current.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/memory_summary_by_account_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_summary_by_account_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_stages_summary_by_account_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_summary_by_digest.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_stages_summary_by_host_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/replication_applier_status_by_coordinator.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_transactions_summary_by_host_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/global_status.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/global_status.frm
170203 16:04:56 [01] ...done
170203 16:04:56 >> log scanned up to (1890659)
170203 16:04:56 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_transactions_summary_by_user_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_statements_summary_by_program.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/user_variables_by_thread.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/user_variables_by_thread.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/memory_summary_by_user_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/setup_actors.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/setup_actors.frm
170203 16:04:56 [01] ...done
170203 16:04:56 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
170203 16:04:56 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/users.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/users.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/setup_instruments.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/setup_instruments.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_stages_summary_by_thread_by_event_name.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/events_waits_history_long.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_waits_history_long.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/replication_connection_status.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/replication_connection_status.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/rwlock_instances.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/rwlock_instances.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/global_variables.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/global_variables.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/setup_timers.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/setup_timers.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_waits_summary_by_host_by_event_name.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/setup_objects.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/setup_objects.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/events_waits_summary_global_by_event_name.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/socket_summary_by_event_name.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/table_io_waits_summary_by_table.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/performance_schema/memory_summary_by_thread_by_event_name.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024io_by_thread_by_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/memory_by_user_by_current_bytes.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/statements_with_temp_tables.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/statements_with_temp_tables.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/user_summary_by_file_io_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/user_summary_by_file_io_type.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/host_summary_by_statement_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/host_summary_by_statement_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/io_global_by_wait_by_bytes.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/host_summary_by_file_io.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/host_summary_by_file_io.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/schema_tables_with_full_table_scans.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024statements_with_temp_tables.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/io_global_by_file_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/io_global_by_file_by_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/schema_redundant_indexes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/schema_redundant_indexes.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024user_summary.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024user_summary.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024schema_table_statistics_with_buffer.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/user_summary_by_file_io.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/user_summary_by_file_io.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/session.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/session.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024schema_table_statistics.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024schema_table_statistics.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024ps_schema_table_statistics_io.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/statements_with_sorting.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/statements_with_sorting.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/host_summary_by_stages.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/host_summary_by_stages.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/memory_global_total.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/memory_global_total.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024processlist.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024processlist.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/statement_analysis.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/statement_analysis.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/processlist.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/processlist.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/memory_global_by_current_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/memory_global_by_current_bytes.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/waits_by_host_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/waits_by_host_by_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/statements_with_runtimes_in_95th_percentile.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/schema_auto_increment_columns.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/schema_auto_increment_columns.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/ps_check_lost_instrumentation.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024innodb_lock_waits.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/user_summary_by_statement_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/user_summary_by_statement_type.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024io_global_by_file_by_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/memory_by_thread_by_current_bytes.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/latest_file_io.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/latest_file_io.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024host_summary_by_file_io.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/statements_with_errors_or_warnings.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024memory_by_thread_by_current_bytes.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/schema_table_statistics_with_buffer.frm
170203 16:04:57 [01] ...done
170203 16:04:57 >> log scanned up to (1890659)
170203 16:04:57 [01] Copying ./sys/io_by_thread_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/io_by_thread_by_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024io_global_by_wait_by_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024waits_by_host_by_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/sys_config_insert_set_user.TRN to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/sys_config_insert_set_user.TRN
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024session.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024session.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/metrics.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/metrics.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024host_summary_by_statement_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/user_summary.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/user_summary.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024host_summary_by_statement_type.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/io_global_by_wait_by_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/user_summary_by_statement_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/user_summary_by_statement_latency.frm
170203 16:04:57 [01] ...done
170203 16:04:57 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024innodb_buffer_stats_by_schema.frm
170203 16:04:57 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024io_global_by_wait_by_bytes.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/waits_global_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/waits_global_by_latency.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024host_summary.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024host_summary.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/io_global_by_file_by_bytes.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024host_summary_by_stages.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024memory_by_host_by_current_bytes.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/db.opt to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/db.opt
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/schema_object_overview.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/schema_object_overview.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/sys_config.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/sys_config.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/user_summary_by_stages.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/user_summary_by_stages.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/innodb_buffer_stats_by_schema.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024io_global_by_file_by_bytes.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024waits_global_by_latency.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024user_summary_by_statement_type.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/schema_index_statistics.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/schema_index_statistics.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024memory_global_by_current_bytes.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/schema_unused_indexes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/schema_unused_indexes.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/statements_with_full_table_scans.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/statements_with_full_table_scans.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024user_summary_by_file_io_type.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024statements_with_sorting.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024statements_with_sorting.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024statements_with_errors_or_warnings.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/waits_by_user_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/waits_by_user_by_latency.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024statements_with_full_table_scans.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024waits_by_user_by_latency.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/innodb_buffer_stats_by_table.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/sys_config.TRG to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/sys_config.TRG
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024schema_index_statistics.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024schema_index_statistics.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024wait_classes_global_by_avg_latency.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/innodb_lock_waits.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/innodb_lock_waits.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/wait_classes_global_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/wait_classes_global_by_latency.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024statement_analysis.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024statement_analysis.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/version.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/version.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024user_summary_by_file_io.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/session_ssl_status.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/session_ssl_status.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024innodb_buffer_stats_by_table.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024host_summary_by_file_io_type.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024ps_digest_avg_latency_distribution.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/schema_table_statistics.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/schema_table_statistics.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024user_summary_by_stages.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024schema_tables_with_full_table_scans.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/wait_classes_global_by_avg_latency.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/sys_config_update_set_user.TRN to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/sys_config_update_set_user.TRN
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/host_summary_by_statement_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/host_summary_by_statement_type.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024latest_file_io.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024latest_file_io.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024memory_global_total.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024memory_global_total.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024schema_flattened_keys.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/host_summary.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/host_summary.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/memory_by_host_by_current_bytes.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024wait_classes_global_by_latency.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024memory_by_user_by_current_bytes.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/schema_table_lock_waits.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/schema_table_lock_waits.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/host_summary_by_file_io_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/host_summary_by_file_io_type.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024user_summary_by_statement_latency.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/sys/x@0024schema_table_lock_waits.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./test/test.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/test/test.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./test/db.opt to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/test/db.opt
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./mysql/columns_priv.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/columns_priv.MYI
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./mysql/proc.MYD to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/proc.MYD
170203 16:04:58 [01] ...done
170203 16:04:58 >> log scanned up to (1890659)
170203 16:04:58 [01] Copying ./mysql/db.MYD to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/db.MYD
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./mysql/tables_priv.MYD to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/tables_priv.MYD
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./mysql/slave_master_info.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/slave_master_info.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./mysql/procs_priv.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/procs_priv.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./mysql/func.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/func.frm
170203 16:04:58 [01] ...done
170203 16:04:58 [01] Copying ./mysql/tables_priv.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/tables_priv.MYI
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/slow_log.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/slow_log.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/time_zone_name.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone_name.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/time_zone_transition_type.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone_transition_type.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/general_log.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/general_log.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/user.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/user.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/general_log.CSM to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/general_log.CSM
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/func.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/func.MYI
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/server_cost.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/server_cost.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/servers.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/servers.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/ndb_binlog_index.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/ndb_binlog_index.MYI
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/plugin.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/plugin.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/event.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/event.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/procs_priv.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/procs_priv.MYI
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/tables_priv.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/tables_priv.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/proc.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/proc.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/slow_log.CSM to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/slow_log.CSM
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/proxies_priv.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/proxies_priv.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/procs_priv.MYD to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/procs_priv.MYD
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/help_keyword.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/help_keyword.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/user.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/user.MYI
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/help_category.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/help_category.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/db.opt to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/db.opt
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/ndb_binlog_index.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/ndb_binlog_index.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/innodb_index_stats.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/innodb_index_stats.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/user.MYD to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/user.MYD
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/gtid_executed.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/gtid_executed.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/time_zone_transition.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone_transition.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/time_zone_leap_second.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone_leap_second.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/proc.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/proc.MYI
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/columns_priv.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/columns_priv.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/db.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/db.MYI
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/engine_cost.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/engine_cost.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/columns_priv.MYD to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/columns_priv.MYD
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/proxies_priv.MYD to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/proxies_priv.MYD
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/help_topic.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/help_topic.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/time_zone.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/time_zone.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/event.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/event.MYI
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/proxies_priv.MYI to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/proxies_priv.MYI
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/db.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/db.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/slave_relay_log_info.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/slave_relay_log_info.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/help_relation.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/help_relation.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/slave_worker_info.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/slave_worker_info.frm
170203 16:04:59 [01] ...done
170203 16:04:59 [01] Copying ./mysql/innodb_table_stats.frm to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/mysql/innodb_table_stats.frm
170203 16:04:59 [01] ...done
170203 16:04:59 Finished backing up non-InnoDB tables and files
170203 16:04:59 [00] Writing xtrabackup_binlog_info
170203 16:04:59 [00] ...done
170203 16:04:59 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): ‘1890650‘
xtrabackup: Stopping log copying thread.
.170203 16:04:59 >> log scanned up to (1890659)
170203 16:04:59 Executing UNLOCK TABLES
170203 16:04:59 All tables unlocked
170203 16:04:59 [00] Copying ib_buffer_pool to /mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54/ib_buffer_pool
170203 16:04:59 [00] ...done
170203 16:04:59 Backup created in directory ‘/mysqlbackdata/hotbackup/increase1//2017-02-03_16-04-54‘
MySQL binlog position: filename ‘mysql-bin.000009‘, position ‘544‘
170203 16:04:59 [00] Writing backup-my.cnf
170203 16:04:59 [00] ...done
170203 16:04:59 [00] Writing xtrabackup_info
170203 16:04:59 [00] ...done
xtrabackup: Transaction log of lsn (1890650) to (1890659) was copied.
170203 16:04:59 completed OK!
4.再次修改test库用于测试第二次增量备份
mysql> insert into test.test(name) values (‘test9‘),(‘test_increment2‘);
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
5.进行第二次增量备份
#innobackupex --defaults-file=/etc/my.cnf --user=backup --password=123456 --host=127.0.0.1 --port=3306 --incremental /mysqlback/hotback/increase2/ --incremental-basedir=/mysqlback/hotback/increase1
MySQL使用Xtrabackup进行增量热备