分类: MySQL

2018-06-12 11:25:59

1、创建MySQL备份用户

点击(此处)折叠或打开

  1. mysql> create user 'backup'@'%' identified by 'mysql';
  2. Query OK, 0 rows affected (0.00 sec)

  3. mysql> grant reload,lock tables,replication client,create tablespace,process,super,create,insert,select on *.* to 'backup'@'%';
  4. Query OK, 0 rows affected (0.00 sec)

  5. mysql> flush privileges;
  6. Query OK, 0 rows affected (0.00 sec)
2、查看测试表

点击(此处)折叠或打开

  1. mysql> select * from test;
  2. Empty set (0.00 sec)
3、对数据库进行全备

点击(此处)折叠或打开

  1. [root@mysql5 bin]# ./innobackupex --defaults-file=/etc/my.cnf --user=backup --password=mysql --port=3306 /backup/full_backup/
  2. 180612 10:30:29 innobackupex: Starting the backup operation

  3. IMPORTANT: Please check that the backup run completes successfully.
  4.            At the end of a successful backup run innobackupex
  5.            prints "completed OK!".

  6. 180612 10:30:29 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/tmp/mysqld.sock' as 'backup' (using password: YES).
  7. 180612 10:30:29 version_check Connected to MySQL server
  8. 180612 10:30:29 version_check Executing a version check against the server...
  9. 180612 10:30:29 version_check Done.
  10. 180612 10:30:29 Connecting to MySQL server host: localhost, user: backup, password: set, port: 3306, socket: /tmp/mysqld.sock
  11. Using server version 5.7.19-log
  12. ./innobackupex version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4)
  13. xtrabackup: uses posix_fadvise().
  14. xtrabackup: cd to /mysql/data
  15. xtrabackup: open files limit requested 65535, set to 65535
  16. xtrabackup: using the following InnoDB configuration:
  17. xtrabackup: innodb_data_home_dir = .
  18. xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
  19. xtrabackup: innodb_log_group_home_dir = ./
  20. xtrabackup: innodb_log_files_in_group = 2
  21. xtrabackup: innodb_log_file_size = 67108864
  22. xtrabackup: using O_DIRECT
  23. InnoDB: Number of pools: 1
  24. Warning: "test.test" uses engine "MEMORY" and will not be backed up.
  25. 180612 10:30:30 >> log scanned up to (1540210043)
  26. xtrabackup: Generating a list of tablespaces
  27. InnoDB: Allocated tablespace ID 64 for test/t_user_info, old maximum was 0
  28. 180612 10:30:30 [01] Copying ./ibdata1 to /backup/full_backup/2018-06-12_10-30-29/ibdata1
  29. 180612 10:30:31 >> log scanned up to (1540210043)
  30. 180612 10:30:32 >> log scanned up to (1540210043)
  31. 180612 10:30:33 >> log scanned up to (1540210043)
  32. 180612 10:30:34 >> log scanned up to (1540210043)
  33. 180612 10:30:34 [01] ...done
  34. 180612 10:30:34 [01] Copying ./test/t_user_info.ibd to /backup/full_backup/2018-06-12_10-30-29/test/t_user_info.ibd
  35. 180612 10:30:34 [01] ...done
  36. 180612 10:30:34 [01] Copying ./xcredit/tb_openapi.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_openapi.ibd
  37. 180612 10:30:34 [01] ...done
  38. 180612 10:30:34 [01] Copying ./xcredit/tb_system_param.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_system_param.ibd
  39. 180612 10:30:34 [01] ...done
  40. 180612 10:30:34 [01] Copying ./xcredit/tb_query_data_history.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_query_data_history.ibd
  41. 180612 10:30:34 [01] ...done
  42. 180612 10:30:34 [01] Copying ./xcredit/tb_query_acquire_log.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_query_acquire_log.ibd
  43. 180612 10:30:34 [01] ...done
  44. 180612 10:30:34 [01] Copying ./xcredit/tb_index.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_index.ibd
  45. 180612 10:30:34 [01] ...done
  46. 180612 10:30:34 [01] Copying ./xcredit/tb_role_resource.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_role_resource.ibd
  47. 180612 10:30:34 [01] ...done
  48. 180612 10:30:34 [01] Copying ./xcredit/tb_data_complaint.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_data_complaint.ibd
  49. 180612 10:30:34 [01] ...done
  50. 180612 10:30:35 [01] Copying ./xcredit/tb_message.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_message.ibd
  51. 180612 10:30:35 [01] ...done
  52. 180612 10:30:35 >> log scanned up to (1540210043)
  53. 180612 10:30:35 [01] Copying ./xcredit/tb_query_index_log.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_query_index_log.ibd
  54. 180612 10:30:35 [01] ...done
  55. 180612 10:30:35 [01] Copying ./xcredit/tb_generic_data.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_generic_data.ibd
  56. 180612 10:30:35 [01] ...done
  57. 180612 10:30:35 [01] Copying ./xcredit/tb_resource.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_resource.ibd
  58. 180612 10:30:35 [01] ...done
  59. 180612 10:30:35 [01] Copying ./xcredit/tb_sync_job.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_sync_job.ibd
  60. 180612 10:30:35 [01] ...done
  61. 180612 10:30:35 [01] Copying ./xcredit/tb_admin.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_admin.ibd
  62. 180612 10:30:36 [01] ...done
  63. 180612 10:30:36 [01] Copying ./xcredit/tb_analyze_index.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_analyze_index.ibd
  64. 180612 10:30:36 >> log scanned up to (1540210043)
  65. 180612 10:30:36 [01] ...done
  66. 180612 10:30:36 [01] Copying ./xcredit/tb_index_log.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_index_log.ibd
  67. 180612 10:30:36 [01] ...done
  68. 180612 10:30:36 [01] Copying ./xcredit/tb_role.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_role.ibd
  69. 180612 10:30:36 [01] ...done
  70. 180612 10:30:36 [01] Copying ./xcredit/tb_cert.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_cert.ibd
  71. 180612 10:30:36 [01] ...done
  72. 180612 10:30:36 [01] Copying ./xcredit/tb_openapi_acquire_log.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_openapi_acquire_log.ibd
  73. 180612 10:30:36 [01] ...done
  74. 180612 10:30:36 [01] Copying ./xcredit/tb_openapi_offer_log.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_openapi_offer_log.ibd
  75. 180612 10:30:36 [01] ...done
  76. 180612 10:30:36 [01] Copying ./xcredit/tb_query_offer_log.ibd to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_query_offer_log.ibd
  77. 180612 10:30:36 [01] ...done
  78. 180612 10:30:36 [01] Copying ./sys/sys_config.ibd to /backup/full_backup/2018-06-12_10-30-29/sys/sys_config.ibd
  79. 180612 10:30:36 [01] ...done
  80. 180612 10:30:36 [01] Copying ./mysql/help_topic.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/help_topic.ibd
  81. 180612 10:30:36 [01] ...done
  82. 180612 10:30:36 [01] Copying ./mysql/slave_worker_info.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/slave_worker_info.ibd
  83. 180612 10:30:36 [01] ...done
  84. 180612 10:30:36 [01] Copying ./mysql/time_zone.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone.ibd
  85. 180612 10:30:36 [01] ...done
  86. 180612 10:30:36 [01] Copying ./mysql/slave_relay_log_info.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/slave_relay_log_info.ibd
  87. 180612 10:30:36 [01] ...done
  88. 180612 10:30:36 [01] Copying ./mysql/help_relation.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/help_relation.ibd
  89. 180612 10:30:36 [01] ...done
  90. 180612 10:30:36 [01] Copying ./mysql/help_keyword.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/help_keyword.ibd
  91. 180612 10:30:36 [01] ...done
  92. 180612 10:30:36 [01] Copying ./mysql/help_category.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/help_category.ibd
  93. 180612 10:30:36 [01] ...done
  94. 180612 10:30:36 [01] Copying ./mysql/server_cost.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/server_cost.ibd
  95. 180612 10:30:36 [01] ...done
  96. 180612 10:30:36 [01] Copying ./mysql/innodb_index_stats.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/innodb_index_stats.ibd
  97. 180612 10:30:36 [01] ...done
  98. 180612 10:30:36 [01] Copying ./mysql/time_zone_transition.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone_transition.ibd
  99. 180612 10:30:36 [01] ...done
  100. 180612 10:30:36 [01] Copying ./mysql/user_bak.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/user_bak.ibd
  101. 180612 10:30:36 [01] ...done
  102. 180612 10:30:37 [01] Copying ./mysql/time_zone_name.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone_name.ibd
  103. 180612 10:30:37 [01] ...done
  104. 180612 10:30:37 >> log scanned up to (1540210043)
  105. 180612 10:30:37 [01] Copying ./mysql/gtid_executed.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/gtid_executed.ibd
  106. 180612 10:30:37 [01] ...done
  107. 180612 10:30:37 [01] Copying ./mysql/slave_master_info.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/slave_master_info.ibd
  108. 180612 10:30:37 [01] ...done
  109. 180612 10:30:37 [01] Copying ./mysql/time_zone_leap_second.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone_leap_second.ibd
  110. 180612 10:30:37 [01] ...done
  111. 180612 10:30:37 [01] Copying ./mysql/servers.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/servers.ibd
  112. 180612 10:30:37 [01] ...done
  113. 180612 10:30:37 [01] Copying ./mysql/time_zone_transition_type.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone_transition_type.ibd
  114. 180612 10:30:37 [01] ...done
  115. 180612 10:30:37 [01] Copying ./mysql/plugin.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/plugin.ibd
  116. 180612 10:30:37 [01] ...done
  117. 180612 10:30:37 [01] Copying ./mysql/innodb_table_stats.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/innodb_table_stats.ibd
  118. 180612 10:30:37 [01] ...done
  119. 180612 10:30:37 [01] Copying ./mysql/engine_cost.ibd to /backup/full_backup/2018-06-12_10-30-29/mysql/engine_cost.ibd
  120. 180612 10:30:37 [01] ...done
  121. 180612 10:30:37 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
  122. 180612 10:30:37 Executing FLUSH TABLES WITH READ LOCK...
  123. 180612 10:30:37 Starting to backup non-InnoDB tables and files
  124. 180612 10:30:37 [01] Copying ./test/test.frm to /backup/full_backup/2018-06-12_10-30-29/test/test.frm
  125. 180612 10:30:37 [01] ...done
  126. 180612 10:30:37 [01] Copying ./test/t_user_info.frm to /backup/full_backup/2018-06-12_10-30-29/test/t_user_info.frm
  127. 180612 10:30:37 [01] ...done
  128. 180612 10:30:37 [01] Copying ./test/t_tou_info.frm to /backup/full_backup/2018-06-12_10-30-29/test/t_tou_info.frm
  129. 180612 10:30:37 [01] ...done
  130. 180612 10:30:37 [01] Copying ./test/t_tou_info.MYI to /backup/full_backup/2018-06-12_10-30-29/test/t_tou_info.MYI
  131. 180612 10:30:37 [01] ...done
  132. 180612 10:30:37 [01] Copying ./test/t_tou_info.MYD to /backup/full_backup/2018-06-12_10-30-29/test/t_tou_info.MYD
  133. 180612 10:30:37 [01] ...done
  134. 180612 10:30:37 [01] Copying ./test/db.opt to /backup/full_backup/2018-06-12_10-30-29/test/db.opt
  135. 180612 10:30:37 [01] ...done
  136. 180612 10:30:37 [01] Copying ./xcredit/tb_generic_data.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_generic_data.frm
  137. 180612 10:30:37 [01] ...done
  138. 180612 10:30:37 [01] Copying ./xcredit/tb_query_data_history.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_query_data_history.frm
  139. 180612 10:30:37 [01] ...done
  140. 180612 10:30:37 [01] Copying ./xcredit/tb_query_acquire_log.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_query_acquire_log.frm
  141. 180612 10:30:37 [01] ...done
  142. 180612 10:30:37 [01] Copying ./xcredit/tb_query_index_log.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_query_index_log.frm
  143. 180612 10:30:37 [01] ...done
  144. 180612 10:30:37 [01] Copying ./xcredit/tb_analyze_index.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_analyze_index.frm
  145. 180612 10:30:37 [01] ...done
  146. 180612 10:30:37 [01] Copying ./xcredit/tb_admin.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_admin.frm
  147. 180612 10:30:37 [01] ...done
  148. 180612 10:30:37 [01] Copying ./xcredit/tb_openapi_offer_log.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_openapi_offer_log.frm
  149. 180612 10:30:37 [01] ...done
  150. 180612 10:30:37 [01] Copying ./xcredit/tb_role.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_role.frm
  151. 180612 10:30:37 [01] ...done
  152. 180612 10:30:37 [01] Copying ./xcredit/tb_query_offer_log.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_query_offer_log.frm
  153. 180612 10:30:37 [01] ...done
  154. 180612 10:30:37 [01] Copying ./xcredit/tb_cert.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_cert.frm
  155. 180612 10:30:37 [01] ...done
  156. 180612 10:30:37 [01] Copying ./xcredit/tb_role_resource.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_role_resource.frm
  157. 180612 10:30:37 [01] ...done
  158. 180612 10:30:37 [01] Copying ./xcredit/tb_index.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_index.frm
  159. 180612 10:30:37 [01] ...done
  160. 180612 10:30:37 [01] Copying ./xcredit/tb_resource.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_resource.frm
  161. 180612 10:30:37 [01] ...done
  162. 180612 10:30:37 [01] Copying ./xcredit/tb_data_complaint.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_data_complaint.frm
  163. 180612 10:30:37 [01] ...done
  164. 180612 10:30:37 [01] Copying ./xcredit/tb_message.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_message.frm
  165. 180612 10:30:37 [01] ...done
  166. 180612 10:30:37 [01] Copying ./xcredit/tb_sync_job.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_sync_job.frm
  167. 180612 10:30:37 [01] ...done
  168. 180612 10:30:37 [01] Copying ./xcredit/tb_system_param.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_system_param.frm
  169. 180612 10:30:37 [01] ...done
  170. 180612 10:30:37 [01] Copying ./xcredit/tb_openapi_acquire_log.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_openapi_acquire_log.frm
  171. 180612 10:30:37 [01] ...done
  172. 180612 10:30:37 [01] Copying ./xcredit/db.opt to /backup/full_backup/2018-06-12_10-30-29/xcredit/db.opt
  173. 180612 10:30:37 [01] ...done
  174. 180612 10:30:37 [01] Copying ./xcredit/tb_index_log.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_index_log.frm
  175. 180612 10:30:37 [01] ...done
  176. 180612 10:30:37 [01] Copying ./xcredit/tb_openapi.frm to /backup/full_backup/2018-06-12_10-30-29/xcredit/tb_openapi.frm
  177. 180612 10:30:37 [01] ...done
  178. 180612 10:30:37 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024wait_classes_global_by_avg_latency.frm
  179. 180612 10:30:37 [01] ...done
  180. 180612 10:30:37 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/io_global_by_wait_by_bytes.frm
  181. 180612 10:30:37 [01] ...done
  182. 180612 10:30:37 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024memory_by_host_by_current_bytes.frm
  183. 180612 10:30:37 [01] ...done
  184. 180612 10:30:37 [01] Copying ./sys/user_summary.frm to /backup/full_backup/2018-06-12_10-30-29/sys/user_summary.frm
  185. 180612 10:30:37 [01] ...done
  186. 180612 10:30:37 [01] Copying ./sys/host_summary.frm to /backup/full_backup/2018-06-12_10-30-29/sys/host_summary.frm
  187. 180612 10:30:37 [01] ...done
  188. 180612 10:30:37 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
  189. 180612 10:30:37 [01] ...done
  190. 180612 10:30:37 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024waits_by_host_by_latency.frm
  191. 180612 10:30:37 [01] ...done
  192. 180612 10:30:37 [01] Copying ./sys/memory_global_total.frm to /backup/full_backup/2018-06-12_10-30-29/sys/memory_global_total.frm
  193. 180612 10:30:37 [01] ...done
  194. 180612 10:30:37 [01] Copying ./sys/memory_global_by_current_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/memory_global_by_current_bytes.frm
  195. 180612 10:30:37 [01] ...done
  196. 180612 10:30:37 [01] Copying ./sys/version.frm to /backup/full_backup/2018-06-12_10-30-29/sys/version.frm
  197. 180612 10:30:37 [01] ...done
  198. 180612 10:30:37 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024memory_by_thread_by_current_bytes.frm
  199. 180612 10:30:37 [01] ...done
  200. 180612 10:30:37 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /backup/full_backup/2018-06-12_10-30-29/sys/schema_table_statistics_with_buffer.frm
  201. 180612 10:30:37 [01] ...done
  202. 180612 10:30:37 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024schema_table_lock_waits.frm
  203. 180612 10:30:37 [01] ...done
  204. 180612 10:30:37 [01] Copying ./sys/statements_with_full_table_scans.frm to /backup/full_backup/2018-06-12_10-30-29/sys/statements_with_full_table_scans.frm
  205. 180612 10:30:37 [01] ...done
  206. 180612 10:30:37 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024innodb_buffer_stats_by_table.frm
  207. 180612 10:30:37 [01] ...done
  208. 180612 10:30:37 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/memory_by_user_by_current_bytes.frm
  209. 180612 10:30:37 [01] ...done
  210. 180612 10:30:37 [01] Copying ./sys/schema_redundant_indexes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/schema_redundant_indexes.frm
  211. 180612 10:30:37 [01] ...done
  212. 180612 10:30:37 [01] Copying ./sys/latest_file_io.frm to /backup/full_backup/2018-06-12_10-30-29/sys/latest_file_io.frm
  213. 180612 10:30:37 [01] ...done
  214. 180612 10:30:37 [01] Copying ./sys/statements_with_temp_tables.frm to /backup/full_backup/2018-06-12_10-30-29/sys/statements_with_temp_tables.frm
  215. 180612 10:30:37 [01] ...done
  216. 180612 10:30:37 [01] Copying ./sys/session.frm to /backup/full_backup/2018-06-12_10-30-29/sys/session.frm
  217. 180612 10:30:37 [01] ...done
  218. 180612 10:30:37 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/io_global_by_file_by_bytes.frm
  219. 180612 10:30:37 [01] ...done
  220. 180612 10:30:37 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024schema_table_statistics_with_buffer.frm
  221. 180612 10:30:37 [01] ...done
  222. 180612 10:30:37 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024io_by_thread_by_latency.frm
  223. 180612 10:30:37 [01] ...done
  224. 180612 10:30:37 [01] Copying ./sys/sys_config.TRG to /backup/full_backup/2018-06-12_10-30-29/sys/sys_config.TRG
  225. 180612 10:30:37 [01] ...done
  226. 180612 10:30:37 [01] Copying ./sys/x@0024memory_global_total.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024memory_global_total.frm
  227. 180612 10:30:37 [01] ...done
  228. 180612 10:30:37 [01] Copying ./sys/x@0024statement_analysis.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024statement_analysis.frm
  229. 180612 10:30:37 [01] ...done
  230. 180612 10:30:37 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /backup/full_backup/2018-06-12_10-30-29/sys/innodb_buffer_stats_by_schema.frm
  231. 180612 10:30:37 [01] ...done
  232. 180612 10:30:37 [01] Copying ./sys/schema_unused_indexes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/schema_unused_indexes.frm
  233. 180612 10:30:37 [01] ...done
  234. 180612 10:30:37 [01] Copying ./sys/sys_config_update_set_user.TRN to /backup/full_backup/2018-06-12_10-30-29/sys/sys_config_update_set_user.TRN
  235. 180612 10:30:37 [01] ...done
  236. 180612 10:30:37 [01] Copying ./sys/user_summary_by_statement_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/user_summary_by_statement_latency.frm
  237. 180612 10:30:37 [01] ...done
  238. 180612 10:30:37 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024ps_digest_avg_latency_distribution.frm
  239. 180612 10:30:37 [01] ...done
  240. 180612 10:30:37 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024io_global_by_wait_by_latency.frm
  241. 180612 10:30:37 [01] ...done
  242. 180612 10:30:37 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024host_summary_by_stages.frm
  243. 180612 10:30:37 [01] ...done
  244. 180612 10:30:37 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024user_summary_by_statement_latency.frm
  245. 180612 10:30:37 [01] ...done
  246. 180612 10:30:37 [01] Copying ./sys/statement_analysis.frm to /backup/full_backup/2018-06-12_10-30-29/sys/statement_analysis.frm
  247. 180612 10:30:37 [01] ...done
  248. 180612 10:30:38 [01] Copying ./sys/user_summary_by_file_io_type.frm to /backup/full_backup/2018-06-12_10-30-29/sys/user_summary_by_file_io_type.frm
  249. 180612 10:30:38 [01] ...done
  250. 180612 10:30:38 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /backup/full_backup/2018-06-12_10-30-29/sys/statements_with_runtimes_in_95th_percentile.frm
  251. 180612 10:30:38 [01] ...done
  252. 180612 10:30:38 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024waits_by_user_by_latency.frm
  253. 180612 10:30:38 [01] ...done
  254. 180612 10:30:38 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024waits_global_by_latency.frm
  255. 180612 10:30:38 [01] ...done
  256. 180612 10:30:38 >> log scanned up to (1540210043)
  257. 180612 10:30:38 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /backup/full_backup/2018-06-12_10-30-29/sys/innodb_buffer_stats_by_table.frm
  258. 180612 10:30:38 [01] ...done
  259. 180612 10:30:38 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024memory_by_user_by_current_bytes.frm
  260. 180612 10:30:38 [01] ...done
  261. 180612 10:30:38 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /backup/full_backup/2018-06-12_10-30-29/sys/schema_tables_with_full_table_scans.frm
  262. 180612 10:30:38 [01] ...done
  263. 180612 10:30:38 [01] Copying ./sys/waits_by_user_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/waits_by_user_by_latency.frm
  264. 180612 10:30:38 [01] ...done
  265. 180612 10:30:38 [01] Copying ./sys/x@0024session.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024session.frm
  266. 180612 10:30:38 [01] ...done
  267. 180612 10:30:38 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024statements_with_errors_or_warnings.frm
  268. 180612 10:30:38 [01] ...done
  269. 180612 10:30:38 [01] Copying ./sys/host_summary_by_statement_type.frm to /backup/full_backup/2018-06-12_10-30-29/sys/host_summary_by_statement_type.frm
  270. 180612 10:30:38 [01] ...done
  271. 180612 10:30:38 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024user_summary_by_file_io.frm
  272. 180612 10:30:38 [01] ...done
  273. 180612 10:30:38 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024host_summary_by_file_io.frm
  274. 180612 10:30:38 [01] ...done
  275. 180612 10:30:38 [01] Copying ./sys/host_summary_by_file_io_type.frm to /backup/full_backup/2018-06-12_10-30-29/sys/host_summary_by_file_io_type.frm
  276. 180612 10:30:38 [01] ...done
  277. 180612 10:30:38 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024schema_tables_with_full_table_scans.frm
  278. 180612 10:30:38 [01] ...done
  279. 180612 10:30:38 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/memory_by_host_by_current_bytes.frm
  280. 180612 10:30:38 [01] ...done
  281. 180612 10:30:38 [01] Copying ./sys/x@0024processlist.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024processlist.frm
  282. 180612 10:30:38 [01] ...done
  283. 180612 10:30:38 [01] Copying ./sys/user_summary_by_statement_type.frm to /backup/full_backup/2018-06-12_10-30-29/sys/user_summary_by_statement_type.frm
  284. 180612 10:30:38 [01] ...done
  285. 180612 10:30:38 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024io_global_by_file_by_latency.frm
  286. 180612 10:30:38 [01] ...done
  287. 180612 10:30:38 [01] Copying ./sys/x@0024schema_index_statistics.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024schema_index_statistics.frm
  288. 180612 10:30:38 [01] ...done
  289. 180612 10:30:38 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
  290. 180612 10:30:38 [01] ...done
  291. 180612 10:30:38 [01] Copying ./sys/x@0024host_summary.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024host_summary.frm
  292. 180612 10:30:38 [01] ...done
  293. 180612 10:30:38 [01] Copying ./sys/host_summary_by_file_io.frm to /backup/full_backup/2018-06-12_10-30-29/sys/host_summary_by_file_io.frm
  294. 180612 10:30:38 [01] ...done
  295. 180612 10:30:38 [01] Copying ./sys/schema_table_statistics.frm to /backup/full_backup/2018-06-12_10-30-29/sys/schema_table_statistics.frm
  296. 180612 10:30:38 [01] ...done
  297. 180612 10:30:38 [01] Copying ./sys/innodb_lock_waits.frm to /backup/full_backup/2018-06-12_10-30-29/sys/innodb_lock_waits.frm
  298. 180612 10:30:38 [01] ...done
  299. 180612 10:30:38 [01] Copying ./sys/x@0024schema_table_statistics.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024schema_table_statistics.frm
  300. 180612 10:30:38 [01] ...done
  301. 180612 10:30:38 [01] Copying ./sys/host_summary_by_statement_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/host_summary_by_statement_latency.frm
  302. 180612 10:30:38 [01] ...done
  303. 180612 10:30:38 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024statements_with_temp_tables.frm
  304. 180612 10:30:38 [01] ...done
  305. 180612 10:30:38 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/wait_classes_global_by_avg_latency.frm
  306. 180612 10:30:38 [01] ...done
  307. 180612 10:30:38 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024host_summary_by_statement_latency.frm
  308. 180612 10:30:38 [01] ...done
  309. 180612 10:30:38 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /backup/full_backup/2018-06-12_10-30-29/sys/statements_with_errors_or_warnings.frm
  310. 180612 10:30:38 [01] ...done
  311. 180612 10:30:38 [01] Copying ./sys/waits_by_host_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/waits_by_host_by_latency.frm
  312. 180612 10:30:38 [01] ...done
  313. 180612 10:30:38 [01] Copying ./sys/schema_object_overview.frm to /backup/full_backup/2018-06-12_10-30-29/sys/schema_object_overview.frm
  314. 180612 10:30:38 [01] ...done
  315. 180612 10:30:38 [01] Copying ./sys/schema_table_lock_waits.frm to /backup/full_backup/2018-06-12_10-30-29/sys/schema_table_lock_waits.frm
  316. 180612 10:30:38 [01] ...done
  317. 180612 10:30:38 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024io_global_by_wait_by_bytes.frm
  318. 180612 10:30:38 [01] ...done
  319. 180612 10:30:38 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024wait_classes_global_by_latency.frm
  320. 180612 10:30:38 [01] ...done
  321. 180612 10:30:38 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024host_summary_by_file_io_type.frm
  322. 180612 10:30:38 [01] ...done
  323. 180612 10:30:38 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024innodb_buffer_stats_by_schema.frm
  324. 180612 10:30:38 [01] ...done
  325. 180612 10:30:38 [01] Copying ./sys/waits_global_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/waits_global_by_latency.frm
  326. 180612 10:30:38 [01] ...done
  327. 180612 10:30:38 [01] Copying ./sys/sys_config_insert_set_user.TRN to /backup/full_backup/2018-06-12_10-30-29/sys/sys_config_insert_set_user.TRN
  328. 180612 10:30:38 [01] ...done
  329. 180612 10:30:38 [01] Copying ./sys/schema_index_statistics.frm to /backup/full_backup/2018-06-12_10-30-29/sys/schema_index_statistics.frm
  330. 180612 10:30:38 [01] ...done
  331. 180612 10:30:38 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024ps_schema_table_statistics_io.frm
  332. 180612 10:30:38 [01] ...done
  333. 180612 10:30:38 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/io_global_by_wait_by_latency.frm
  334. 180612 10:30:38 [01] ...done
  335. 180612 10:30:38 [01] Copying ./sys/io_global_by_file_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/io_global_by_file_by_latency.frm
  336. 180612 10:30:38 [01] ...done
  337. 180612 10:30:38 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024user_summary_by_file_io_type.frm
  338. 180612 10:30:38 [01] ...done
  339. 180612 10:30:38 [01] Copying ./sys/host_summary_by_stages.frm to /backup/full_backup/2018-06-12_10-30-29/sys/host_summary_by_stages.frm
  340. 180612 10:30:38 [01] ...done
  341. 180612 10:30:38 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024host_summary_by_statement_type.frm
  342. 180612 10:30:38 [01] ...done
  343. 180612 10:30:38 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024statements_with_full_table_scans.frm
  344. 180612 10:30:38 [01] ...done
  345. 180612 10:30:38 [01] Copying ./sys/metrics.frm to /backup/full_backup/2018-06-12_10-30-29/sys/metrics.frm
  346. 180612 10:30:38 [01] ...done
  347. 180612 10:30:38 [01] Copying ./sys/wait_classes_global_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/wait_classes_global_by_latency.frm
  348. 180612 10:30:38 [01] ...done
  349. 180612 10:30:38 [01] Copying ./sys/x@0024statements_with_sorting.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024statements_with_sorting.frm
  350. 180612 10:30:38 [01] ...done
  351. 180612 10:30:38 [01] Copying ./sys/user_summary_by_stages.frm to /backup/full_backup/2018-06-12_10-30-29/sys/user_summary_by_stages.frm
  352. 180612 10:30:38 [01] ...done
  353. 180612 10:30:38 [01] Copying ./sys/sys_config.frm to /backup/full_backup/2018-06-12_10-30-29/sys/sys_config.frm
  354. 180612 10:30:38 [01] ...done
  355. 180612 10:30:38 [01] Copying ./sys/session_ssl_status.frm to /backup/full_backup/2018-06-12_10-30-29/sys/session_ssl_status.frm
  356. 180612 10:30:38 [01] ...done
  357. 180612 10:30:38 [01] Copying ./sys/statements_with_sorting.frm to /backup/full_backup/2018-06-12_10-30-29/sys/statements_with_sorting.frm
  358. 180612 10:30:38 [01] ...done
  359. 180612 10:30:38 [01] Copying ./sys/x@0024latest_file_io.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024latest_file_io.frm
  360. 180612 10:30:38 [01] ...done
  361. 180612 10:30:38 [01] Copying ./sys/db.opt to /backup/full_backup/2018-06-12_10-30-29/sys/db.opt
  362. 180612 10:30:38 [01] ...done
  363. 180612 10:30:38 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024user_summary_by_stages.frm
  364. 180612 10:30:38 [01] ...done
  365. 180612 10:30:38 [01] Copying ./sys/io_by_thread_by_latency.frm to /backup/full_backup/2018-06-12_10-30-29/sys/io_by_thread_by_latency.frm
  366. 180612 10:30:38 [01] ...done
  367. 180612 10:30:38 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024io_global_by_file_by_bytes.frm
  368. 180612 10:30:38 [01] ...done
  369. 180612 10:30:38 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024innodb_lock_waits.frm
  370. 180612 10:30:38 [01] ...done
  371. 180612 10:30:38 [01] Copying ./sys/user_summary_by_file_io.frm to /backup/full_backup/2018-06-12_10-30-29/sys/user_summary_by_file_io.frm
  372. 180612 10:30:38 [01] ...done
  373. 180612 10:30:38 [01] Copying ./sys/processlist.frm to /backup/full_backup/2018-06-12_10-30-29/sys/processlist.frm
  374. 180612 10:30:38 [01] ...done
  375. 180612 10:30:38 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024memory_global_by_current_bytes.frm
  376. 180612 10:30:38 [01] ...done
  377. 180612 10:30:38 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /backup/full_backup/2018-06-12_10-30-29/sys/ps_check_lost_instrumentation.frm
  378. 180612 10:30:38 [01] ...done
  379. 180612 10:30:38 [01] Copying ./sys/x@0024user_summary.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024user_summary.frm
  380. 180612 10:30:38 [01] ...done
  381. 180612 10:30:38 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024schema_flattened_keys.frm
  382. 180612 10:30:38 [01] ...done
  383. 180612 10:30:38 [01] Copying ./sys/schema_auto_increment_columns.frm to /backup/full_backup/2018-06-12_10-30-29/sys/schema_auto_increment_columns.frm
  384. 180612 10:30:38 [01] ...done
  385. 180612 10:30:38 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /backup/full_backup/2018-06-12_10-30-29/sys/x@0024user_summary_by_statement_type.frm
  386. 180612 10:30:38 [01] ...done
  387. 180612 10:30:38 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /backup/full_backup/2018-06-12_10-30-29/sys/memory_by_thread_by_current_bytes.frm
  388. 180612 10:30:38 [01] ...done
  389. 180612 10:30:38 [01] Copying ./mysql/tables_priv.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/tables_priv.frm
  390. 180612 10:30:38 [01] ...done
  391. 180612 10:30:38 [01] Copying ./mysql/proc.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/proc.MYD
  392. 180612 10:30:38 [01] ...done
  393. 180612 10:30:38 [01] Copying ./mysql/server_cost.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/server_cost.frm
  394. 180612 10:30:38 [01] ...done
  395. 180612 10:30:38 [01] Copying ./mysql/proxies_priv.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/proxies_priv.frm
  396. 180612 10:30:38 [01] ...done
  397. 180612 10:30:38 [01] Copying ./mysql/procs_priv.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/procs_priv.MYI
  398. 180612 10:30:38 [01] ...done
  399. 180612 10:30:38 [01] Copying ./mysql/event.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/event.MYI
  400. 180612 10:30:38 [01] ...done
  401. 180612 10:30:38 [01] Copying ./mysql/slave_worker_info.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/slave_worker_info.frm
  402. 180612 10:30:38 [01] ...done
  403. 180612 10:30:38 [01] Copying ./mysql/user_bak.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/user_bak.frm
  404. 180612 10:30:38 [01] ...done
  405. 180612 10:30:38 [01] Copying ./mysql/time_zone.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone.frm
  406. 180612 10:30:38 [01] ...done
  407. 180612 10:30:38 [01] Copying ./mysql/help_relation.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/help_relation.frm
  408. 180612 10:30:38 [01] ...done
  409. 180612 10:30:38 [01] Copying ./mysql/time_zone_transition_type.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone_transition_type.frm
  410. 180612 10:30:38 [01] ...done
  411. 180612 10:30:38 [01] Copying ./mysql/help_topic.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/help_topic.frm
  412. 180612 10:30:38 [01] ...done
  413. 180612 10:30:38 [01] Copying ./mysql/db.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/db.MYD
  414. 180612 10:30:38 [01] ...done
  415. 180612 10:30:38 [01] Copying ./mysql/slow_log.CSM to /backup/full_backup/2018-06-12_10-30-29/mysql/slow_log.CSM
  416. 180612 10:30:38 [01] ...done
  417. 180612 10:30:38 [01] Copying ./mysql/slow_log.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/slow_log.frm
  418. 180612 10:30:38 [01] ...done
  419. 180612 10:30:38 [01] Copying ./mysql/general_log.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/general_log.frm
  420. 180612 10:30:38 [01] ...done
  421. 180612 10:30:38 [01] Copying ./mysql/slave_relay_log_info.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/slave_relay_log_info.frm
  422. 180612 10:30:38 [01] ...done
  423. 180612 10:30:38 [01] Copying ./mysql/tables_priv.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/tables_priv.MYI
  424. 180612 10:30:38 [01] ...done
  425. 180612 10:30:38 [01] Copying ./mysql/ndb_binlog_index.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/ndb_binlog_index.MYD
  426. 180612 10:30:38 [01] ...done
  427. 180612 10:30:38 [01] Copying ./mysql/slave_master_info.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/slave_master_info.frm
  428. 180612 10:30:38 [01] ...done
  429. 180612 10:30:38 [01] Copying ./mysql/func.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/func.frm
  430. 180612 10:30:38 [01] ...done
  431. 180612 10:30:38 [01] Copying ./mysql/proc.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/proc.frm
  432. 180612 10:30:38 [01] ...done
  433. 180612 10:30:38 [01] Copying ./mysql/time_zone_name.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone_name.frm
  434. 180612 10:30:38 [01] ...done
  435. 180612 10:30:38 [01] Copying ./mysql/func.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/func.MYD
  436. 180612 10:30:38 [01] ...done
  437. 180612 10:30:38 [01] Copying ./mysql/procs_priv.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/procs_priv.frm
  438. 180612 10:30:38 [01] ...done
  439. 180612 10:30:38 [01] Copying ./mysql/tables_priv.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/tables_priv.MYD
  440. 180612 10:30:38 [01] ...done
  441. 180612 10:30:38 [01] Copying ./mysql/columns_priv.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/columns_priv.MYI
  442. 180612 10:30:38 [01] ...done
  443. 180612 10:30:38 [01] Copying ./mysql/general_log.CSM to /backup/full_backup/2018-06-12_10-30-29/mysql/general_log.CSM
  444. 180612 10:30:38 [01] ...done
  445. 180612 10:30:38 [01] Copying ./mysql/ndb_binlog_index.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/ndb_binlog_index.frm
  446. 180612 10:30:38 [01] ...done
  447. 180612 10:30:38 [01] Copying ./mysql/gtid_executed.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/gtid_executed.frm
  448. 180612 10:30:38 [01] ...done
  449. 180612 10:30:38 [01] Copying ./mysql/procs_priv.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/procs_priv.MYD
  450. 180612 10:30:38 [01] ...done
  451. 180612 10:30:38 [01] Copying ./mysql/func.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/func.MYI
  452. 180612 10:30:38 [01] ...done
  453. 180612 10:30:38 [01] Copying ./mysql/help_keyword.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/help_keyword.frm
  454. 180612 10:30:38 [01] ...done
  455. 180612 10:30:38 [01] Copying ./mysql/columns_priv.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/columns_priv.frm
  456. 180612 10:30:38 [01] ...done
  457. 180612 10:30:39 [01] Copying ./mysql/proxies_priv.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/proxies_priv.MYI
  458. 180612 10:30:39 [01] ...done
  459. 180612 10:30:39 [01] Copying ./mysql/proc.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/proc.MYI
  460. 180612 10:30:39 [01] ...done
  461. 180612 10:30:39 [01] Copying ./mysql/time_zone_transition.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone_transition.frm
  462. 180612 10:30:39 [01] ...done
  463. 180612 10:30:39 >> log scanned up to (1540210043)
  464. 180612 10:30:39 [01] Copying ./mysql/time_zone_leap_second.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/time_zone_leap_second.frm
  465. 180612 10:30:39 [01] ...done
  466. 180612 10:30:39 [01] Copying ./mysql/general_log.CSV to /backup/full_backup/2018-06-12_10-30-29/mysql/general_log.CSV
  467. 180612 10:30:39 [01] ...done
  468. 180612 10:30:39 [01] Copying ./mysql/servers.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/servers.frm
  469. 180612 10:30:39 [01] ...done
  470. 180612 10:30:39 [01] Copying ./mysql/help_category.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/help_category.frm
  471. 180612 10:30:39 [01] ...done
  472. 180612 10:30:39 [01] Copying ./mysql/proxies_priv.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/proxies_priv.MYD
  473. 180612 10:30:39 [01] ...done
  474. 180612 10:30:39 [01] Copying ./mysql/event.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/event.MYD
  475. 180612 10:30:39 [01] ...done
  476. 180612 10:30:39 [01] Copying ./mysql/engine_cost.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/engine_cost.frm
  477. 180612 10:30:39 [01] ...done
  478. 180612 10:30:39 [01] Copying ./mysql/user.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/user.frm
  479. 180612 10:30:39 [01] ...done
  480. 180612 10:30:39 [01] Copying ./mysql/ndb_binlog_index.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/ndb_binlog_index.MYI
  481. 180612 10:30:39 [01] ...done
  482. 180612 10:30:39 [01] Copying ./mysql/db.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/db.frm
  483. 180612 10:30:39 [01] ...done
  484. 180612 10:30:39 [01] Copying ./mysql/plugin.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/plugin.frm
  485. 180612 10:30:39 [01] ...done
  486. 180612 10:30:39 [01] Copying ./mysql/db.opt to /backup/full_backup/2018-06-12_10-30-29/mysql/db.opt
  487. 180612 10:30:39 [01] ...done
  488. 180612 10:30:39 [01] Copying ./mysql/user.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/user.MYI
  489. 180612 10:30:39 [01] ...done
  490. 180612 10:30:39 [01] Copying ./mysql/columns_priv.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/columns_priv.MYD
  491. 180612 10:30:39 [01] ...done
  492. 180612 10:30:39 [01] Copying ./mysql/innodb_table_stats.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/innodb_table_stats.frm
  493. 180612 10:30:39 [01] ...done
  494. 180612 10:30:39 [01] Copying ./mysql/innodb_index_stats.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/innodb_index_stats.frm
  495. 180612 10:30:39 [01] ...done
  496. 180612 10:30:39 [01] Copying ./mysql/event.frm to /backup/full_backup/2018-06-12_10-30-29/mysql/event.frm
  497. 180612 10:30:39 [01] ...done
  498. 180612 10:30:39 [01] Copying ./mysql/slow_log.CSV to /backup/full_backup/2018-06-12_10-30-29/mysql/slow_log.CSV
  499. 180612 10:30:39 [01] ...done
  500. 180612 10:30:39 [01] Copying ./mysql/db.MYI to /backup/full_backup/2018-06-12_10-30-29/mysql/db.MYI
  501. 180612 10:30:39 [01] ...done
  502. 180612 10:30:39 [01] Copying ./mysql/user.MYD to /backup/full_backup/2018-06-12_10-30-29/mysql/user.MYD
  503. 180612 10:30:39 [01] ...done
  504. 180612 10:30:39 [01] Copying ./performance_schema/events_transactions_history.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_transactions_history.frm
  505. 180612 10:30:39 [01] ...done
  506. 180612 10:30:39 [01] Copying ./performance_schema/events_waits_history.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_waits_history.frm
  507. 180612 10:30:39 [01] ...done
  508. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_summary_by_digest.frm
  509. 180612 10:30:39 [01] ...done
  510. 180612 10:30:39 [01] Copying ./performance_schema/hosts.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/hosts.frm
  511. 180612 10:30:39 [01] ...done
  512. 180612 10:30:39 [01] Copying ./performance_schema/prepared_statements_instances.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/prepared_statements_instances.frm
  513. 180612 10:30:39 [01] ...done
  514. 180612 10:30:39 [01] Copying ./performance_schema/rwlock_instances.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/rwlock_instances.frm
  515. 180612 10:30:39 [01] ...done
  516. 180612 10:30:39 [01] Copying ./performance_schema/threads.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/threads.frm
  517. 180612 10:30:39 [01] ...done
  518. 180612 10:30:39 [01] Copying ./performance_schema/setup_objects.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/setup_objects.frm
  519. 180612 10:30:39 [01] ...done
  520. 180612 10:30:39 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/objects_summary_global_by_type.frm
  521. 180612 10:30:39 [01] ...done
  522. 180612 10:30:39 [01] Copying ./performance_schema/replication_connection_status.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/replication_connection_status.frm
  523. 180612 10:30:39 [01] ...done
  524. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_summary_by_thread_by_event_name.frm
  525. 180612 10:30:39 [01] ...done
  526. 180612 10:30:39 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/memory_summary_by_host_by_event_name.frm
  527. 180612 10:30:39 [01] ...done
  528. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_summary_by_host_by_event_name.frm
  529. 180612 10:30:39 [01] ...done
  530. 180612 10:30:39 [01] Copying ./performance_schema/session_variables.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/session_variables.frm
  531. 180612 10:30:39 [01] ...done
  532. 180612 10:30:39 [01] Copying ./performance_schema/replication_group_member_stats.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/replication_group_member_stats.frm
  533. 180612 10:30:39 [01] ...done
  534. 180612 10:30:39 [01] Copying ./performance_schema/setup_actors.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/setup_actors.frm
  535. 180612 10:30:39 [01] ...done
  536. 180612 10:30:39 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/memory_summary_by_account_by_event_name.frm
  537. 180612 10:30:39 [01] ...done
  538. 180612 10:30:39 [01] Copying ./performance_schema/events_transactions_history_long.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_transactions_history_long.frm
  539. 180612 10:30:39 [01] ...done
  540. 180612 10:30:39 [01] Copying ./performance_schema/users.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/users.frm
  541. 180612 10:30:39 [01] ...done
  542. 180612 10:30:39 [01] Copying ./performance_schema/setup_consumers.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/setup_consumers.frm
  543. 180612 10:30:39 [01] ...done
  544. 180612 10:30:39 [01] Copying ./performance_schema/events_stages_history_long.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_stages_history_long.frm
  545. 180612 10:30:39 [01] ...done
  546. 180612 10:30:39 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_waits_summary_global_by_event_name.frm
  547. 180612 10:30:39 [01] ...done
  548. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_summary_by_program.frm
  549. 180612 10:30:39 [01] ...done
  550. 180612 10:30:39 [01] Copying ./performance_schema/file_instances.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/file_instances.frm
  551. 180612 10:30:39 [01] ...done
  552. 180612 10:30:39 [01] Copying ./performance_schema/table_handles.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/table_handles.frm
  553. 180612 10:30:39 [01] ...done
  554. 180612 10:30:39 [01] Copying ./performance_schema/variables_by_thread.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/variables_by_thread.frm
  555. 180612 10:30:39 [01] ...done
  556. 180612 10:30:39 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/memory_summary_global_by_event_name.frm
  557. 180612 10:30:39 [01] ...done
  558. 180612 10:30:39 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_transactions_summary_by_user_by_event_name.frm
  559. 180612 10:30:39 [01] ...done
  560. 180612 10:30:39 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/table_io_waits_summary_by_index_usage.frm
  561. 180612 10:30:39 [01] ...done
  562. 180612 10:30:39 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_transactions_summary_global_by_event_name.frm
  563. 180612 10:30:39 [01] ...done
  564. 180612 10:30:39 [01] Copying ./performance_schema/status_by_host.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/status_by_host.frm
  565. 180612 10:30:39 [01] ...done
  566. 180612 10:30:39 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_waits_summary_by_thread_by_event_name.frm
  567. 180612 10:30:39 [01] ...done
  568. 180612 10:30:39 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_stages_summary_by_account_by_event_name.frm
  569. 180612 10:30:39 [01] ...done
  570. 180612 10:30:39 [01] Copying ./performance_schema/session_connect_attrs.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/session_connect_attrs.frm
  571. 180612 10:30:39 [01] ...done
  572. 180612 10:30:39 [01] Copying ./performance_schema/status_by_account.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/status_by_account.frm
  573. 180612 10:30:39 [01] ...done
  574. 180612 10:30:39 [01] Copying ./performance_schema/metadata_locks.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/metadata_locks.frm
  575. 180612 10:30:39 [01] ...done
  576. 180612 10:30:39 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_transactions_summary_by_host_by_event_name.frm
  577. 180612 10:30:39 [01] ...done
  578. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_history_long.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_history_long.frm
  579. 180612 10:30:39 [01] ...done
  580. 180612 10:30:39 [01] Copying ./performance_schema/global_variables.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/global_variables.frm
  581. 180612 10:30:39 [01] ...done
  582. 180612 10:30:39 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/table_lock_waits_summary_by_table.frm
  583. 180612 10:30:39 [01] ...done
  584. 180612 10:30:39 [01] Copying ./performance_schema/mutex_instances.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/mutex_instances.frm
  585. 180612 10:30:39 [01] ...done
  586. 180612 10:30:39 [01] Copying ./performance_schema/session_status.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/session_status.frm
  587. 180612 10:30:39 [01] ...done
  588. 180612 10:30:39 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_transactions_summary_by_account_by_event_name.frm
  589. 180612 10:30:39 [01] ...done
  590. 180612 10:30:39 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_stages_summary_by_user_by_event_name.frm
  591. 180612 10:30:39 [01] ...done
  592. 180612 10:30:39 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/table_io_waits_summary_by_table.frm
  593. 180612 10:30:39 [01] ...done
  594. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_current.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_current.frm
  595. 180612 10:30:39 [01] ...done
  596. 180612 10:30:39 [01] Copying ./performance_schema/events_stages_current.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_stages_current.frm
  597. 180612 10:30:39 [01] ...done
  598. 180612 10:30:39 [01] Copying ./performance_schema/replication_connection_configuration.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/replication_connection_configuration.frm
  599. 180612 10:30:39 [01] ...done
  600. 180612 10:30:39 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/memory_summary_by_thread_by_event_name.frm
  601. 180612 10:30:39 [01] ...done
  602. 180612 10:30:39 [01] Copying ./performance_schema/status_by_thread.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/status_by_thread.frm
  603. 180612 10:30:39 [01] ...done
  604. 180612 10:30:39 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/replication_applier_status_by_worker.frm
  605. 180612 10:30:39 [01] ...done
  606. 180612 10:30:39 [01] Copying ./performance_schema/cond_instances.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/cond_instances.frm
  607. 180612 10:30:39 [01] ...done
  608. 180612 10:30:39 [01] Copying ./performance_schema/performance_timers.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/performance_timers.frm
  609. 180612 10:30:39 [01] ...done
  610. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_summary_global_by_event_name.frm
  611. 180612 10:30:39 [01] ...done
  612. 180612 10:30:39 [01] Copying ./performance_schema/accounts.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/accounts.frm
  613. 180612 10:30:39 [01] ...done
  614. 180612 10:30:39 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/session_account_connect_attrs.frm
  615. 180612 10:30:39 [01] ...done
  616. 180612 10:30:39 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_waits_summary_by_instance.frm
  617. 180612 10:30:39 [01] ...done
  618. 180612 10:30:39 [01] Copying ./performance_schema/setup_instruments.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/setup_instruments.frm
  619. 180612 10:30:39 [01] ...done
  620. 180612 10:30:39 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_waits_summary_by_user_by_event_name.frm
  621. 180612 10:30:39 [01] ...done
  622. 180612 10:30:39 [01] Copying ./performance_schema/events_waits_current.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_waits_current.frm
  623. 180612 10:30:39 [01] ...done
  624. 180612 10:30:39 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_stages_summary_by_thread_by_event_name.frm
  625. 180612 10:30:39 [01] ...done
  626. 180612 10:30:39 [01] Copying ./performance_schema/events_waits_history_long.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_waits_history_long.frm
  627. 180612 10:30:39 [01] ...done
  628. 180612 10:30:39 [01] Copying ./performance_schema/global_status.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/global_status.frm
  629. 180612 10:30:39 [01] ...done
  630. 180612 10:30:39 [01] Copying ./performance_schema/replication_group_members.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/replication_group_members.frm
  631. 180612 10:30:39 [01] ...done
  632. 180612 10:30:39 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_stages_summary_by_host_by_event_name.frm
  633. 180612 10:30:39 [01] ...done
  634. 180612 10:30:39 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/replication_applier_status_by_coordinator.frm
  635. 180612 10:30:39 [01] ...done
  636. 180612 10:30:39 [01] Copying ./performance_schema/file_summary_by_instance.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/file_summary_by_instance.frm
  637. 180612 10:30:39 [01] ...done
  638. 180612 10:30:39 [01] Copying ./performance_schema/events_transactions_current.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_transactions_current.frm
  639. 180612 10:30:39 [01] ...done
  640. 180612 10:30:39 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/socket_summary_by_event_name.frm
  641. 180612 10:30:39 [01] ...done
  642. 180612 10:30:39 [01] Copying ./performance_schema/db.opt to /backup/full_backup/2018-06-12_10-30-29/performance_schema/db.opt
  643. 180612 10:30:39 [01] ...done
  644. 180612 10:30:39 [01] Copying ./performance_schema/socket_instances.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/socket_instances.frm
  645. 180612 10:30:39 [01] ...done
  646. 180612 10:30:39 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_stages_summary_global_by_event_name.frm
  647. 180612 10:30:39 [01] ...done
  648. 180612 10:30:39 [01] Copying ./performance_schema/setup_timers.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/setup_timers.frm
  649. 180612 10:30:39 [01] ...done
  650. 180612 10:30:39 [01] Copying ./performance_schema/host_cache.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/host_cache.frm
  651. 180612 10:30:39 [01] ...done
  652. 180612 10:30:39 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_waits_summary_by_account_by_event_name.frm
  653. 180612 10:30:39 [01] ...done
  654. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_history.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_history.frm
  655. 180612 10:30:39 [01] ...done
  656. 180612 10:30:39 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
  657. 180612 10:30:39 [01] ...done
  658. 180612 10:30:39 [01] Copying ./performance_schema/user_variables_by_thread.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/user_variables_by_thread.frm
  659. 180612 10:30:39 [01] ...done
  660. 180612 10:30:39 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/file_summary_by_event_name.frm
  661. 180612 10:30:39 [01] ...done
  662. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_summary_by_user_by_event_name.frm
  663. 180612 10:30:39 [01] ...done
  664. 180612 10:30:39 [01] Copying ./performance_schema/events_stages_history.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_stages_history.frm
  665. 180612 10:30:39 [01] ...done
  666. 180612 10:30:39 [01] Copying ./performance_schema/replication_applier_status.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/replication_applier_status.frm
  667. 180612 10:30:39 [01] ...done
  668. 180612 10:30:39 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_statements_summary_by_account_by_event_name.frm
  669. 180612 10:30:39 [01] ...done
  670. 180612 10:30:39 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/socket_summary_by_instance.frm
  671. 180612 10:30:39 [01] ...done
  672. 180612 10:30:39 [01] Copying ./performance_schema/status_by_user.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/status_by_user.frm
  673. 180612 10:30:39 [01] ...done
  674. 180612 10:30:39 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/memory_summary_by_user_by_event_name.frm
  675. 180612 10:30:39 [01] ...done
  676. 180612 10:30:39 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/events_waits_summary_by_host_by_event_name.frm
  677. 180612 10:30:39 [01] ...done
  678. 180612 10:30:39 [01] Copying ./performance_schema/replication_applier_configuration.frm to /backup/full_backup/2018-06-12_10-30-29/performance_schema/replication_applier_configuration.frm
  679. 180612 10:30:39 [01] ...done
  680. 180612 10:30:39 Finished backing up non-InnoDB tables and files
  681. 180612 10:30:39 [00] Writing /backup/full_backup/2018-06-12_10-30-29/xtrabackup_binlog_info
  682. 180612 10:30:39 [00] ...done
  683. 180612 10:30:39 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
  684. xtrabackup: The latest check point (for incremental): '1540210034'
  685. xtrabackup: Stopping log copying thread.
  686. .180612 10:30:40 >> log scanned up to (1540210043)

  687. 180612 10:30:40 Executing UNLOCK TABLES
  688. 180612 10:30:40 All tables unlocked
  689. 180612 10:30:40 [00] Copying ib_buffer_pool to /backup/full_backup/2018-06-12_10-30-29/ib_buffer_pool
  690. 180612 10:30:40 [00] ...done
  691. 180612 10:30:40 Backup created in directory '/backup/full_backup/2018-06-12_10-30-29/'
  692. MySQL binlog position: filename 'mysql-bin.000012', position '1645'
  693. 180612 10:30:40 [00] Writing /backup/full_backup/2018-06-12_10-30-29/backup-my.cnf
  694. 180612 10:30:40 [00] ...done
  695. 180612 10:30:40 [00] Writing /backup/full_backup/2018-06-12_10-30-29/xtrabackup_info
  696. 180612 10:30:40 [00] ...done
  697. xtrabackup: Transaction log of lsn (1540210034) to (1540210043) was copied.
  698. 180612 10:30:40 completed OK!
查看全量备份信息:

点击(此处)折叠或打开

  1. [root@mysql5 2018-06-12_10-30-29]# cat xtrabackup_info
  2. uuid = 99098d6e-6de8-11e8-9520-080027240aa4
  3. name =
  4. tool_name = innobackupex
  5. tool_command = --defaults-file=/etc/my.cnf --user=backup --password=... --port=3306 /backup/full_backup/
  6. tool_version = 2.4.9
  7. ibbackup_version = 2.4.9
  8. server_version = 5.7.19-log
  9. start_time = 2018-06-12 10:30:29
  10. end_time = 2018-06-12 10:30:40
  11. lock_time = 0
  12. binlog_pos = filename 'mysql-bin.000012', position '1645'
  13. innodb_from_lsn = 0
  14. innodb_to_lsn = 1540210034
  15. partial = N
  16. incremental = N
  17. format = file
  18. compact = N
  19. compressed = N
  20. encrypted = N
4、对测试表插入数据

点击(此处)折叠或打开

  1. mysql> insert into test values(1,'0',30);
  2. Query OK, 1 row affected (0.05 sec)

  3. mysql> select * from test;
  4. +------+-----------+------+
  5. | id | user_type | code |
  6. +------+-----------+------+
  7. | 1 | 0 | 30 |
  8. +------+-----------+------+
  9. 1 row in set (0.00 sec)
5、以之前的全备做基础,做第一次增量备份

点击(此处)折叠或打开

  1. [root@mysql5 bin]# ./innobackupex --defaults-file=/etc/my.cnf --user=backup --password=mysql --port=3306 --incremental /backup/incr_backup/ --incremental-basedir=/backup/full_backup/2018-06-12_10-30-29/
  2. 180612 10:40:49 innobackupex: Starting the backup operation

  3. IMPORTANT: Please check that the backup run completes successfully.
  4.            At the end of a successful backup run innobackupex
  5.            prints "completed OK!".

  6. 180612 10:40:49 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/tmp/mysqld.sock' as 'backup' (using password: YES).
  7. 180612 10:40:49 version_check Connected to MySQL server
  8. 180612 10:40:49 version_check Executing a version check against the server...
  9. 180612 10:40:49 version_check Done.
  10. 180612 10:40:49 Connecting to MySQL server host: localhost, user: backup, password: set, port: 3306, socket: /tmp/mysqld.sock
  11. Using server version 5.7.19-log
  12. ./innobackupex version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4)
  13. incremental backup from 1540210034 is enabled.
  14. xtrabackup: uses posix_fadvise().
  15. xtrabackup: cd to /mysql/data
  16. xtrabackup: open files limit requested 65535, set to 65535
  17. xtrabackup: using the following InnoDB configuration:
  18. xtrabackup: innodb_data_home_dir = .
  19. xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
  20. xtrabackup: innodb_log_group_home_dir = ./
  21. xtrabackup: innodb_log_files_in_group = 2
  22. xtrabackup: innodb_log_file_size = 67108864
  23. xtrabackup: using O_DIRECT
  24. InnoDB: Number of pools: 1
  25. Warning: "test.test" uses engine "MEMORY" and will not be backed up.
  26. 180612 10:40:49 >> log scanned up to (1540210043)
  27. xtrabackup: Generating a list of tablespaces
  28. InnoDB: Allocated tablespace ID 64 for test/t_user_info, old maximum was 0
  29. 180612 10:40:49 [01] Copying ./ibdata1 to /backup/incr_backup/2018-06-12_10-40-49/ibdata1.delta
  30. 180612 10:40:49 [01] ...done
  31. 180612 10:40:49 [01] Copying ./test/t_user_info.ibd to /backup/incr_backup/2018-06-12_10-40-49/test/t_user_info.ibd.delta
  32. 180612 10:40:49 [01] ...done
  33. 180612 10:40:49 [01] Copying ./xcredit/tb_openapi.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_openapi.ibd.delta
  34. 180612 10:40:49 [01] ...done
  35. 180612 10:40:50 [01] Copying ./xcredit/tb_system_param.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_system_param.ibd.delta
  36. 180612 10:40:50 [01] ...done
  37. 180612 10:40:50 [01] Copying ./xcredit/tb_query_data_history.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_query_data_history.ibd.delta
  38. 180612 10:40:50 [01] ...done
  39. 180612 10:40:50 [01] Copying ./xcredit/tb_query_acquire_log.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_query_acquire_log.ibd.delta
  40. 180612 10:40:50 [01] ...done
  41. 180612 10:40:50 [01] Copying ./xcredit/tb_index.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_index.ibd.delta
  42. 180612 10:40:50 [01] ...done
  43. 180612 10:40:50 [01] Copying ./xcredit/tb_role_resource.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_role_resource.ibd.delta
  44. 180612 10:40:50 [01] ...done
  45. 180612 10:40:50 [01] Copying ./xcredit/tb_data_complaint.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_data_complaint.ibd.delta
  46. 180612 10:40:50 [01] ...done
  47. 180612 10:40:50 [01] Copying ./xcredit/tb_message.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_message.ibd.delta
  48. 180612 10:40:50 [01] ...done
  49. 180612 10:40:50 [01] Copying ./xcredit/tb_query_index_log.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_query_index_log.ibd.delta
  50. 180612 10:40:50 [01] ...done
  51. 180612 10:40:50 >> log scanned up to (1540210043)
  52. 180612 10:40:50 [01] Copying ./xcredit/tb_generic_data.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_generic_data.ibd.delta
  53. 180612 10:40:50 [01] ...done
  54. 180612 10:40:50 [01] Copying ./xcredit/tb_resource.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_resource.ibd.delta
  55. 180612 10:40:50 [01] ...done
  56. 180612 10:40:50 [01] Copying ./xcredit/tb_sync_job.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_sync_job.ibd.delta
  57. 180612 10:40:50 [01] ...done
  58. 180612 10:40:50 [01] Copying ./xcredit/tb_admin.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_admin.ibd.delta
  59. 180612 10:40:50 [01] ...done
  60. 180612 10:40:50 [01] Copying ./xcredit/tb_analyze_index.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_analyze_index.ibd.delta
  61. 180612 10:40:50 [01] ...done
  62. 180612 10:40:50 [01] Copying ./xcredit/tb_index_log.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_index_log.ibd.delta
  63. 180612 10:40:50 [01] ...done
  64. 180612 10:40:50 [01] Copying ./xcredit/tb_role.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_role.ibd.delta
  65. 180612 10:40:50 [01] ...done
  66. 180612 10:40:50 [01] Copying ./xcredit/tb_cert.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_cert.ibd.delta
  67. 180612 10:40:50 [01] ...done
  68. 180612 10:40:50 [01] Copying ./xcredit/tb_openapi_acquire_log.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_openapi_acquire_log.ibd.delta
  69. 180612 10:40:50 [01] ...done
  70. 180612 10:40:50 [01] Copying ./xcredit/tb_openapi_offer_log.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_openapi_offer_log.ibd.delta
  71. 180612 10:40:50 [01] ...done
  72. 180612 10:40:50 [01] Copying ./xcredit/tb_query_offer_log.ibd to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_query_offer_log.ibd.delta
  73. 180612 10:40:50 [01] ...done
  74. 180612 10:40:51 [01] Copying ./sys/sys_config.ibd to /backup/incr_backup/2018-06-12_10-40-49/sys/sys_config.ibd.delta
  75. 180612 10:40:51 [01] ...done
  76. 180612 10:40:51 [01] Copying ./mysql/help_topic.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/help_topic.ibd.delta
  77. 180612 10:40:51 [01] ...done
  78. 180612 10:40:51 [01] Copying ./mysql/slave_worker_info.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/slave_worker_info.ibd.delta
  79. 180612 10:40:51 [01] ...done
  80. 180612 10:40:51 [01] Copying ./mysql/time_zone.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone.ibd.delta
  81. 180612 10:40:51 [01] ...done
  82. 180612 10:40:51 [01] Copying ./mysql/slave_relay_log_info.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/slave_relay_log_info.ibd.delta
  83. 180612 10:40:51 [01] ...done
  84. 180612 10:40:51 [01] Copying ./mysql/help_relation.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/help_relation.ibd.delta
  85. 180612 10:40:51 [01] ...done
  86. 180612 10:40:51 [01] Copying ./mysql/help_keyword.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/help_keyword.ibd.delta
  87. 180612 10:40:51 [01] ...done
  88. 180612 10:40:51 [01] Copying ./mysql/help_category.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/help_category.ibd.delta
  89. 180612 10:40:51 [01] ...done
  90. 180612 10:40:51 [01] Copying ./mysql/server_cost.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/server_cost.ibd.delta
  91. 180612 10:40:51 [01] ...done
  92. 180612 10:40:51 >> log scanned up to (1540210043)
  93. 180612 10:40:51 [01] Copying ./mysql/innodb_index_stats.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/innodb_index_stats.ibd.delta
  94. 180612 10:40:51 [01] ...done
  95. 180612 10:40:51 [01] Copying ./mysql/time_zone_transition.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone_transition.ibd.delta
  96. 180612 10:40:51 [01] ...done
  97. 180612 10:40:51 [01] Copying ./mysql/user_bak.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/user_bak.ibd.delta
  98. 180612 10:40:51 [01] ...done
  99. 180612 10:40:51 [01] Copying ./mysql/time_zone_name.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone_name.ibd.delta
  100. 180612 10:40:51 [01] ...done
  101. 180612 10:40:51 [01] Copying ./mysql/gtid_executed.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/gtid_executed.ibd.delta
  102. 180612 10:40:51 [01] ...done
  103. 180612 10:40:51 [01] Copying ./mysql/slave_master_info.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/slave_master_info.ibd.delta
  104. 180612 10:40:51 [01] ...done
  105. 180612 10:40:51 [01] Copying ./mysql/time_zone_leap_second.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone_leap_second.ibd.delta
  106. 180612 10:40:51 [01] ...done
  107. 180612 10:40:51 [01] Copying ./mysql/servers.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/servers.ibd.delta
  108. 180612 10:40:51 [01] ...done
  109. 180612 10:40:51 [01] Copying ./mysql/time_zone_transition_type.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone_transition_type.ibd.delta
  110. 180612 10:40:51 [01] ...done
  111. 180612 10:40:51 [01] Copying ./mysql/plugin.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/plugin.ibd.delta
  112. 180612 10:40:51 [01] ...done
  113. 180612 10:40:51 [01] Copying ./mysql/innodb_table_stats.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/innodb_table_stats.ibd.delta
  114. 180612 10:40:51 [01] ...done
  115. 180612 10:40:51 [01] Copying ./mysql/engine_cost.ibd to /backup/incr_backup/2018-06-12_10-40-49/mysql/engine_cost.ibd.delta
  116. 180612 10:40:51 [01] ...done
  117. 180612 10:40:52 >> log scanned up to (1540210043)
  118. 180612 10:40:52 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
  119. 180612 10:40:52 Executing FLUSH TABLES WITH READ LOCK...
  120. 180612 10:40:52 Starting to backup non-InnoDB tables and files
  121. 180612 10:40:52 [01] Copying ./test/test.frm to /backup/incr_backup/2018-06-12_10-40-49/test/test.frm
  122. 180612 10:40:52 [01] ...done
  123. 180612 10:40:52 [01] Copying ./test/t_user_info.frm to /backup/incr_backup/2018-06-12_10-40-49/test/t_user_info.frm
  124. 180612 10:40:52 [01] ...done
  125. 180612 10:40:52 [01] Copying ./test/t_tou_info.frm to /backup/incr_backup/2018-06-12_10-40-49/test/t_tou_info.frm
  126. 180612 10:40:52 [01] ...done
  127. 180612 10:40:52 [01] Copying ./test/t_tou_info.MYI to /backup/incr_backup/2018-06-12_10-40-49/test/t_tou_info.MYI
  128. 180612 10:40:52 [01] ...done
  129. 180612 10:40:52 [01] Copying ./test/t_tou_info.MYD to /backup/incr_backup/2018-06-12_10-40-49/test/t_tou_info.MYD
  130. 180612 10:40:52 [01] ...done
  131. 180612 10:40:52 [01] Copying ./test/db.opt to /backup/incr_backup/2018-06-12_10-40-49/test/db.opt
  132. 180612 10:40:52 [01] ...done
  133. 180612 10:40:52 [01] Copying ./xcredit/tb_generic_data.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_generic_data.frm
  134. 180612 10:40:52 [01] ...done
  135. 180612 10:40:52 [01] Copying ./xcredit/tb_query_data_history.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_query_data_history.frm
  136. 180612 10:40:52 [01] ...done
  137. 180612 10:40:52 [01] Copying ./xcredit/tb_query_acquire_log.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_query_acquire_log.frm
  138. 180612 10:40:52 [01] ...done
  139. 180612 10:40:52 [01] Copying ./xcredit/tb_query_index_log.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_query_index_log.frm
  140. 180612 10:40:52 [01] ...done
  141. 180612 10:40:52 [01] Copying ./xcredit/tb_analyze_index.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_analyze_index.frm
  142. 180612 10:40:52 [01] ...done
  143. 180612 10:40:52 [01] Copying ./xcredit/tb_admin.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_admin.frm
  144. 180612 10:40:52 [01] ...done
  145. 180612 10:40:52 [01] Copying ./xcredit/tb_openapi_offer_log.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_openapi_offer_log.frm
  146. 180612 10:40:52 [01] ...done
  147. 180612 10:40:52 [01] Copying ./xcredit/tb_role.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_role.frm
  148. 180612 10:40:52 [01] ...done
  149. 180612 10:40:52 [01] Copying ./xcredit/tb_query_offer_log.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_query_offer_log.frm
  150. 180612 10:40:52 [01] ...done
  151. 180612 10:40:53 [01] Copying ./xcredit/tb_cert.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_cert.frm
  152. 180612 10:40:53 [01] ...done
  153. 180612 10:40:53 [01] Copying ./xcredit/tb_role_resource.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_role_resource.frm
  154. 180612 10:40:53 [01] ...done
  155. 180612 10:40:53 [01] Copying ./xcredit/tb_index.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_index.frm
  156. 180612 10:40:53 [01] ...done
  157. 180612 10:40:53 [01] Copying ./xcredit/tb_resource.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_resource.frm
  158. 180612 10:40:53 [01] ...done
  159. 180612 10:40:53 [01] Copying ./xcredit/tb_data_complaint.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_data_complaint.frm
  160. 180612 10:40:53 [01] ...done
  161. 180612 10:40:53 [01] Copying ./xcredit/tb_message.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_message.frm
  162. 180612 10:40:53 [01] ...done
  163. 180612 10:40:53 [01] Copying ./xcredit/tb_sync_job.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_sync_job.frm
  164. 180612 10:40:53 [01] ...done
  165. 180612 10:40:53 [01] Copying ./xcredit/tb_system_param.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_system_param.frm
  166. 180612 10:40:53 [01] ...done
  167. 180612 10:40:53 [01] Copying ./xcredit/tb_openapi_acquire_log.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_openapi_acquire_log.frm
  168. 180612 10:40:53 [01] ...done
  169. 180612 10:40:53 [01] Copying ./xcredit/db.opt to /backup/incr_backup/2018-06-12_10-40-49/xcredit/db.opt
  170. 180612 10:40:53 [01] ...done
  171. 180612 10:40:53 [01] Copying ./xcredit/tb_index_log.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_index_log.frm
  172. 180612 10:40:53 [01] ...done
  173. 180612 10:40:53 [01] Copying ./xcredit/tb_openapi.frm to /backup/incr_backup/2018-06-12_10-40-49/xcredit/tb_openapi.frm
  174. 180612 10:40:53 [01] ...done
  175. 180612 10:40:53 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024wait_classes_global_by_avg_latency.frm
  176. 180612 10:40:53 [01] ...done
  177. 180612 10:40:53 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/io_global_by_wait_by_bytes.frm
  178. 180612 10:40:53 [01] ...done
  179. 180612 10:40:53 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024memory_by_host_by_current_bytes.frm
  180. 180612 10:40:53 [01] ...done
  181. 180612 10:40:53 [01] Copying ./sys/user_summary.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/user_summary.frm
  182. 180612 10:40:53 [01] ...done
  183. 180612 10:40:53 [01] Copying ./sys/host_summary.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/host_summary.frm
  184. 180612 10:40:53 [01] ...done
  185. 180612 10:40:53 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
  186. 180612 10:40:53 [01] ...done
  187. 180612 10:40:53 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024waits_by_host_by_latency.frm
  188. 180612 10:40:53 [01] ...done
  189. 180612 10:40:53 [01] Copying ./sys/memory_global_total.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/memory_global_total.frm
  190. 180612 10:40:53 [01] ...done
  191. 180612 10:40:53 [01] Copying ./sys/memory_global_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/memory_global_by_current_bytes.frm
  192. 180612 10:40:53 [01] ...done
  193. 180612 10:40:53 [01] Copying ./sys/version.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/version.frm
  194. 180612 10:40:53 [01] ...done
  195. 180612 10:40:53 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024memory_by_thread_by_current_bytes.frm
  196. 180612 10:40:53 [01] ...done
  197. 180612 10:40:53 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/schema_table_statistics_with_buffer.frm
  198. 180612 10:40:53 [01] ...done
  199. 180612 10:40:53 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024schema_table_lock_waits.frm
  200. 180612 10:40:53 [01] ...done
  201. 180612 10:40:53 [01] Copying ./sys/statements_with_full_table_scans.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/statements_with_full_table_scans.frm
  202. 180612 10:40:53 [01] ...done
  203. 180612 10:40:53 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024innodb_buffer_stats_by_table.frm
  204. 180612 10:40:53 [01] ...done
  205. 180612 10:40:53 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/memory_by_user_by_current_bytes.frm
  206. 180612 10:40:53 [01] ...done
  207. 180612 10:40:53 [01] Copying ./sys/schema_redundant_indexes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/schema_redundant_indexes.frm
  208. 180612 10:40:53 [01] ...done
  209. 180612 10:40:53 [01] Copying ./sys/latest_file_io.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/latest_file_io.frm
  210. 180612 10:40:53 [01] ...done
  211. 180612 10:40:53 [01] Copying ./sys/statements_with_temp_tables.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/statements_with_temp_tables.frm
  212. 180612 10:40:53 [01] ...done
  213. 180612 10:40:53 [01] Copying ./sys/session.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/session.frm
  214. 180612 10:40:53 [01] ...done
  215. 180612 10:40:53 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/io_global_by_file_by_bytes.frm
  216. 180612 10:40:53 [01] ...done
  217. 180612 10:40:53 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024schema_table_statistics_with_buffer.frm
  218. 180612 10:40:53 [01] ...done
  219. 180612 10:40:53 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024io_by_thread_by_latency.frm
  220. 180612 10:40:53 [01] ...done
  221. 180612 10:40:53 [01] Copying ./sys/sys_config.TRG to /backup/incr_backup/2018-06-12_10-40-49/sys/sys_config.TRG
  222. 180612 10:40:53 [01] ...done
  223. 180612 10:40:53 [01] Copying ./sys/x@0024memory_global_total.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024memory_global_total.frm
  224. 180612 10:40:53 [01] ...done
  225. 180612 10:40:53 [01] Copying ./sys/x@0024statement_analysis.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024statement_analysis.frm
  226. 180612 10:40:53 [01] ...done
  227. 180612 10:40:53 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/innodb_buffer_stats_by_schema.frm
  228. 180612 10:40:53 [01] ...done
  229. 180612 10:40:53 [01] Copying ./sys/schema_unused_indexes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/schema_unused_indexes.frm
  230. 180612 10:40:53 [01] ...done
  231. 180612 10:40:53 [01] Copying ./sys/sys_config_update_set_user.TRN to /backup/incr_backup/2018-06-12_10-40-49/sys/sys_config_update_set_user.TRN
  232. 180612 10:40:53 [01] ...done
  233. 180612 10:40:53 [01] Copying ./sys/user_summary_by_statement_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/user_summary_by_statement_latency.frm
  234. 180612 10:40:53 [01] ...done
  235. 180612 10:40:53 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024ps_digest_avg_latency_distribution.frm
  236. 180612 10:40:53 [01] ...done
  237. 180612 10:40:53 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024io_global_by_wait_by_latency.frm
  238. 180612 10:40:53 [01] ...done
  239. 180612 10:40:53 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024host_summary_by_stages.frm
  240. 180612 10:40:53 [01] ...done
  241. 180612 10:40:53 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024user_summary_by_statement_latency.frm
  242. 180612 10:40:53 [01] ...done
  243. 180612 10:40:53 [01] Copying ./sys/statement_analysis.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/statement_analysis.frm
  244. 180612 10:40:53 [01] ...done
  245. 180612 10:40:53 [01] Copying ./sys/user_summary_by_file_io_type.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/user_summary_by_file_io_type.frm
  246. 180612 10:40:53 [01] ...done
  247. 180612 10:40:53 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/statements_with_runtimes_in_95th_percentile.frm
  248. 180612 10:40:53 [01] ...done
  249. 180612 10:40:53 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024waits_by_user_by_latency.frm
  250. 180612 10:40:53 [01] ...done
  251. 180612 10:40:53 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024waits_global_by_latency.frm
  252. 180612 10:40:53 [01] ...done
  253. 180612 10:40:53 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/innodb_buffer_stats_by_table.frm
  254. 180612 10:40:53 [01] ...done
  255. 180612 10:40:53 >> log scanned up to (1540210043)
  256. 180612 10:40:53 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024memory_by_user_by_current_bytes.frm
  257. 180612 10:40:53 [01] ...done
  258. 180612 10:40:53 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/schema_tables_with_full_table_scans.frm
  259. 180612 10:40:53 [01] ...done
  260. 180612 10:40:53 [01] Copying ./sys/waits_by_user_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/waits_by_user_by_latency.frm
  261. 180612 10:40:53 [01] ...done
  262. 180612 10:40:53 [01] Copying ./sys/x@0024session.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024session.frm
  263. 180612 10:40:53 [01] ...done
  264. 180612 10:40:53 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024statements_with_errors_or_warnings.frm
  265. 180612 10:40:53 [01] ...done
  266. 180612 10:40:53 [01] Copying ./sys/host_summary_by_statement_type.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/host_summary_by_statement_type.frm
  267. 180612 10:40:53 [01] ...done
  268. 180612 10:40:53 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024user_summary_by_file_io.frm
  269. 180612 10:40:53 [01] ...done
  270. 180612 10:40:53 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024host_summary_by_file_io.frm
  271. 180612 10:40:53 [01] ...done
  272. 180612 10:40:53 [01] Copying ./sys/host_summary_by_file_io_type.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/host_summary_by_file_io_type.frm
  273. 180612 10:40:53 [01] ...done
  274. 180612 10:40:53 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024schema_tables_with_full_table_scans.frm
  275. 180612 10:40:53 [01] ...done
  276. 180612 10:40:53 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/memory_by_host_by_current_bytes.frm
  277. 180612 10:40:53 [01] ...done
  278. 180612 10:40:53 [01] Copying ./sys/x@0024processlist.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024processlist.frm
  279. 180612 10:40:53 [01] ...done
  280. 180612 10:40:53 [01] Copying ./sys/user_summary_by_statement_type.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/user_summary_by_statement_type.frm
  281. 180612 10:40:53 [01] ...done
  282. 180612 10:40:53 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024io_global_by_file_by_latency.frm
  283. 180612 10:40:53 [01] ...done
  284. 180612 10:40:53 [01] Copying ./sys/x@0024schema_index_statistics.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024schema_index_statistics.frm
  285. 180612 10:40:53 [01] ...done
  286. 180612 10:40:53 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
  287. 180612 10:40:53 [01] ...done
  288. 180612 10:40:53 [01] Copying ./sys/x@0024host_summary.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024host_summary.frm
  289. 180612 10:40:53 [01] ...done
  290. 180612 10:40:53 [01] Copying ./sys/host_summary_by_file_io.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/host_summary_by_file_io.frm
  291. 180612 10:40:53 [01] ...done
  292. 180612 10:40:53 [01] Copying ./sys/schema_table_statistics.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/schema_table_statistics.frm
  293. 180612 10:40:53 [01] ...done
  294. 180612 10:40:53 [01] Copying ./sys/innodb_lock_waits.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/innodb_lock_waits.frm
  295. 180612 10:40:53 [01] ...done
  296. 180612 10:40:53 [01] Copying ./sys/x@0024schema_table_statistics.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024schema_table_statistics.frm
  297. 180612 10:40:53 [01] ...done
  298. 180612 10:40:53 [01] Copying ./sys/host_summary_by_statement_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/host_summary_by_statement_latency.frm
  299. 180612 10:40:53 [01] ...done
  300. 180612 10:40:53 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024statements_with_temp_tables.frm
  301. 180612 10:40:53 [01] ...done
  302. 180612 10:40:53 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/wait_classes_global_by_avg_latency.frm
  303. 180612 10:40:53 [01] ...done
  304. 180612 10:40:53 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024host_summary_by_statement_latency.frm
  305. 180612 10:40:53 [01] ...done
  306. 180612 10:40:53 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/statements_with_errors_or_warnings.frm
  307. 180612 10:40:53 [01] ...done
  308. 180612 10:40:53 [01] Copying ./sys/waits_by_host_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/waits_by_host_by_latency.frm
  309. 180612 10:40:53 [01] ...done
  310. 180612 10:40:53 [01] Copying ./sys/schema_object_overview.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/schema_object_overview.frm
  311. 180612 10:40:53 [01] ...done
  312. 180612 10:40:53 [01] Copying ./sys/schema_table_lock_waits.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/schema_table_lock_waits.frm
  313. 180612 10:40:53 [01] ...done
  314. 180612 10:40:53 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024io_global_by_wait_by_bytes.frm
  315. 180612 10:40:53 [01] ...done
  316. 180612 10:40:53 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024wait_classes_global_by_latency.frm
  317. 180612 10:40:53 [01] ...done
  318. 180612 10:40:53 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024host_summary_by_file_io_type.frm
  319. 180612 10:40:53 [01] ...done
  320. 180612 10:40:53 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024innodb_buffer_stats_by_schema.frm
  321. 180612 10:40:53 [01] ...done
  322. 180612 10:40:53 [01] Copying ./sys/waits_global_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/waits_global_by_latency.frm
  323. 180612 10:40:53 [01] ...done
  324. 180612 10:40:53 [01] Copying ./sys/sys_config_insert_set_user.TRN to /backup/incr_backup/2018-06-12_10-40-49/sys/sys_config_insert_set_user.TRN
  325. 180612 10:40:53 [01] ...done
  326. 180612 10:40:53 [01] Copying ./sys/schema_index_statistics.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/schema_index_statistics.frm
  327. 180612 10:40:53 [01] ...done
  328. 180612 10:40:53 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024ps_schema_table_statistics_io.frm
  329. 180612 10:40:53 [01] ...done
  330. 180612 10:40:53 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/io_global_by_wait_by_latency.frm
  331. 180612 10:40:53 [01] ...done
  332. 180612 10:40:53 [01] Copying ./sys/io_global_by_file_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/io_global_by_file_by_latency.frm
  333. 180612 10:40:53 [01] ...done
  334. 180612 10:40:53 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024user_summary_by_file_io_type.frm
  335. 180612 10:40:53 [01] ...done
  336. 180612 10:40:53 [01] Copying ./sys/host_summary_by_stages.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/host_summary_by_stages.frm
  337. 180612 10:40:53 [01] ...done
  338. 180612 10:40:53 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024host_summary_by_statement_type.frm
  339. 180612 10:40:53 [01] ...done
  340. 180612 10:40:53 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024statements_with_full_table_scans.frm
  341. 180612 10:40:53 [01] ...done
  342. 180612 10:40:53 [01] Copying ./sys/metrics.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/metrics.frm
  343. 180612 10:40:53 [01] ...done
  344. 180612 10:40:53 [01] Copying ./sys/wait_classes_global_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/wait_classes_global_by_latency.frm
  345. 180612 10:40:53 [01] ...done
  346. 180612 10:40:53 [01] Copying ./sys/x@0024statements_with_sorting.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024statements_with_sorting.frm
  347. 180612 10:40:53 [01] ...done
  348. 180612 10:40:53 [01] Copying ./sys/user_summary_by_stages.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/user_summary_by_stages.frm
  349. 180612 10:40:53 [01] ...done
  350. 180612 10:40:53 [01] Copying ./sys/sys_config.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/sys_config.frm
  351. 180612 10:40:53 [01] ...done
  352. 180612 10:40:53 [01] Copying ./sys/session_ssl_status.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/session_ssl_status.frm
  353. 180612 10:40:53 [01] ...done
  354. 180612 10:40:53 [01] Copying ./sys/statements_with_sorting.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/statements_with_sorting.frm
  355. 180612 10:40:53 [01] ...done
  356. 180612 10:40:53 [01] Copying ./sys/x@0024latest_file_io.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024latest_file_io.frm
  357. 180612 10:40:53 [01] ...done
  358. 180612 10:40:53 [01] Copying ./sys/db.opt to /backup/incr_backup/2018-06-12_10-40-49/sys/db.opt
  359. 180612 10:40:53 [01] ...done
  360. 180612 10:40:53 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024user_summary_by_stages.frm
  361. 180612 10:40:53 [01] ...done
  362. 180612 10:40:53 [01] Copying ./sys/io_by_thread_by_latency.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/io_by_thread_by_latency.frm
  363. 180612 10:40:53 [01] ...done
  364. 180612 10:40:53 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024io_global_by_file_by_bytes.frm
  365. 180612 10:40:53 [01] ...done
  366. 180612 10:40:53 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024innodb_lock_waits.frm
  367. 180612 10:40:53 [01] ...done
  368. 180612 10:40:53 [01] Copying ./sys/user_summary_by_file_io.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/user_summary_by_file_io.frm
  369. 180612 10:40:53 [01] ...done
  370. 180612 10:40:53 [01] Copying ./sys/processlist.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/processlist.frm
  371. 180612 10:40:53 [01] ...done
  372. 180612 10:40:53 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024memory_global_by_current_bytes.frm
  373. 180612 10:40:53 [01] ...done
  374. 180612 10:40:53 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/ps_check_lost_instrumentation.frm
  375. 180612 10:40:53 [01] ...done
  376. 180612 10:40:53 [01] Copying ./sys/x@0024user_summary.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024user_summary.frm
  377. 180612 10:40:53 [01] ...done
  378. 180612 10:40:53 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024schema_flattened_keys.frm
  379. 180612 10:40:53 [01] ...done
  380. 180612 10:40:53 [01] Copying ./sys/schema_auto_increment_columns.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/schema_auto_increment_columns.frm
  381. 180612 10:40:53 [01] ...done
  382. 180612 10:40:54 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/x@0024user_summary_by_statement_type.frm
  383. 180612 10:40:54 [01] ...done
  384. 180612 10:40:54 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-40-49/sys/memory_by_thread_by_current_bytes.frm
  385. 180612 10:40:54 [01] ...done
  386. 180612 10:40:54 [01] Copying ./mysql/tables_priv.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/tables_priv.frm
  387. 180612 10:40:54 [01] ...done
  388. 180612 10:40:54 [01] Copying ./mysql/proc.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/proc.MYD
  389. 180612 10:40:54 [01] ...done
  390. 180612 10:40:54 [01] Copying ./mysql/server_cost.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/server_cost.frm
  391. 180612 10:40:54 [01] ...done
  392. 180612 10:40:54 [01] Copying ./mysql/proxies_priv.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/proxies_priv.frm
  393. 180612 10:40:54 [01] ...done
  394. 180612 10:40:54 [01] Copying ./mysql/procs_priv.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/procs_priv.MYI
  395. 180612 10:40:54 [01] ...done
  396. 180612 10:40:54 [01] Copying ./mysql/event.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/event.MYI
  397. 180612 10:40:54 [01] ...done
  398. 180612 10:40:54 [01] Copying ./mysql/slave_worker_info.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/slave_worker_info.frm
  399. 180612 10:40:54 [01] ...done
  400. 180612 10:40:54 [01] Copying ./mysql/user_bak.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/user_bak.frm
  401. 180612 10:40:54 [01] ...done
  402. 180612 10:40:54 [01] Copying ./mysql/time_zone.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone.frm
  403. 180612 10:40:54 [01] ...done
  404. 180612 10:40:54 [01] Copying ./mysql/help_relation.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/help_relation.frm
  405. 180612 10:40:54 [01] ...done
  406. 180612 10:40:54 [01] Copying ./mysql/time_zone_transition_type.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone_transition_type.frm
  407. 180612 10:40:54 [01] ...done
  408. 180612 10:40:54 [01] Copying ./mysql/help_topic.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/help_topic.frm
  409. 180612 10:40:54 [01] ...done
  410. 180612 10:40:54 [01] Copying ./mysql/db.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/db.MYD
  411. 180612 10:40:54 [01] ...done
  412. 180612 10:40:54 [01] Copying ./mysql/slow_log.CSM to /backup/incr_backup/2018-06-12_10-40-49/mysql/slow_log.CSM
  413. 180612 10:40:54 [01] ...done
  414. 180612 10:40:54 [01] Copying ./mysql/slow_log.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/slow_log.frm
  415. 180612 10:40:54 [01] ...done
  416. 180612 10:40:54 [01] Copying ./mysql/general_log.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/general_log.frm
  417. 180612 10:40:54 [01] ...done
  418. 180612 10:40:54 [01] Copying ./mysql/slave_relay_log_info.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/slave_relay_log_info.frm
  419. 180612 10:40:54 [01] ...done
  420. 180612 10:40:54 [01] Copying ./mysql/tables_priv.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/tables_priv.MYI
  421. 180612 10:40:54 [01] ...done
  422. 180612 10:40:54 [01] Copying ./mysql/ndb_binlog_index.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/ndb_binlog_index.MYD
  423. 180612 10:40:54 [01] ...done
  424. 180612 10:40:54 [01] Copying ./mysql/slave_master_info.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/slave_master_info.frm
  425. 180612 10:40:54 [01] ...done
  426. 180612 10:40:54 [01] Copying ./mysql/func.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/func.frm
  427. 180612 10:40:54 [01] ...done
  428. 180612 10:40:54 [01] Copying ./mysql/proc.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/proc.frm
  429. 180612 10:40:54 [01] ...done
  430. 180612 10:40:54 [01] Copying ./mysql/time_zone_name.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone_name.frm
  431. 180612 10:40:54 [01] ...done
  432. 180612 10:40:54 [01] Copying ./mysql/func.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/func.MYD
  433. 180612 10:40:54 [01] ...done
  434. 180612 10:40:54 [01] Copying ./mysql/procs_priv.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/procs_priv.frm
  435. 180612 10:40:54 [01] ...done
  436. 180612 10:40:54 [01] Copying ./mysql/tables_priv.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/tables_priv.MYD
  437. 180612 10:40:54 [01] ...done
  438. 180612 10:40:54 [01] Copying ./mysql/columns_priv.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/columns_priv.MYI
  439. 180612 10:40:54 [01] ...done
  440. 180612 10:40:54 [01] Copying ./mysql/general_log.CSM to /backup/incr_backup/2018-06-12_10-40-49/mysql/general_log.CSM
  441. 180612 10:40:54 [01] ...done
  442. 180612 10:40:54 [01] Copying ./mysql/ndb_binlog_index.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/ndb_binlog_index.frm
  443. 180612 10:40:54 [01] ...done
  444. 180612 10:40:54 [01] Copying ./mysql/gtid_executed.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/gtid_executed.frm
  445. 180612 10:40:54 [01] ...done
  446. 180612 10:40:54 [01] Copying ./mysql/procs_priv.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/procs_priv.MYD
  447. 180612 10:40:54 [01] ...done
  448. 180612 10:40:54 [01] Copying ./mysql/func.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/func.MYI
  449. 180612 10:40:54 >> log scanned up to (1540210043)
  450. 180612 10:40:54 [01] ...done
  451. 180612 10:40:54 [01] Copying ./mysql/help_keyword.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/help_keyword.frm
  452. 180612 10:40:54 [01] ...done
  453. 180612 10:40:54 [01] Copying ./mysql/columns_priv.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/columns_priv.frm
  454. 180612 10:40:54 [01] ...done
  455. 180612 10:40:54 [01] Copying ./mysql/proxies_priv.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/proxies_priv.MYI
  456. 180612 10:40:54 [01] ...done
  457. 180612 10:40:54 [01] Copying ./mysql/proc.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/proc.MYI
  458. 180612 10:40:54 [01] ...done
  459. 180612 10:40:54 [01] Copying ./mysql/time_zone_transition.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone_transition.frm
  460. 180612 10:40:54 [01] ...done
  461. 180612 10:40:54 [01] Copying ./mysql/time_zone_leap_second.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/time_zone_leap_second.frm
  462. 180612 10:40:54 [01] ...done
  463. 180612 10:40:54 [01] Copying ./mysql/general_log.CSV to /backup/incr_backup/2018-06-12_10-40-49/mysql/general_log.CSV
  464. 180612 10:40:54 [01] ...done
  465. 180612 10:40:54 [01] Copying ./mysql/servers.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/servers.frm
  466. 180612 10:40:54 [01] ...done
  467. 180612 10:40:54 [01] Copying ./mysql/help_category.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/help_category.frm
  468. 180612 10:40:54 [01] ...done
  469. 180612 10:40:54 [01] Copying ./mysql/proxies_priv.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/proxies_priv.MYD
  470. 180612 10:40:54 [01] ...done
  471. 180612 10:40:54 [01] Copying ./mysql/event.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/event.MYD
  472. 180612 10:40:54 [01] ...done
  473. 180612 10:40:54 [01] Copying ./mysql/engine_cost.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/engine_cost.frm
  474. 180612 10:40:54 [01] ...done
  475. 180612 10:40:54 [01] Copying ./mysql/user.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/user.frm
  476. 180612 10:40:54 [01] ...done
  477. 180612 10:40:54 [01] Copying ./mysql/ndb_binlog_index.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/ndb_binlog_index.MYI
  478. 180612 10:40:54 [01] ...done
  479. 180612 10:40:54 [01] Copying ./mysql/db.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/db.frm
  480. 180612 10:40:54 [01] ...done
  481. 180612 10:40:54 [01] Copying ./mysql/plugin.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/plugin.frm
  482. 180612 10:40:54 [01] ...done
  483. 180612 10:40:54 [01] Copying ./mysql/db.opt to /backup/incr_backup/2018-06-12_10-40-49/mysql/db.opt
  484. 180612 10:40:54 [01] ...done
  485. 180612 10:40:54 [01] Copying ./mysql/user.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/user.MYI
  486. 180612 10:40:54 [01] ...done
  487. 180612 10:40:54 [01] Copying ./mysql/columns_priv.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/columns_priv.MYD
  488. 180612 10:40:54 [01] ...done
  489. 180612 10:40:54 [01] Copying ./mysql/innodb_table_stats.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/innodb_table_stats.frm
  490. 180612 10:40:54 [01] ...done
  491. 180612 10:40:54 [01] Copying ./mysql/innodb_index_stats.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/innodb_index_stats.frm
  492. 180612 10:40:54 [01] ...done
  493. 180612 10:40:54 [01] Copying ./mysql/event.frm to /backup/incr_backup/2018-06-12_10-40-49/mysql/event.frm
  494. 180612 10:40:54 [01] ...done
  495. 180612 10:40:54 [01] Copying ./mysql/slow_log.CSV to /backup/incr_backup/2018-06-12_10-40-49/mysql/slow_log.CSV
  496. 180612 10:40:54 [01] ...done
  497. 180612 10:40:54 [01] Copying ./mysql/db.MYI to /backup/incr_backup/2018-06-12_10-40-49/mysql/db.MYI
  498. 180612 10:40:54 [01] ...done
  499. 180612 10:40:54 [01] Copying ./mysql/user.MYD to /backup/incr_backup/2018-06-12_10-40-49/mysql/user.MYD
  500. 180612 10:40:54 [01] ...done
  501. 180612 10:40:54 [01] Copying ./performance_schema/events_transactions_history.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_transactions_history.frm
  502. 180612 10:40:54 [01] ...done
  503. 180612 10:40:54 [01] Copying ./performance_schema/events_waits_history.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_waits_history.frm
  504. 180612 10:40:54 [01] ...done
  505. 180612 10:40:54 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_summary_by_digest.frm
  506. 180612 10:40:54 [01] ...done
  507. 180612 10:40:54 [01] Copying ./performance_schema/hosts.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/hosts.frm
  508. 180612 10:40:54 [01] ...done
  509. 180612 10:40:54 [01] Copying ./performance_schema/prepared_statements_instances.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/prepared_statements_instances.frm
  510. 180612 10:40:54 [01] ...done
  511. 180612 10:40:54 [01] Copying ./performance_schema/rwlock_instances.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/rwlock_instances.frm
  512. 180612 10:40:54 [01] ...done
  513. 180612 10:40:54 [01] Copying ./performance_schema/threads.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/threads.frm
  514. 180612 10:40:54 [01] ...done
  515. 180612 10:40:54 [01] Copying ./performance_schema/setup_objects.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/setup_objects.frm
  516. 180612 10:40:54 [01] ...done
  517. 180612 10:40:54 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/objects_summary_global_by_type.frm
  518. 180612 10:40:54 [01] ...done
  519. 180612 10:40:54 [01] Copying ./performance_schema/replication_connection_status.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/replication_connection_status.frm
  520. 180612 10:40:55 [01] ...done
  521. 180612 10:40:55 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_summary_by_thread_by_event_name.frm
  522. 180612 10:40:55 [01] ...done
  523. 180612 10:40:55 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/memory_summary_by_host_by_event_name.frm
  524. 180612 10:40:55 [01] ...done
  525. 180612 10:40:55 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_summary_by_host_by_event_name.frm
  526. 180612 10:40:55 [01] ...done
  527. 180612 10:40:55 [01] Copying ./performance_schema/session_variables.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/session_variables.frm
  528. 180612 10:40:55 [01] ...done
  529. 180612 10:40:55 [01] Copying ./performance_schema/replication_group_member_stats.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/replication_group_member_stats.frm
  530. 180612 10:40:55 [01] ...done
  531. 180612 10:40:55 [01] Copying ./performance_schema/setup_actors.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/setup_actors.frm
  532. 180612 10:40:55 [01] ...done
  533. 180612 10:40:55 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/memory_summary_by_account_by_event_name.frm
  534. 180612 10:40:55 [01] ...done
  535. 180612 10:40:55 [01] Copying ./performance_schema/events_transactions_history_long.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_transactions_history_long.frm
  536. 180612 10:40:55 [01] ...done
  537. 180612 10:40:55 [01] Copying ./performance_schema/users.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/users.frm
  538. 180612 10:40:55 [01] ...done
  539. 180612 10:40:55 [01] Copying ./performance_schema/setup_consumers.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/setup_consumers.frm
  540. 180612 10:40:55 [01] ...done
  541. 180612 10:40:55 [01] Copying ./performance_schema/events_stages_history_long.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_stages_history_long.frm
  542. 180612 10:40:55 [01] ...done
  543. 180612 10:40:55 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_waits_summary_global_by_event_name.frm
  544. 180612 10:40:55 [01] ...done
  545. 180612 10:40:55 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_summary_by_program.frm
  546. 180612 10:40:55 [01] ...done
  547. 180612 10:40:55 [01] Copying ./performance_schema/file_instances.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/file_instances.frm
  548. 180612 10:40:55 [01] ...done
  549. 180612 10:40:55 [01] Copying ./performance_schema/table_handles.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/table_handles.frm
  550. 180612 10:40:55 [01] ...done
  551. 180612 10:40:55 [01] Copying ./performance_schema/variables_by_thread.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/variables_by_thread.frm
  552. 180612 10:40:55 [01] ...done
  553. 180612 10:40:55 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/memory_summary_global_by_event_name.frm
  554. 180612 10:40:55 [01] ...done
  555. 180612 10:40:55 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_transactions_summary_by_user_by_event_name.frm
  556. 180612 10:40:55 [01] ...done
  557. 180612 10:40:55 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/table_io_waits_summary_by_index_usage.frm
  558. 180612 10:40:55 [01] ...done
  559. 180612 10:40:55 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_transactions_summary_global_by_event_name.frm
  560. 180612 10:40:55 [01] ...done
  561. 180612 10:40:55 [01] Copying ./performance_schema/status_by_host.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/status_by_host.frm
  562. 180612 10:40:55 [01] ...done
  563. 180612 10:40:55 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_waits_summary_by_thread_by_event_name.frm
  564. 180612 10:40:55 [01] ...done
  565. 180612 10:40:55 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_stages_summary_by_account_by_event_name.frm
  566. 180612 10:40:55 [01] ...done
  567. 180612 10:40:55 [01] Copying ./performance_schema/session_connect_attrs.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/session_connect_attrs.frm
  568. 180612 10:40:55 [01] ...done
  569. 180612 10:40:55 [01] Copying ./performance_schema/status_by_account.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/status_by_account.frm
  570. 180612 10:40:55 [01] ...done
  571. 180612 10:40:55 [01] Copying ./performance_schema/metadata_locks.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/metadata_locks.frm
  572. 180612 10:40:55 [01] ...done
  573. 180612 10:40:55 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_transactions_summary_by_host_by_event_name.frm
  574. 180612 10:40:55 >> log scanned up to (1540210043)
  575. 180612 10:40:55 [01] ...done
  576. 180612 10:40:55 [01] Copying ./performance_schema/events_statements_history_long.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_history_long.frm
  577. 180612 10:40:55 [01] ...done
  578. 180612 10:40:55 [01] Copying ./performance_schema/global_variables.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/global_variables.frm
  579. 180612 10:40:55 [01] ...done
  580. 180612 10:40:55 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/table_lock_waits_summary_by_table.frm
  581. 180612 10:40:55 [01] ...done
  582. 180612 10:40:55 [01] Copying ./performance_schema/mutex_instances.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/mutex_instances.frm
  583. 180612 10:40:55 [01] ...done
  584. 180612 10:40:55 [01] Copying ./performance_schema/session_status.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/session_status.frm
  585. 180612 10:40:55 [01] ...done
  586. 180612 10:40:55 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_transactions_summary_by_account_by_event_name.frm
  587. 180612 10:40:55 [01] ...done
  588. 180612 10:40:55 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_stages_summary_by_user_by_event_name.frm
  589. 180612 10:40:55 [01] ...done
  590. 180612 10:40:55 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/table_io_waits_summary_by_table.frm
  591. 180612 10:40:55 [01] ...done
  592. 180612 10:40:55 [01] Copying ./performance_schema/events_statements_current.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_current.frm
  593. 180612 10:40:55 [01] ...done
  594. 180612 10:40:55 [01] Copying ./performance_schema/events_stages_current.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_stages_current.frm
  595. 180612 10:40:55 [01] ...done
  596. 180612 10:40:55 [01] Copying ./performance_schema/replication_connection_configuration.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/replication_connection_configuration.frm
  597. 180612 10:40:55 [01] ...done
  598. 180612 10:40:55 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/memory_summary_by_thread_by_event_name.frm
  599. 180612 10:40:55 [01] ...done
  600. 180612 10:40:55 [01] Copying ./performance_schema/status_by_thread.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/status_by_thread.frm
  601. 180612 10:40:55 [01] ...done
  602. 180612 10:40:55 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/replication_applier_status_by_worker.frm
  603. 180612 10:40:55 [01] ...done
  604. 180612 10:40:55 [01] Copying ./performance_schema/cond_instances.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/cond_instances.frm
  605. 180612 10:40:55 [01] ...done
  606. 180612 10:40:55 [01] Copying ./performance_schema/performance_timers.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/performance_timers.frm
  607. 180612 10:40:55 [01] ...done
  608. 180612 10:40:55 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_summary_global_by_event_name.frm
  609. 180612 10:40:55 [01] ...done
  610. 180612 10:40:55 [01] Copying ./performance_schema/accounts.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/accounts.frm
  611. 180612 10:40:55 [01] ...done
  612. 180612 10:40:55 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/session_account_connect_attrs.frm
  613. 180612 10:40:55 [01] ...done
  614. 180612 10:40:55 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_waits_summary_by_instance.frm
  615. 180612 10:40:55 [01] ...done
  616. 180612 10:40:55 [01] Copying ./performance_schema/setup_instruments.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/setup_instruments.frm
  617. 180612 10:40:55 [01] ...done
  618. 180612 10:40:55 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_waits_summary_by_user_by_event_name.frm
  619. 180612 10:40:55 [01] ...done
  620. 180612 10:40:55 [01] Copying ./performance_schema/events_waits_current.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_waits_current.frm
  621. 180612 10:40:55 [01] ...done
  622. 180612 10:40:55 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_stages_summary_by_thread_by_event_name.frm
  623. 180612 10:40:55 [01] ...done
  624. 180612 10:40:55 [01] Copying ./performance_schema/events_waits_history_long.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_waits_history_long.frm
  625. 180612 10:40:55 [01] ...done
  626. 180612 10:40:55 [01] Copying ./performance_schema/global_status.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/global_status.frm
  627. 180612 10:40:55 [01] ...done
  628. 180612 10:40:55 [01] Copying ./performance_schema/replication_group_members.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/replication_group_members.frm
  629. 180612 10:40:55 [01] ...done
  630. 180612 10:40:55 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_stages_summary_by_host_by_event_name.frm
  631. 180612 10:40:55 [01] ...done
  632. 180612 10:40:55 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/replication_applier_status_by_coordinator.frm
  633. 180612 10:40:55 [01] ...done
  634. 180612 10:40:55 [01] Copying ./performance_schema/file_summary_by_instance.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/file_summary_by_instance.frm
  635. 180612 10:40:55 [01] ...done
  636. 180612 10:40:55 [01] Copying ./performance_schema/events_transactions_current.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_transactions_current.frm
  637. 180612 10:40:55 [01] ...done
  638. 180612 10:40:55 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/socket_summary_by_event_name.frm
  639. 180612 10:40:55 [01] ...done
  640. 180612 10:40:55 [01] Copying ./performance_schema/db.opt to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/db.opt
  641. 180612 10:40:55 [01] ...done
  642. 180612 10:40:56 [01] Copying ./performance_schema/socket_instances.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/socket_instances.frm
  643. 180612 10:40:56 [01] ...done
  644. 180612 10:40:56 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_stages_summary_global_by_event_name.frm
  645. 180612 10:40:56 [01] ...done
  646. 180612 10:40:56 [01] Copying ./performance_schema/setup_timers.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/setup_timers.frm
  647. 180612 10:40:56 [01] ...done
  648. 180612 10:40:56 [01] Copying ./performance_schema/host_cache.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/host_cache.frm
  649. 180612 10:40:56 [01] ...done
  650. 180612 10:40:56 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_waits_summary_by_account_by_event_name.frm
  651. 180612 10:40:56 [01] ...done
  652. 180612 10:40:56 [01] Copying ./performance_schema/events_statements_history.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_history.frm
  653. 180612 10:40:56 [01] ...done
  654. 180612 10:40:56 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
  655. 180612 10:40:56 [01] ...done
  656. 180612 10:40:56 [01] Copying ./performance_schema/user_variables_by_thread.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/user_variables_by_thread.frm
  657. 180612 10:40:56 [01] ...done
  658. 180612 10:40:56 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/file_summary_by_event_name.frm
  659. 180612 10:40:56 [01] ...done
  660. 180612 10:40:56 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_summary_by_user_by_event_name.frm
  661. 180612 10:40:56 [01] ...done
  662. 180612 10:40:56 [01] Copying ./performance_schema/events_stages_history.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_stages_history.frm
  663. 180612 10:40:56 [01] ...done
  664. 180612 10:40:56 [01] Copying ./performance_schema/replication_applier_status.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/replication_applier_status.frm
  665. 180612 10:40:56 [01] ...done
  666. 180612 10:40:56 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_statements_summary_by_account_by_event_name.frm
  667. 180612 10:40:56 [01] ...done
  668. 180612 10:40:56 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/socket_summary_by_instance.frm
  669. 180612 10:40:56 [01] ...done
  670. 180612 10:40:56 [01] Copying ./performance_schema/status_by_user.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/status_by_user.frm
  671. 180612 10:40:56 [01] ...done
  672. 180612 10:40:56 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/memory_summary_by_user_by_event_name.frm
  673. 180612 10:40:56 [01] ...done
  674. 180612 10:40:56 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/events_waits_summary_by_host_by_event_name.frm
  675. 180612 10:40:56 [01] ...done
  676. 180612 10:40:56 [01] Copying ./performance_schema/replication_applier_configuration.frm to /backup/incr_backup/2018-06-12_10-40-49/performance_schema/replication_applier_configuration.frm
  677. 180612 10:40:56 [01] ...done
  678. 180612 10:40:56 Finished backing up non-InnoDB tables and files
  679. 180612 10:40:56 [00] Writing /backup/incr_backup/2018-06-12_10-40-49/xtrabackup_binlog_info
  680. 180612 10:40:56 [00] ...done
  681. 180612 10:40:56 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
  682. xtrabackup: The latest check point (for incremental): '1540210034'
  683. xtrabackup: Stopping log copying thread.
  684. .180612 10:40:56 >> log scanned up to (1540210043)

  685. 180612 10:40:56 Executing UNLOCK TABLES
  686. 180612 10:40:56 All tables unlocked
  687. 180612 10:40:56 [00] Copying ib_buffer_pool to /backup/incr_backup/2018-06-12_10-40-49/ib_buffer_pool
  688. 180612 10:40:56 [00] ...done
  689. 180612 10:40:56 Backup created in directory '/backup/incr_backup/2018-06-12_10-40-49/'
  690. MySQL binlog position: filename 'mysql-bin.000012', position '1952'
  691. 180612 10:40:56 [00] Writing /backup/incr_backup/2018-06-12_10-40-49/backup-my.cnf
  692. 180612 10:40:56 [00] ...done
  693. 180612 10:40:56 [00] Writing /backup/incr_backup/2018-06-12_10-40-49/xtrabackup_info
  694. 180612 10:40:56 [00] ...done
  695. xtrabackup: Transaction log of lsn (1540210034) to (1540210043) was copied.
  696. 180612 10:40:56 completed OK!
查看第一次增量备份信息:

点击(此处)折叠或打开

  1. [root@mysql5 2018-06-12_10-40-49]# cat xtrabackup_info
  2. uuid = 08769a08-6dea-11e8-9520-080027240aa4
  3. name =
  4. tool_name = innobackupex
  5. tool_command = --defaults-file=/etc/my.cnf --user=backup --password=... --port=3306 --incremental /backup/incr_backup/ --incremental-basedir=/backup/full_backup/2018-06-12_10-30-29/
  6. tool_version = 2.4.9
  7. ibbackup_version = 2.4.9
  8. server_version = 5.7.19-log
  9. start_time = 2018-06-12 10:40:49
  10. end_time = 2018-06-12 10:40:56
  11. lock_time = 0
  12. binlog_pos = filename 'mysql-bin.000012', position '1952'
  13. innodb_from_lsn = 1540210034
  14. innodb_to_lsn = 1540210034
  15. partial = N
  16. incremental = Y
  17. format = file
  18. compact = N
  19. compressed = N
  20. encrypted = N
6、向测试表插入数据

点击(此处)折叠或打开

  1. mysql> insert into test values(2,'0',40);
  2. Query OK, 1 row affected (0.02 sec)

  3. mysql> select * from test;
  4. +------+-----------+------+
  5. | id | user_type | code |
  6. +------+-----------+------+
  7. | 1 | 0 | 30 |
  8. | 2 | 0 | 40 |
  9. +------+-----------+------+
  10. 2 rows in set (0.00 sec)
7、以第一次增量备份作为基础,做第二次增量备份

点击(此处)折叠或打开

  1. [root@mysql5 bin]# ./innobackupex --defaults-file=/etc/my.cnf --user=backup --password=mysql --port=3306 --incremental /backup/incr_backup/ --incremental-basedir=/backup/incr_backup/2018-06-12_10-40-49/
  2. 180612 10:47:16 innobackupex: Starting the backup operation

  3. IMPORTANT: Please check that the backup run completes successfully.
  4.            At the end of a successful backup run innobackupex
  5.            prints "completed OK!".

  6. 180612 10:47:16 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/tmp/mysqld.sock' as 'backup' (using password: YES).
  7. 180612 10:47:16 version_check Connected to MySQL server
  8. 180612 10:47:16 version_check Executing a version check against the server...
  9. 180612 10:47:16 version_check Done.
  10. 180612 10:47:16 Connecting to MySQL server host: localhost, user: backup, password: set, port: 3306, socket: /tmp/mysqld.sock
  11. Using server version 5.7.19-log
  12. ./innobackupex version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4)
  13. incremental backup from 1540210034 is enabled.
  14. xtrabackup: uses posix_fadvise().
  15. xtrabackup: cd to /mysql/data
  16. xtrabackup: open files limit requested 65535, set to 65535
  17. xtrabackup: using the following InnoDB configuration:
  18. xtrabackup: innodb_data_home_dir = .
  19. xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
  20. xtrabackup: innodb_log_group_home_dir = ./
  21. xtrabackup: innodb_log_files_in_group = 2
  22. xtrabackup: innodb_log_file_size = 67108864
  23. xtrabackup: using O_DIRECT
  24. InnoDB: Number of pools: 1
  25. Warning: "test.test" uses engine "MEMORY" and will not be backed up.
  26. 180612 10:47:16 >> log scanned up to (1540210043)
  27. xtrabackup: Generating a list of tablespaces
  28. InnoDB: Allocated tablespace ID 64 for test/t_user_info, old maximum was 0
  29. 180612 10:47:16 [01] Copying ./ibdata1 to /backup/incr_backup/2018-06-12_10-47-16/ibdata1.delta
  30. 180612 10:47:16 [01] ...done
  31. 180612 10:47:16 [01] Copying ./test/t_user_info.ibd to /backup/incr_backup/2018-06-12_10-47-16/test/t_user_info.ibd.delta
  32. 180612 10:47:16 [01] ...done
  33. 180612 10:47:16 [01] Copying ./xcredit/tb_openapi.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_openapi.ibd.delta
  34. 180612 10:47:16 [01] ...done
  35. 180612 10:47:16 [01] Copying ./xcredit/tb_system_param.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_system_param.ibd.delta
  36. 180612 10:47:16 [01] ...done
  37. 180612 10:47:16 [01] Copying ./xcredit/tb_query_data_history.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_query_data_history.ibd.delta
  38. 180612 10:47:16 [01] ...done
  39. 180612 10:47:16 [01] Copying ./xcredit/tb_query_acquire_log.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_query_acquire_log.ibd.delta
  40. 180612 10:47:16 [01] ...done
  41. 180612 10:47:16 [01] Copying ./xcredit/tb_index.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_index.ibd.delta
  42. 180612 10:47:16 [01] ...done
  43. 180612 10:47:16 [01] Copying ./xcredit/tb_role_resource.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_role_resource.ibd.delta
  44. 180612 10:47:16 [01] ...done
  45. 180612 10:47:16 [01] Copying ./xcredit/tb_data_complaint.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_data_complaint.ibd.delta
  46. 180612 10:47:16 [01] ...done
  47. 180612 10:47:17 [01] Copying ./xcredit/tb_message.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_message.ibd.delta
  48. 180612 10:47:17 [01] ...done
  49. 180612 10:47:17 [01] Copying ./xcredit/tb_query_index_log.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_query_index_log.ibd.delta
  50. 180612 10:47:17 [01] ...done
  51. 180612 10:47:17 [01] Copying ./xcredit/tb_generic_data.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_generic_data.ibd.delta
  52. 180612 10:47:17 [01] ...done
  53. 180612 10:47:17 [01] Copying ./xcredit/tb_resource.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_resource.ibd.delta
  54. 180612 10:47:17 [01] ...done
  55. 180612 10:47:17 [01] Copying ./xcredit/tb_sync_job.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_sync_job.ibd.delta
  56. 180612 10:47:17 [01] ...done
  57. 180612 10:47:17 >> log scanned up to (1540210043)
  58. 180612 10:47:17 [01] Copying ./xcredit/tb_admin.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_admin.ibd.delta
  59. 180612 10:47:17 [01] ...done
  60. 180612 10:47:17 [01] Copying ./xcredit/tb_analyze_index.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_analyze_index.ibd.delta
  61. 180612 10:47:17 [01] ...done
  62. 180612 10:47:17 [01] Copying ./xcredit/tb_index_log.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_index_log.ibd.delta
  63. 180612 10:47:17 [01] ...done
  64. 180612 10:47:17 [01] Copying ./xcredit/tb_role.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_role.ibd.delta
  65. 180612 10:47:17 [01] ...done
  66. 180612 10:47:17 [01] Copying ./xcredit/tb_cert.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_cert.ibd.delta
  67. 180612 10:47:17 [01] ...done
  68. 180612 10:47:17 [01] Copying ./xcredit/tb_openapi_acquire_log.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_openapi_acquire_log.ibd.delta
  69. 180612 10:47:17 [01] ...done
  70. 180612 10:47:17 [01] Copying ./xcredit/tb_openapi_offer_log.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_openapi_offer_log.ibd.delta
  71. 180612 10:47:17 [01] ...done
  72. 180612 10:47:17 [01] Copying ./xcredit/tb_query_offer_log.ibd to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_query_offer_log.ibd.delta
  73. 180612 10:47:17 [01] ...done
  74. 180612 10:47:17 [01] Copying ./sys/sys_config.ibd to /backup/incr_backup/2018-06-12_10-47-16/sys/sys_config.ibd.delta
  75. 180612 10:47:17 [01] ...done
  76. 180612 10:47:17 [01] Copying ./mysql/help_topic.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/help_topic.ibd.delta
  77. 180612 10:47:17 [01] ...done
  78. 180612 10:47:17 [01] Copying ./mysql/slave_worker_info.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/slave_worker_info.ibd.delta
  79. 180612 10:47:17 [01] ...done
  80. 180612 10:47:17 [01] Copying ./mysql/time_zone.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone.ibd.delta
  81. 180612 10:47:17 [01] ...done
  82. 180612 10:47:17 [01] Copying ./mysql/slave_relay_log_info.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/slave_relay_log_info.ibd.delta
  83. 180612 10:47:17 [01] ...done
  84. 180612 10:47:18 [01] Copying ./mysql/help_relation.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/help_relation.ibd.delta
  85. 180612 10:47:18 [01] ...done
  86. 180612 10:47:18 [01] Copying ./mysql/help_keyword.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/help_keyword.ibd.delta
  87. 180612 10:47:18 [01] ...done
  88. 180612 10:47:18 [01] Copying ./mysql/help_category.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/help_category.ibd.delta
  89. 180612 10:47:18 [01] ...done
  90. 180612 10:47:18 [01] Copying ./mysql/server_cost.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/server_cost.ibd.delta
  91. 180612 10:47:18 [01] ...done
  92. 180612 10:47:18 [01] Copying ./mysql/innodb_index_stats.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/innodb_index_stats.ibd.delta
  93. 180612 10:47:18 [01] ...done
  94. 180612 10:47:18 [01] Copying ./mysql/time_zone_transition.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone_transition.ibd.delta
  95. 180612 10:47:18 [01] ...done
  96. 180612 10:47:18 >> log scanned up to (1540210043)
  97. 180612 10:47:18 [01] Copying ./mysql/user_bak.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/user_bak.ibd.delta
  98. 180612 10:47:18 [01] ...done
  99. 180612 10:47:18 [01] Copying ./mysql/time_zone_name.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone_name.ibd.delta
  100. 180612 10:47:18 [01] ...done
  101. 180612 10:47:18 [01] Copying ./mysql/gtid_executed.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/gtid_executed.ibd.delta
  102. 180612 10:47:18 [01] ...done
  103. 180612 10:47:18 [01] Copying ./mysql/slave_master_info.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/slave_master_info.ibd.delta
  104. 180612 10:47:18 [01] ...done
  105. 180612 10:47:18 [01] Copying ./mysql/time_zone_leap_second.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone_leap_second.ibd.delta
  106. 180612 10:47:18 [01] ...done
  107. 180612 10:47:18 [01] Copying ./mysql/servers.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/servers.ibd.delta
  108. 180612 10:47:18 [01] ...done
  109. 180612 10:47:18 [01] Copying ./mysql/time_zone_transition_type.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone_transition_type.ibd.delta
  110. 180612 10:47:18 [01] ...done
  111. 180612 10:47:18 [01] Copying ./mysql/plugin.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/plugin.ibd.delta
  112. 180612 10:47:18 [01] ...done
  113. 180612 10:47:18 [01] Copying ./mysql/innodb_table_stats.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/innodb_table_stats.ibd.delta
  114. 180612 10:47:18 [01] ...done
  115. 180612 10:47:18 [01] Copying ./mysql/engine_cost.ibd to /backup/incr_backup/2018-06-12_10-47-16/mysql/engine_cost.ibd.delta
  116. 180612 10:47:18 [01] ...done
  117. 180612 10:47:19 >> log scanned up to (1540210043)
  118. 180612 10:47:19 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
  119. 180612 10:47:19 Executing FLUSH TABLES WITH READ LOCK...
  120. 180612 10:47:19 Starting to backup non-InnoDB tables and files
  121. 180612 10:47:19 [01] Copying ./test/test.frm to /backup/incr_backup/2018-06-12_10-47-16/test/test.frm
  122. 180612 10:47:19 [01] ...done
  123. 180612 10:47:19 [01] Copying ./test/t_user_info.frm to /backup/incr_backup/2018-06-12_10-47-16/test/t_user_info.frm
  124. 180612 10:47:19 [01] ...done
  125. 180612 10:47:19 [01] Copying ./test/t_tou_info.frm to /backup/incr_backup/2018-06-12_10-47-16/test/t_tou_info.frm
  126. 180612 10:47:19 [01] ...done
  127. 180612 10:47:19 [01] Copying ./test/t_tou_info.MYI to /backup/incr_backup/2018-06-12_10-47-16/test/t_tou_info.MYI
  128. 180612 10:47:19 [01] ...done
  129. 180612 10:47:19 [01] Copying ./test/t_tou_info.MYD to /backup/incr_backup/2018-06-12_10-47-16/test/t_tou_info.MYD
  130. 180612 10:47:19 [01] ...done
  131. 180612 10:47:19 [01] Copying ./test/db.opt to /backup/incr_backup/2018-06-12_10-47-16/test/db.opt
  132. 180612 10:47:19 [01] ...done
  133. 180612 10:47:19 [01] Copying ./xcredit/tb_generic_data.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_generic_data.frm
  134. 180612 10:47:19 [01] ...done
  135. 180612 10:47:19 [01] Copying ./xcredit/tb_query_data_history.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_query_data_history.frm
  136. 180612 10:47:19 [01] ...done
  137. 180612 10:47:19 [01] Copying ./xcredit/tb_query_acquire_log.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_query_acquire_log.frm
  138. 180612 10:47:19 [01] ...done
  139. 180612 10:47:19 [01] Copying ./xcredit/tb_query_index_log.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_query_index_log.frm
  140. 180612 10:47:19 [01] ...done
  141. 180612 10:47:19 [01] Copying ./xcredit/tb_analyze_index.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_analyze_index.frm
  142. 180612 10:47:19 [01] ...done
  143. 180612 10:47:19 [01] Copying ./xcredit/tb_admin.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_admin.frm
  144. 180612 10:47:19 [01] ...done
  145. 180612 10:47:19 [01] Copying ./xcredit/tb_openapi_offer_log.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_openapi_offer_log.frm
  146. 180612 10:47:19 [01] ...done
  147. 180612 10:47:19 [01] Copying ./xcredit/tb_role.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_role.frm
  148. 180612 10:47:19 [01] ...done
  149. 180612 10:47:19 [01] Copying ./xcredit/tb_query_offer_log.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_query_offer_log.frm
  150. 180612 10:47:19 [01] ...done
  151. 180612 10:47:19 [01] Copying ./xcredit/tb_cert.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_cert.frm
  152. 180612 10:47:19 [01] ...done
  153. 180612 10:47:19 [01] Copying ./xcredit/tb_role_resource.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_role_resource.frm
  154. 180612 10:47:19 [01] ...done
  155. 180612 10:47:19 [01] Copying ./xcredit/tb_index.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_index.frm
  156. 180612 10:47:19 [01] ...done
  157. 180612 10:47:19 [01] Copying ./xcredit/tb_resource.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_resource.frm
  158. 180612 10:47:19 [01] ...done
  159. 180612 10:47:19 [01] Copying ./xcredit/tb_data_complaint.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_data_complaint.frm
  160. 180612 10:47:19 [01] ...done
  161. 180612 10:47:19 [01] Copying ./xcredit/tb_message.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_message.frm
  162. 180612 10:47:19 [01] ...done
  163. 180612 10:47:19 [01] Copying ./xcredit/tb_sync_job.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_sync_job.frm
  164. 180612 10:47:19 [01] ...done
  165. 180612 10:47:19 [01] Copying ./xcredit/tb_system_param.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_system_param.frm
  166. 180612 10:47:19 [01] ...done
  167. 180612 10:47:19 [01] Copying ./xcredit/tb_openapi_acquire_log.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_openapi_acquire_log.frm
  168. 180612 10:47:19 [01] ...done
  169. 180612 10:47:19 [01] Copying ./xcredit/db.opt to /backup/incr_backup/2018-06-12_10-47-16/xcredit/db.opt
  170. 180612 10:47:19 [01] ...done
  171. 180612 10:47:19 [01] Copying ./xcredit/tb_index_log.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_index_log.frm
  172. 180612 10:47:19 [01] ...done
  173. 180612 10:47:19 [01] Copying ./xcredit/tb_openapi.frm to /backup/incr_backup/2018-06-12_10-47-16/xcredit/tb_openapi.frm
  174. 180612 10:47:19 [01] ...done
  175. 180612 10:47:19 [01] Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024wait_classes_global_by_avg_latency.frm
  176. 180612 10:47:19 [01] ...done
  177. 180612 10:47:19 [01] Copying ./sys/io_global_by_wait_by_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/io_global_by_wait_by_bytes.frm
  178. 180612 10:47:19 [01] ...done
  179. 180612 10:47:19 [01] Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024memory_by_host_by_current_bytes.frm
  180. 180612 10:47:19 [01] ...done
  181. 180612 10:47:19 [01] Copying ./sys/user_summary.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/user_summary.frm
  182. 180612 10:47:19 [01] ...done
  183. 180612 10:47:19 [01] Copying ./sys/host_summary.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/host_summary.frm
  184. 180612 10:47:19 [01] ...done
  185. 180612 10:47:19 [01] Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
  186. 180612 10:47:19 [01] ...done
  187. 180612 10:47:19 [01] Copying ./sys/x@0024waits_by_host_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024waits_by_host_by_latency.frm
  188. 180612 10:47:19 [01] ...done
  189. 180612 10:47:19 [01] Copying ./sys/memory_global_total.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/memory_global_total.frm
  190. 180612 10:47:19 [01] ...done
  191. 180612 10:47:19 [01] Copying ./sys/memory_global_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/memory_global_by_current_bytes.frm
  192. 180612 10:47:19 [01] ...done
  193. 180612 10:47:19 [01] Copying ./sys/version.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/version.frm
  194. 180612 10:47:19 [01] ...done
  195. 180612 10:47:19 [01] Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024memory_by_thread_by_current_bytes.frm
  196. 180612 10:47:19 [01] ...done
  197. 180612 10:47:19 [01] Copying ./sys/schema_table_statistics_with_buffer.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/schema_table_statistics_with_buffer.frm
  198. 180612 10:47:19 [01] ...done
  199. 180612 10:47:19 [01] Copying ./sys/x@0024schema_table_lock_waits.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024schema_table_lock_waits.frm
  200. 180612 10:47:19 [01] ...done
  201. 180612 10:47:19 [01] Copying ./sys/statements_with_full_table_scans.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/statements_with_full_table_scans.frm
  202. 180612 10:47:19 [01] ...done
  203. 180612 10:47:19 [01] Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024innodb_buffer_stats_by_table.frm
  204. 180612 10:47:19 [01] ...done
  205. 180612 10:47:19 [01] Copying ./sys/memory_by_user_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/memory_by_user_by_current_bytes.frm
  206. 180612 10:47:19 [01] ...done
  207. 180612 10:47:19 [01] Copying ./sys/schema_redundant_indexes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/schema_redundant_indexes.frm
  208. 180612 10:47:19 [01] ...done
  209. 180612 10:47:19 [01] Copying ./sys/latest_file_io.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/latest_file_io.frm
  210. 180612 10:47:19 [01] ...done
  211. 180612 10:47:19 [01] Copying ./sys/statements_with_temp_tables.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/statements_with_temp_tables.frm
  212. 180612 10:47:19 [01] ...done
  213. 180612 10:47:19 [01] Copying ./sys/session.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/session.frm
  214. 180612 10:47:19 [01] ...done
  215. 180612 10:47:19 [01] Copying ./sys/io_global_by_file_by_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/io_global_by_file_by_bytes.frm
  216. 180612 10:47:19 [01] ...done
  217. 180612 10:47:19 [01] Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024schema_table_statistics_with_buffer.frm
  218. 180612 10:47:19 [01] ...done
  219. 180612 10:47:19 [01] Copying ./sys/x@0024io_by_thread_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024io_by_thread_by_latency.frm
  220. 180612 10:47:19 [01] ...done
  221. 180612 10:47:19 [01] Copying ./sys/sys_config.TRG to /backup/incr_backup/2018-06-12_10-47-16/sys/sys_config.TRG
  222. 180612 10:47:19 [01] ...done
  223. 180612 10:47:19 [01] Copying ./sys/x@0024memory_global_total.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024memory_global_total.frm
  224. 180612 10:47:19 [01] ...done
  225. 180612 10:47:19 [01] Copying ./sys/x@0024statement_analysis.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024statement_analysis.frm
  226. 180612 10:47:19 [01] ...done
  227. 180612 10:47:19 [01] Copying ./sys/innodb_buffer_stats_by_schema.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/innodb_buffer_stats_by_schema.frm
  228. 180612 10:47:19 [01] ...done
  229. 180612 10:47:19 [01] Copying ./sys/schema_unused_indexes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/schema_unused_indexes.frm
  230. 180612 10:47:19 [01] ...done
  231. 180612 10:47:20 [01] Copying ./sys/sys_config_update_set_user.TRN to /backup/incr_backup/2018-06-12_10-47-16/sys/sys_config_update_set_user.TRN
  232. 180612 10:47:20 [01] ...done
  233. 180612 10:47:20 [01] Copying ./sys/user_summary_by_statement_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/user_summary_by_statement_latency.frm
  234. 180612 10:47:20 [01] ...done
  235. 180612 10:47:20 [01] Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024ps_digest_avg_latency_distribution.frm
  236. 180612 10:47:20 [01] ...done
  237. 180612 10:47:20 [01] Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024io_global_by_wait_by_latency.frm
  238. 180612 10:47:20 [01] ...done
  239. 180612 10:47:20 [01] Copying ./sys/x@0024host_summary_by_stages.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024host_summary_by_stages.frm
  240. 180612 10:47:20 [01] ...done
  241. 180612 10:47:20 [01] Copying ./sys/x@0024user_summary_by_statement_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024user_summary_by_statement_latency.frm
  242. 180612 10:47:20 [01] ...done
  243. 180612 10:47:20 [01] Copying ./sys/statement_analysis.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/statement_analysis.frm
  244. 180612 10:47:20 [01] ...done
  245. 180612 10:47:20 [01] Copying ./sys/user_summary_by_file_io_type.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/user_summary_by_file_io_type.frm
  246. 180612 10:47:20 [01] ...done
  247. 180612 10:47:20 [01] Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/statements_with_runtimes_in_95th_percentile.frm
  248. 180612 10:47:20 [01] ...done
  249. 180612 10:47:20 [01] Copying ./sys/x@0024waits_by_user_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024waits_by_user_by_latency.frm
  250. 180612 10:47:20 [01] ...done
  251. 180612 10:47:20 [01] Copying ./sys/x@0024waits_global_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024waits_global_by_latency.frm
  252. 180612 10:47:20 [01] ...done
  253. 180612 10:47:20 [01] Copying ./sys/innodb_buffer_stats_by_table.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/innodb_buffer_stats_by_table.frm
  254. 180612 10:47:20 [01] ...done
  255. 180612 10:47:20 [01] Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024memory_by_user_by_current_bytes.frm
  256. 180612 10:47:20 [01] ...done
  257. 180612 10:47:20 [01] Copying ./sys/schema_tables_with_full_table_scans.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/schema_tables_with_full_table_scans.frm
  258. 180612 10:47:20 [01] ...done
  259. 180612 10:47:20 [01] Copying ./sys/waits_by_user_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/waits_by_user_by_latency.frm
  260. 180612 10:47:20 [01] ...done
  261. 180612 10:47:20 [01] Copying ./sys/x@0024session.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024session.frm
  262. 180612 10:47:20 [01] ...done
  263. 180612 10:47:20 [01] Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024statements_with_errors_or_warnings.frm
  264. 180612 10:47:20 [01] ...done
  265. 180612 10:47:20 [01] Copying ./sys/host_summary_by_statement_type.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/host_summary_by_statement_type.frm
  266. 180612 10:47:20 [01] ...done
  267. 180612 10:47:20 [01] Copying ./sys/x@0024user_summary_by_file_io.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024user_summary_by_file_io.frm
  268. 180612 10:47:20 [01] ...done
  269. 180612 10:47:20 [01] Copying ./sys/x@0024host_summary_by_file_io.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024host_summary_by_file_io.frm
  270. 180612 10:47:20 [01] ...done
  271. 180612 10:47:20 [01] Copying ./sys/host_summary_by_file_io_type.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/host_summary_by_file_io_type.frm
  272. 180612 10:47:20 [01] ...done
  273. 180612 10:47:20 [01] Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024schema_tables_with_full_table_scans.frm
  274. 180612 10:47:20 [01] ...done
  275. 180612 10:47:20 [01] Copying ./sys/memory_by_host_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/memory_by_host_by_current_bytes.frm
  276. 180612 10:47:20 [01] ...done
  277. 180612 10:47:20 [01] Copying ./sys/x@0024processlist.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024processlist.frm
  278. 180612 10:47:20 [01] ...done
  279. 180612 10:47:20 [01] Copying ./sys/user_summary_by_statement_type.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/user_summary_by_statement_type.frm
  280. 180612 10:47:20 [01] ...done
  281. 180612 10:47:20 [01] Copying ./sys/x@0024io_global_by_file_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024io_global_by_file_by_latency.frm
  282. 180612 10:47:20 [01] ...done
  283. 180612 10:47:20 [01] Copying ./sys/x@0024schema_index_statistics.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024schema_index_statistics.frm
  284. 180612 10:47:20 [01] ...done
  285. 180612 10:47:20 [01] Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
  286. 180612 10:47:20 [01] ...done
  287. 180612 10:47:20 [01] Copying ./sys/x@0024host_summary.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024host_summary.frm
  288. 180612 10:47:20 [01] ...done
  289. 180612 10:47:20 [01] Copying ./sys/host_summary_by_file_io.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/host_summary_by_file_io.frm
  290. 180612 10:47:20 [01] ...done
  291. 180612 10:47:20 [01] Copying ./sys/schema_table_statistics.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/schema_table_statistics.frm
  292. 180612 10:47:20 [01] ...done
  293. 180612 10:47:20 [01] Copying ./sys/innodb_lock_waits.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/innodb_lock_waits.frm
  294. 180612 10:47:20 [01] ...done
  295. 180612 10:47:20 [01] Copying ./sys/x@0024schema_table_statistics.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024schema_table_statistics.frm
  296. 180612 10:47:20 [01] ...done
  297. 180612 10:47:20 [01] Copying ./sys/host_summary_by_statement_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/host_summary_by_statement_latency.frm
  298. 180612 10:47:20 [01] ...done
  299. 180612 10:47:20 [01] Copying ./sys/x@0024statements_with_temp_tables.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024statements_with_temp_tables.frm
  300. 180612 10:47:20 [01] ...done
  301. 180612 10:47:20 [01] Copying ./sys/wait_classes_global_by_avg_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/wait_classes_global_by_avg_latency.frm
  302. 180612 10:47:20 [01] ...done
  303. 180612 10:47:20 >> log scanned up to (1540210043)
  304. 180612 10:47:20 [01] Copying ./sys/x@0024host_summary_by_statement_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024host_summary_by_statement_latency.frm
  305. 180612 10:47:20 [01] ...done
  306. 180612 10:47:20 [01] Copying ./sys/statements_with_errors_or_warnings.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/statements_with_errors_or_warnings.frm
  307. 180612 10:47:20 [01] ...done
  308. 180612 10:47:20 [01] Copying ./sys/waits_by_host_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/waits_by_host_by_latency.frm
  309. 180612 10:47:20 [01] ...done
  310. 180612 10:47:20 [01] Copying ./sys/schema_object_overview.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/schema_object_overview.frm
  311. 180612 10:47:20 [01] ...done
  312. 180612 10:47:20 [01] Copying ./sys/schema_table_lock_waits.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/schema_table_lock_waits.frm
  313. 180612 10:47:20 [01] ...done
  314. 180612 10:47:20 [01] Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024io_global_by_wait_by_bytes.frm
  315. 180612 10:47:20 [01] ...done
  316. 180612 10:47:20 [01] Copying ./sys/x@0024wait_classes_global_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024wait_classes_global_by_latency.frm
  317. 180612 10:47:20 [01] ...done
  318. 180612 10:47:20 [01] Copying ./sys/x@0024host_summary_by_file_io_type.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024host_summary_by_file_io_type.frm
  319. 180612 10:47:20 [01] ...done
  320. 180612 10:47:20 [01] Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024innodb_buffer_stats_by_schema.frm
  321. 180612 10:47:20 [01] ...done
  322. 180612 10:47:20 [01] Copying ./sys/waits_global_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/waits_global_by_latency.frm
  323. 180612 10:47:20 [01] ...done
  324. 180612 10:47:20 [01] Copying ./sys/sys_config_insert_set_user.TRN to /backup/incr_backup/2018-06-12_10-47-16/sys/sys_config_insert_set_user.TRN
  325. 180612 10:47:20 [01] ...done
  326. 180612 10:47:20 [01] Copying ./sys/schema_index_statistics.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/schema_index_statistics.frm
  327. 180612 10:47:20 [01] ...done
  328. 180612 10:47:20 [01] Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024ps_schema_table_statistics_io.frm
  329. 180612 10:47:20 [01] ...done
  330. 180612 10:47:20 [01] Copying ./sys/io_global_by_wait_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/io_global_by_wait_by_latency.frm
  331. 180612 10:47:20 [01] ...done
  332. 180612 10:47:20 [01] Copying ./sys/io_global_by_file_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/io_global_by_file_by_latency.frm
  333. 180612 10:47:20 [01] ...done
  334. 180612 10:47:20 [01] Copying ./sys/x@0024user_summary_by_file_io_type.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024user_summary_by_file_io_type.frm
  335. 180612 10:47:20 [01] ...done
  336. 180612 10:47:20 [01] Copying ./sys/host_summary_by_stages.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/host_summary_by_stages.frm
  337. 180612 10:47:20 [01] ...done
  338. 180612 10:47:20 [01] Copying ./sys/x@0024host_summary_by_statement_type.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024host_summary_by_statement_type.frm
  339. 180612 10:47:20 [01] ...done
  340. 180612 10:47:20 [01] Copying ./sys/x@0024statements_with_full_table_scans.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024statements_with_full_table_scans.frm
  341. 180612 10:47:20 [01] ...done
  342. 180612 10:47:20 [01] Copying ./sys/metrics.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/metrics.frm
  343. 180612 10:47:20 [01] ...done
  344. 180612 10:47:20 [01] Copying ./sys/wait_classes_global_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/wait_classes_global_by_latency.frm
  345. 180612 10:47:20 [01] ...done
  346. 180612 10:47:20 [01] Copying ./sys/x@0024statements_with_sorting.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024statements_with_sorting.frm
  347. 180612 10:47:20 [01] ...done
  348. 180612 10:47:20 [01] Copying ./sys/user_summary_by_stages.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/user_summary_by_stages.frm
  349. 180612 10:47:20 [01] ...done
  350. 180612 10:47:20 [01] Copying ./sys/sys_config.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/sys_config.frm
  351. 180612 10:47:20 [01] ...done
  352. 180612 10:47:20 [01] Copying ./sys/session_ssl_status.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/session_ssl_status.frm
  353. 180612 10:47:20 [01] ...done
  354. 180612 10:47:20 [01] Copying ./sys/statements_with_sorting.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/statements_with_sorting.frm
  355. 180612 10:47:20 [01] ...done
  356. 180612 10:47:20 [01] Copying ./sys/x@0024latest_file_io.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024latest_file_io.frm
  357. 180612 10:47:20 [01] ...done
  358. 180612 10:47:20 [01] Copying ./sys/db.opt to /backup/incr_backup/2018-06-12_10-47-16/sys/db.opt
  359. 180612 10:47:20 [01] ...done
  360. 180612 10:47:20 [01] Copying ./sys/x@0024user_summary_by_stages.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024user_summary_by_stages.frm
  361. 180612 10:47:20 [01] ...done
  362. 180612 10:47:20 [01] Copying ./sys/io_by_thread_by_latency.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/io_by_thread_by_latency.frm
  363. 180612 10:47:20 [01] ...done
  364. 180612 10:47:20 [01] Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024io_global_by_file_by_bytes.frm
  365. 180612 10:47:20 [01] ...done
  366. 180612 10:47:20 [01] Copying ./sys/x@0024innodb_lock_waits.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024innodb_lock_waits.frm
  367. 180612 10:47:20 [01] ...done
  368. 180612 10:47:20 [01] Copying ./sys/user_summary_by_file_io.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/user_summary_by_file_io.frm
  369. 180612 10:47:20 [01] ...done
  370. 180612 10:47:20 [01] Copying ./sys/processlist.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/processlist.frm
  371. 180612 10:47:20 [01] ...done
  372. 180612 10:47:20 [01] Copying ./sys/x@0024memory_global_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024memory_global_by_current_bytes.frm
  373. 180612 10:47:20 [01] ...done
  374. 180612 10:47:20 [01] Copying ./sys/ps_check_lost_instrumentation.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/ps_check_lost_instrumentation.frm
  375. 180612 10:47:20 [01] ...done
  376. 180612 10:47:20 [01] Copying ./sys/x@0024user_summary.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024user_summary.frm
  377. 180612 10:47:20 [01] ...done
  378. 180612 10:47:20 [01] Copying ./sys/x@0024schema_flattened_keys.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024schema_flattened_keys.frm
  379. 180612 10:47:20 [01] ...done
  380. 180612 10:47:20 [01] Copying ./sys/schema_auto_increment_columns.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/schema_auto_increment_columns.frm
  381. 180612 10:47:20 [01] ...done
  382. 180612 10:47:20 [01] Copying ./sys/x@0024user_summary_by_statement_type.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/x@0024user_summary_by_statement_type.frm
  383. 180612 10:47:20 [01] ...done
  384. 180612 10:47:20 [01] Copying ./sys/memory_by_thread_by_current_bytes.frm to /backup/incr_backup/2018-06-12_10-47-16/sys/memory_by_thread_by_current_bytes.frm
  385. 180612 10:47:20 [01] ...done
  386. 180612 10:47:20 [01] Copying ./mysql/tables_priv.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/tables_priv.frm
  387. 180612 10:47:20 [01] ...done
  388. 180612 10:47:20 [01] Copying ./mysql/proc.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/proc.MYD
  389. 180612 10:47:20 [01] ...done
  390. 180612 10:47:20 [01] Copying ./mysql/server_cost.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/server_cost.frm
  391. 180612 10:47:20 [01] ...done
  392. 180612 10:47:20 [01] Copying ./mysql/proxies_priv.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/proxies_priv.frm
  393. 180612 10:47:20 [01] ...done
  394. 180612 10:47:20 [01] Copying ./mysql/procs_priv.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/procs_priv.MYI
  395. 180612 10:47:20 [01] ...done
  396. 180612 10:47:20 [01] Copying ./mysql/event.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/event.MYI
  397. 180612 10:47:20 [01] ...done
  398. 180612 10:47:20 [01] Copying ./mysql/slave_worker_info.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/slave_worker_info.frm
  399. 180612 10:47:20 [01] ...done
  400. 180612 10:47:20 [01] Copying ./mysql/user_bak.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/user_bak.frm
  401. 180612 10:47:20 [01] ...done
  402. 180612 10:47:20 [01] Copying ./mysql/time_zone.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone.frm
  403. 180612 10:47:20 [01] ...done
  404. 180612 10:47:20 [01] Copying ./mysql/help_relation.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/help_relation.frm
  405. 180612 10:47:20 [01] ...done
  406. 180612 10:47:20 [01] Copying ./mysql/time_zone_transition_type.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone_transition_type.frm
  407. 180612 10:47:20 [01] ...done
  408. 180612 10:47:20 [01] Copying ./mysql/help_topic.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/help_topic.frm
  409. 180612 10:47:20 [01] ...done
  410. 180612 10:47:20 [01] Copying ./mysql/db.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/db.MYD
  411. 180612 10:47:20 [01] ...done
  412. 180612 10:47:20 [01] Copying ./mysql/slow_log.CSM to /backup/incr_backup/2018-06-12_10-47-16/mysql/slow_log.CSM
  413. 180612 10:47:20 [01] ...done
  414. 180612 10:47:20 [01] Copying ./mysql/slow_log.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/slow_log.frm
  415. 180612 10:47:20 [01] ...done
  416. 180612 10:47:20 [01] Copying ./mysql/general_log.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/general_log.frm
  417. 180612 10:47:20 [01] ...done
  418. 180612 10:47:20 [01] Copying ./mysql/slave_relay_log_info.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/slave_relay_log_info.frm
  419. 180612 10:47:20 [01] ...done
  420. 180612 10:47:20 [01] Copying ./mysql/tables_priv.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/tables_priv.MYI
  421. 180612 10:47:20 [01] ...done
  422. 180612 10:47:20 [01] Copying ./mysql/ndb_binlog_index.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/ndb_binlog_index.MYD
  423. 180612 10:47:20 [01] ...done
  424. 180612 10:47:20 [01] Copying ./mysql/slave_master_info.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/slave_master_info.frm
  425. 180612 10:47:20 [01] ...done
  426. 180612 10:47:21 [01] Copying ./mysql/func.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/func.frm
  427. 180612 10:47:21 [01] ...done
  428. 180612 10:47:21 [01] Copying ./mysql/proc.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/proc.frm
  429. 180612 10:47:21 [01] ...done
  430. 180612 10:47:21 [01] Copying ./mysql/time_zone_name.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone_name.frm
  431. 180612 10:47:21 [01] ...done
  432. 180612 10:47:21 [01] Copying ./mysql/func.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/func.MYD
  433. 180612 10:47:21 [01] ...done
  434. 180612 10:47:21 [01] Copying ./mysql/procs_priv.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/procs_priv.frm
  435. 180612 10:47:21 [01] ...done
  436. 180612 10:47:21 [01] Copying ./mysql/tables_priv.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/tables_priv.MYD
  437. 180612 10:47:21 [01] ...done
  438. 180612 10:47:21 [01] Copying ./mysql/columns_priv.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/columns_priv.MYI
  439. 180612 10:47:21 [01] ...done
  440. 180612 10:47:21 [01] Copying ./mysql/general_log.CSM to /backup/incr_backup/2018-06-12_10-47-16/mysql/general_log.CSM
  441. 180612 10:47:21 [01] ...done
  442. 180612 10:47:21 [01] Copying ./mysql/ndb_binlog_index.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/ndb_binlog_index.frm
  443. 180612 10:47:21 [01] ...done
  444. 180612 10:47:21 [01] Copying ./mysql/gtid_executed.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/gtid_executed.frm
  445. 180612 10:47:21 [01] ...done
  446. 180612 10:47:21 [01] Copying ./mysql/procs_priv.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/procs_priv.MYD
  447. 180612 10:47:21 [01] ...done
  448. 180612 10:47:21 [01] Copying ./mysql/func.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/func.MYI
  449. 180612 10:47:21 [01] ...done
  450. 180612 10:47:21 [01] Copying ./mysql/help_keyword.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/help_keyword.frm
  451. 180612 10:47:21 [01] ...done
  452. 180612 10:47:21 [01] Copying ./mysql/columns_priv.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/columns_priv.frm
  453. 180612 10:47:21 [01] ...done
  454. 180612 10:47:21 [01] Copying ./mysql/proxies_priv.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/proxies_priv.MYI
  455. 180612 10:47:21 [01] ...done
  456. 180612 10:47:21 [01] Copying ./mysql/proc.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/proc.MYI
  457. 180612 10:47:21 [01] ...done
  458. 180612 10:47:21 [01] Copying ./mysql/time_zone_transition.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone_transition.frm
  459. 180612 10:47:21 [01] ...done
  460. 180612 10:47:21 [01] Copying ./mysql/time_zone_leap_second.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/time_zone_leap_second.frm
  461. 180612 10:47:21 [01] ...done
  462. 180612 10:47:21 [01] Copying ./mysql/general_log.CSV to /backup/incr_backup/2018-06-12_10-47-16/mysql/general_log.CSV
  463. 180612 10:47:21 [01] ...done
  464. 180612 10:47:21 [01] Copying ./mysql/servers.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/servers.frm
  465. 180612 10:47:21 [01] ...done
  466. 180612 10:47:21 [01] Copying ./mysql/help_category.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/help_category.frm
  467. 180612 10:47:21 [01] ...done
  468. 180612 10:47:21 >> log scanned up to (1540210043)
  469. 180612 10:47:21 [01] Copying ./mysql/proxies_priv.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/proxies_priv.MYD
  470. 180612 10:47:21 [01] ...done
  471. 180612 10:47:21 [01] Copying ./mysql/event.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/event.MYD
  472. 180612 10:47:21 [01] ...done
  473. 180612 10:47:21 [01] Copying ./mysql/engine_cost.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/engine_cost.frm
  474. 180612 10:47:21 [01] ...done
  475. 180612 10:47:21 [01] Copying ./mysql/user.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/user.frm
  476. 180612 10:47:21 [01] ...done
  477. 180612 10:47:21 [01] Copying ./mysql/ndb_binlog_index.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/ndb_binlog_index.MYI
  478. 180612 10:47:21 [01] ...done
  479. 180612 10:47:21 [01] Copying ./mysql/db.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/db.frm
  480. 180612 10:47:21 [01] ...done
  481. 180612 10:47:21 [01] Copying ./mysql/plugin.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/plugin.frm
  482. 180612 10:47:21 [01] ...done
  483. 180612 10:47:21 [01] Copying ./mysql/db.opt to /backup/incr_backup/2018-06-12_10-47-16/mysql/db.opt
  484. 180612 10:47:21 [01] ...done
  485. 180612 10:47:21 [01] Copying ./mysql/user.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/user.MYI
  486. 180612 10:47:21 [01] ...done
  487. 180612 10:47:21 [01] Copying ./mysql/columns_priv.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/columns_priv.MYD
  488. 180612 10:47:21 [01] ...done
  489. 180612 10:47:21 [01] Copying ./mysql/innodb_table_stats.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/innodb_table_stats.frm
  490. 180612 10:47:21 [01] ...done
  491. 180612 10:47:21 [01] Copying ./mysql/innodb_index_stats.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/innodb_index_stats.frm
  492. 180612 10:47:21 [01] ...done
  493. 180612 10:47:21 [01] Copying ./mysql/event.frm to /backup/incr_backup/2018-06-12_10-47-16/mysql/event.frm
  494. 180612 10:47:21 [01] ...done
  495. 180612 10:47:21 [01] Copying ./mysql/slow_log.CSV to /backup/incr_backup/2018-06-12_10-47-16/mysql/slow_log.CSV
  496. 180612 10:47:21 [01] ...done
  497. 180612 10:47:21 [01] Copying ./mysql/db.MYI to /backup/incr_backup/2018-06-12_10-47-16/mysql/db.MYI
  498. 180612 10:47:21 [01] ...done
  499. 180612 10:47:21 [01] Copying ./mysql/user.MYD to /backup/incr_backup/2018-06-12_10-47-16/mysql/user.MYD
  500. 180612 10:47:21 [01] ...done
  501. 180612 10:47:21 [01] Copying ./performance_schema/events_transactions_history.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_transactions_history.frm
  502. 180612 10:47:21 [01] ...done
  503. 180612 10:47:21 [01] Copying ./performance_schema/events_waits_history.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_waits_history.frm
  504. 180612 10:47:21 [01] ...done
  505. 180612 10:47:21 [01] Copying ./performance_schema/events_statements_summary_by_digest.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_summary_by_digest.frm
  506. 180612 10:47:21 [01] ...done
  507. 180612 10:47:21 [01] Copying ./performance_schema/hosts.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/hosts.frm
  508. 180612 10:47:21 [01] ...done
  509. 180612 10:47:21 [01] Copying ./performance_schema/prepared_statements_instances.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/prepared_statements_instances.frm
  510. 180612 10:47:21 [01] ...done
  511. 180612 10:47:21 [01] Copying ./performance_schema/rwlock_instances.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/rwlock_instances.frm
  512. 180612 10:47:21 [01] ...done
  513. 180612 10:47:21 [01] Copying ./performance_schema/threads.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/threads.frm
  514. 180612 10:47:21 [01] ...done
  515. 180612 10:47:21 [01] Copying ./performance_schema/setup_objects.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/setup_objects.frm
  516. 180612 10:47:21 [01] ...done
  517. 180612 10:47:21 [01] Copying ./performance_schema/objects_summary_global_by_type.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/objects_summary_global_by_type.frm
  518. 180612 10:47:21 [01] ...done
  519. 180612 10:47:21 [01] Copying ./performance_schema/replication_connection_status.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/replication_connection_status.frm
  520. 180612 10:47:21 [01] ...done
  521. 180612 10:47:21 [01] Copying ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_summary_by_thread_by_event_name.frm
  522. 180612 10:47:21 [01] ...done
  523. 180612 10:47:21 [01] Copying ./performance_schema/memory_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/memory_summary_by_host_by_event_name.frm
  524. 180612 10:47:21 [01] ...done
  525. 180612 10:47:21 [01] Copying ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_summary_by_host_by_event_name.frm
  526. 180612 10:47:21 [01] ...done
  527. 180612 10:47:21 [01] Copying ./performance_schema/session_variables.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/session_variables.frm
  528. 180612 10:47:21 [01] ...done
  529. 180612 10:47:21 [01] Copying ./performance_schema/replication_group_member_stats.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/replication_group_member_stats.frm
  530. 180612 10:47:21 [01] ...done
  531. 180612 10:47:21 [01] Copying ./performance_schema/setup_actors.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/setup_actors.frm
  532. 180612 10:47:21 [01] ...done
  533. 180612 10:47:21 [01] Copying ./performance_schema/memory_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/memory_summary_by_account_by_event_name.frm
  534. 180612 10:47:21 [01] ...done
  535. 180612 10:47:21 [01] Copying ./performance_schema/events_transactions_history_long.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_transactions_history_long.frm
  536. 180612 10:47:21 [01] ...done
  537. 180612 10:47:21 [01] Copying ./performance_schema/users.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/users.frm
  538. 180612 10:47:21 [01] ...done
  539. 180612 10:47:21 [01] Copying ./performance_schema/setup_consumers.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/setup_consumers.frm
  540. 180612 10:47:21 [01] ...done
  541. 180612 10:47:21 [01] Copying ./performance_schema/events_stages_history_long.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_stages_history_long.frm
  542. 180612 10:47:21 [01] ...done
  543. 180612 10:47:21 [01] Copying ./performance_schema/events_waits_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_waits_summary_global_by_event_name.frm
  544. 180612 10:47:21 [01] ...done
  545. 180612 10:47:21 [01] Copying ./performance_schema/events_statements_summary_by_program.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_summary_by_program.frm
  546. 180612 10:47:21 [01] ...done
  547. 180612 10:47:21 [01] Copying ./performance_schema/file_instances.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/file_instances.frm
  548. 180612 10:47:21 [01] ...done
  549. 180612 10:47:21 [01] Copying ./performance_schema/table_handles.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/table_handles.frm
  550. 180612 10:47:21 [01] ...done
  551. 180612 10:47:21 [01] Copying ./performance_schema/variables_by_thread.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/variables_by_thread.frm
  552. 180612 10:47:21 [01] ...done
  553. 180612 10:47:21 [01] Copying ./performance_schema/memory_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/memory_summary_global_by_event_name.frm
  554. 180612 10:47:21 [01] ...done
  555. 180612 10:47:21 [01] Copying ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_transactions_summary_by_user_by_event_name.frm
  556. 180612 10:47:21 [01] ...done
  557. 180612 10:47:22 [01] Copying ./performance_schema/table_io_waits_summary_by_index_usage.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/table_io_waits_summary_by_index_usage.frm
  558. 180612 10:47:22 [01] ...done
  559. 180612 10:47:22 [01] Copying ./performance_schema/events_transactions_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_transactions_summary_global_by_event_name.frm
  560. 180612 10:47:22 [01] ...done
  561. 180612 10:47:22 [01] Copying ./performance_schema/status_by_host.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/status_by_host.frm
  562. 180612 10:47:22 [01] ...done
  563. 180612 10:47:22 [01] Copying ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_waits_summary_by_thread_by_event_name.frm
  564. 180612 10:47:22 [01] ...done
  565. 180612 10:47:22 [01] Copying ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_stages_summary_by_account_by_event_name.frm
  566. 180612 10:47:22 [01] ...done
  567. 180612 10:47:22 [01] Copying ./performance_schema/session_connect_attrs.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/session_connect_attrs.frm
  568. 180612 10:47:22 [01] ...done
  569. 180612 10:47:22 [01] Copying ./performance_schema/status_by_account.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/status_by_account.frm
  570. 180612 10:47:22 [01] ...done
  571. 180612 10:47:22 [01] Copying ./performance_schema/metadata_locks.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/metadata_locks.frm
  572. 180612 10:47:22 [01] ...done
  573. 180612 10:47:22 [01] Copying ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_transactions_summary_by_host_by_event_name.frm
  574. 180612 10:47:22 [01] ...done
  575. 180612 10:47:22 [01] Copying ./performance_schema/events_statements_history_long.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_history_long.frm
  576. 180612 10:47:22 [01] ...done
  577. 180612 10:47:22 [01] Copying ./performance_schema/global_variables.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/global_variables.frm
  578. 180612 10:47:22 [01] ...done
  579. 180612 10:47:22 [01] Copying ./performance_schema/table_lock_waits_summary_by_table.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/table_lock_waits_summary_by_table.frm
  580. 180612 10:47:22 [01] ...done
  581. 180612 10:47:22 [01] Copying ./performance_schema/mutex_instances.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/mutex_instances.frm
  582. 180612 10:47:22 [01] ...done
  583. 180612 10:47:22 [01] Copying ./performance_schema/session_status.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/session_status.frm
  584. 180612 10:47:22 [01] ...done
  585. 180612 10:47:22 [01] Copying ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_transactions_summary_by_account_by_event_name.frm
  586. 180612 10:47:22 [01] ...done
  587. 180612 10:47:22 [01] Copying ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_stages_summary_by_user_by_event_name.frm
  588. 180612 10:47:22 [01] ...done
  589. 180612 10:47:22 [01] Copying ./performance_schema/table_io_waits_summary_by_table.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/table_io_waits_summary_by_table.frm
  590. 180612 10:47:22 [01] ...done
  591. 180612 10:47:22 [01] Copying ./performance_schema/events_statements_current.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_current.frm
  592. 180612 10:47:22 [01] ...done
  593. 180612 10:47:22 >> log scanned up to (1540210043)
  594. 180612 10:47:22 [01] Copying ./performance_schema/events_stages_current.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_stages_current.frm
  595. 180612 10:47:22 [01] ...done
  596. 180612 10:47:22 [01] Copying ./performance_schema/replication_connection_configuration.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/replication_connection_configuration.frm
  597. 180612 10:47:22 [01] ...done
  598. 180612 10:47:22 [01] Copying ./performance_schema/memory_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/memory_summary_by_thread_by_event_name.frm
  599. 180612 10:47:22 [01] ...done
  600. 180612 10:47:22 [01] Copying ./performance_schema/status_by_thread.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/status_by_thread.frm
  601. 180612 10:47:22 [01] ...done
  602. 180612 10:47:22 [01] Copying ./performance_schema/replication_applier_status_by_worker.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/replication_applier_status_by_worker.frm
  603. 180612 10:47:22 [01] ...done
  604. 180612 10:47:22 [01] Copying ./performance_schema/cond_instances.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/cond_instances.frm
  605. 180612 10:47:22 [01] ...done
  606. 180612 10:47:22 [01] Copying ./performance_schema/performance_timers.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/performance_timers.frm
  607. 180612 10:47:22 [01] ...done
  608. 180612 10:47:22 [01] Copying ./performance_schema/events_statements_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_summary_global_by_event_name.frm
  609. 180612 10:47:22 [01] ...done
  610. 180612 10:47:22 [01] Copying ./performance_schema/accounts.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/accounts.frm
  611. 180612 10:47:22 [01] ...done
  612. 180612 10:47:22 [01] Copying ./performance_schema/session_account_connect_attrs.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/session_account_connect_attrs.frm
  613. 180612 10:47:22 [01] ...done
  614. 180612 10:47:22 [01] Copying ./performance_schema/events_waits_summary_by_instance.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_waits_summary_by_instance.frm
  615. 180612 10:47:22 [01] ...done
  616. 180612 10:47:22 [01] Copying ./performance_schema/setup_instruments.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/setup_instruments.frm
  617. 180612 10:47:22 [01] ...done
  618. 180612 10:47:22 [01] Copying ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_waits_summary_by_user_by_event_name.frm
  619. 180612 10:47:22 [01] ...done
  620. 180612 10:47:22 [01] Copying ./performance_schema/events_waits_current.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_waits_current.frm
  621. 180612 10:47:22 [01] ...done
  622. 180612 10:47:22 [01] Copying ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_stages_summary_by_thread_by_event_name.frm
  623. 180612 10:47:22 [01] ...done
  624. 180612 10:47:22 [01] Copying ./performance_schema/events_waits_history_long.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_waits_history_long.frm
  625. 180612 10:47:22 [01] ...done
  626. 180612 10:47:22 [01] Copying ./performance_schema/global_status.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/global_status.frm
  627. 180612 10:47:22 [01] ...done
  628. 180612 10:47:22 [01] Copying ./performance_schema/replication_group_members.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/replication_group_members.frm
  629. 180612 10:47:22 [01] ...done
  630. 180612 10:47:22 [01] Copying ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_stages_summary_by_host_by_event_name.frm
  631. 180612 10:47:22 [01] ...done
  632. 180612 10:47:22 [01] Copying ./performance_schema/replication_applier_status_by_coordinator.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/replication_applier_status_by_coordinator.frm
  633. 180612 10:47:22 [01] ...done
  634. 180612 10:47:22 [01] Copying ./performance_schema/file_summary_by_instance.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/file_summary_by_instance.frm
  635. 180612 10:47:22 [01] ...done
  636. 180612 10:47:22 [01] Copying ./performance_schema/events_transactions_current.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_transactions_current.frm
  637. 180612 10:47:22 [01] ...done
  638. 180612 10:47:22 [01] Copying ./performance_schema/socket_summary_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/socket_summary_by_event_name.frm
  639. 180612 10:47:22 [01] ...done
  640. 180612 10:47:22 [01] Copying ./performance_schema/db.opt to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/db.opt
  641. 180612 10:47:22 [01] ...done
  642. 180612 10:47:22 [01] Copying ./performance_schema/socket_instances.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/socket_instances.frm
  643. 180612 10:47:22 [01] ...done
  644. 180612 10:47:22 [01] Copying ./performance_schema/events_stages_summary_global_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_stages_summary_global_by_event_name.frm
  645. 180612 10:47:22 [01] ...done
  646. 180612 10:47:22 [01] Copying ./performance_schema/setup_timers.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/setup_timers.frm
  647. 180612 10:47:22 [01] ...done
  648. 180612 10:47:22 [01] Copying ./performance_schema/host_cache.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/host_cache.frm
  649. 180612 10:47:22 [01] ...done
  650. 180612 10:47:22 [01] Copying ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_waits_summary_by_account_by_event_name.frm
  651. 180612 10:47:22 [01] ...done
  652. 180612 10:47:22 [01] Copying ./performance_schema/events_statements_history.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_history.frm
  653. 180612 10:47:22 [01] ...done
  654. 180612 10:47:22 [01] Copying ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
  655. 180612 10:47:22 [01] ...done
  656. 180612 10:47:22 [01] Copying ./performance_schema/user_variables_by_thread.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/user_variables_by_thread.frm
  657. 180612 10:47:22 [01] ...done
  658. 180612 10:47:22 [01] Copying ./performance_schema/file_summary_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/file_summary_by_event_name.frm
  659. 180612 10:47:22 [01] ...done
  660. 180612 10:47:22 [01] Copying ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_summary_by_user_by_event_name.frm
  661. 180612 10:47:22 [01] ...done
  662. 180612 10:47:22 [01] Copying ./performance_schema/events_stages_history.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_stages_history.frm
  663. 180612 10:47:22 [01] ...done
  664. 180612 10:47:22 [01] Copying ./performance_schema/replication_applier_status.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/replication_applier_status.frm
  665. 180612 10:47:22 [01] ...done
  666. 180612 10:47:23 [01] Copying ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_statements_summary_by_account_by_event_name.frm
  667. 180612 10:47:23 [01] ...done
  668. 180612 10:47:23 [01] Copying ./performance_schema/socket_summary_by_instance.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/socket_summary_by_instance.frm
  669. 180612 10:47:23 [01] ...done
  670. 180612 10:47:23 [01] Copying ./performance_schema/status_by_user.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/status_by_user.frm
  671. 180612 10:47:23 [01] ...done
  672. 180612 10:47:23 [01] Copying ./performance_schema/memory_summary_by_user_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/memory_summary_by_user_by_event_name.frm
  673. 180612 10:47:23 [01] ...done
  674. 180612 10:47:23 [01] Copying ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/events_waits_summary_by_host_by_event_name.frm
  675. 180612 10:47:23 [01] ...done
  676. 180612 10:47:23 [01] Copying ./performance_schema/replication_applier_configuration.frm to /backup/incr_backup/2018-06-12_10-47-16/performance_schema/replication_applier_configuration.frm
  677. 180612 10:47:23 [01] ...done
  678. 180612 10:47:23 Finished backing up non-InnoDB tables and files
  679. 180612 10:47:23 [00] Writing /backup/incr_backup/2018-06-12_10-47-16/xtrabackup_binlog_info
  680. 180612 10:47:23 [00] ...done
  681. 180612 10:47:23 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
  682. xtrabackup: The latest check point (for incremental): '1540210034'
  683. xtrabackup: Stopping log copying thread.
  684. .180612 10:47:23 >> log scanned up to (1540210043)

  685. 180612 10:47:23 Executing UNLOCK TABLES
  686. 180612 10:47:23 All tables unlocked
  687. 180612 10:47:23 [00] Copying ib_buffer_pool to /backup/incr_backup/2018-06-12_10-47-16/ib_buffer_pool
  688. 180612 10:47:23 [00] ...done
  689. 180612 10:47:23 Backup created in directory '/backup/incr_backup/2018-06-12_10-47-16/'
  690. MySQL binlog position: filename 'mysql-bin.000012', position '2259'
  691. 180612 10:47:23 [00] Writing /backup/incr_backup/2018-06-12_10-47-16/backup-my.cnf
  692. 180612 10:47:23 [00] ...done
  693. 180612 10:47:23 [00] Writing /backup/incr_backup/2018-06-12_10-47-16/xtrabackup_info
  694. 180612 10:47:23 [00] ...done
  695. xtrabackup: Transaction log of lsn (1540210034) to (1540210043) was copied.
  696. 180612 10:47:23 completed OK!
查看第二次增量备份信息:

点击(此处)折叠或打开

  1. [root@mysql5 2018-06-12_10-47-16]# cat xtrabackup_info
  2. uuid = eefb0a37-6dea-11e8-9520-080027240aa4
  3. name =
  4. tool_name = innobackupex
  5. tool_command = --defaults-file=/etc/my.cnf --user=backup --password=... --port=3306 --incremental /backup/incr_backup/ --incremental-basedir=/backup/incr_backup/2018-06-12_10-40-49/
  6. tool_version = 2.4.9
  7. ibbackup_version = 2.4.9
  8. server_version = 5.7.19-log
  9. start_time = 2018-06-12 10:47:16
  10. end_time = 2018-06-12 10:47:23
  11. lock_time = 0
  12. binlog_pos = filename 'mysql-bin.000012', position '2259'
  13. innodb_from_lsn = 1540210034
  14. innodb_to_lsn = 1540210034
  15. partial = N
  16. incremental = Y
  17. format = file
  18. compact = N
  19. compressed = N
  20. encrypted = N
8、再次向测试表插入数据

点击(此处)折叠或打开

  1. mysql> insert into test values(3,'0',50);
  2. Query OK, 1 row affected (0.02 sec)

  3. mysql> select * from test;
  4. +------+-----------+------+
  5. | id | user_type | code |
  6. +------+-----------+------+
  7. | 1 | 0 | 30 |
  8. | 2 | 0 | 40 |
  9. | 3 | 0 | 50 |
  10. +------+-----------+------+
9、现在模式故障,删除data目录下所有文件
10、恢复前kill掉mysql进程
11、恢复基础备份(这里一定要加--redo-only参数,该参数的意思是只应用xrabackup日志中已经提交的事务数据,不回滚还未提交的数据。)

点击(此处)折叠或打开

  1. [root@mysql5 bin]# ./innobackupex --apply-log --redo-only /backup/full_backup/2018-06-12_10-30-29/
  2. 180612 11:01:18 innobackupex: Starting the apply-log operation

  3. IMPORTANT: Please check that the apply-log run completes successfully.
  4.            At the end of a successful apply-log run innobackupex
  5.            prints "completed OK!".

  6. ./innobackupex version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4)
  7. xtrabackup: cd to /backup/full_backup/2018-06-12_10-30-29/
  8. xtrabackup: This target seems to be not prepared yet.
  9. InnoDB: Number of pools: 1
  10. xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1540210034)
  11. xtrabackup: using the following InnoDB configuration for recovery:
  12. xtrabackup: innodb_data_home_dir = .
  13. xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
  14. xtrabackup: innodb_log_group_home_dir = .
  15. xtrabackup: innodb_log_files_in_group = 1
  16. xtrabackup: innodb_log_file_size = 8388608
  17. xtrabackup: using the following InnoDB configuration for recovery:
  18. xtrabackup: innodb_data_home_dir = .
  19. xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
  20. xtrabackup: innodb_log_group_home_dir = .
  21. xtrabackup: innodb_log_files_in_group = 1
  22. xtrabackup: innodb_log_file_size = 8388608
  23. xtrabackup: Starting InnoDB instance for recovery.
  24. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
  25. InnoDB: PUNCH HOLE support available
  26. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  27. InnoDB: Uses event mutexes
  28. InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
  29. InnoDB: Compressed tables use zlib 1.2.3
  30. InnoDB: Number of pools: 1
  31. InnoDB: Using CPU crc32 instructions
  32. InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
  33. InnoDB: Completed initialization of buffer pool
  34. InnoDB: page_cleaner coordinator priority: -20
  35. InnoDB: Highest supported file format is Barracuda.
  36. InnoDB: Log scan progressed past the checkpoint lsn 1540210034
  37. InnoDB: Doing recovery: scanned up to log sequence number 1540210043 (0%)
  38. InnoDB: Doing recovery: scanned up to log sequence number 1540210043 (0%)
  39. InnoDB: Database was not shutdown normally!
  40. InnoDB: Starting crash recovery.
  41. InnoDB: xtrabackup: Last MySQL binlog file position 3349, file name mysql-bin.000001
  42. InnoDB: xtrabackup: Last MySQL binlog file position 3349, file name mysql-bin.000001

  43. xtrabackup: starting shutdown with innodb_fast_shutdown = 1
  44. InnoDB: Starting shutdown...
  45. InnoDB: Shutdown completed; log sequence number 1540210052
  46. InnoDB: Number of pools: 1
  47. 180612 11:01:20 completed OK!
12、将第一次增量备份恢复到全备:

点击(此处)折叠或打开

  1. [root@mysql5 bin]# ./innobackupex --apply-log --redo-only /backup/full_backup/2018-06-12_10-30-29/ --incremental-dir=/backup/incr_backup/2018-06-12_10-40-49/
  2. 180612 11:04:06 innobackupex: Starting the apply-log operation

  3. IMPORTANT: Please check that the apply-log run completes successfully.
  4.            At the end of a successful apply-log run innobackupex
  5.            prints "completed OK!".

  6. ./innobackupex version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4)
  7. incremental backup from 1540210034 is enabled.
  8. xtrabackup: cd to /backup/full_backup/2018-06-12_10-30-29/
  9. xtrabackup: This target seems to be already prepared with --apply-log-only.
  10. InnoDB: Number of pools: 1
  11. xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(1540210034)
  12. xtrabackup: using the following InnoDB configuration for recovery:
  13. xtrabackup: innodb_data_home_dir = .
  14. xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
  15. xtrabackup: innodb_log_group_home_dir = /backup/incr_backup/2018-06-12_10-40-49/
  16. xtrabackup: innodb_log_files_in_group = 1
  17. xtrabackup: innodb_log_file_size = 8388608
  18. xtrabackup: Generating a list of tablespaces
  19. InnoDB: Allocated tablespace ID 64 for test/t_user_info, old maximum was 0
  20. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//ibdata1.delta is 16384 bytes
  21. Applying /backup/incr_backup/2018-06-12_10-40-49//ibdata1.delta to ./ibdata1...
  22. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//test/t_user_info.ibd.delta is 16384 bytes
  23. Applying /backup/incr_backup/2018-06-12_10-40-49//test/t_user_info.ibd.delta to ./test/t_user_info.ibd...
  24. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_generic_data.ibd.delta is 16384 bytes
  25. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_generic_data.ibd.delta to ./xcredit/tb_generic_data.ibd...
  26. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_resource.ibd.delta is 16384 bytes
  27. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_resource.ibd.delta to ./xcredit/tb_resource.ibd...
  28. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_index.ibd.delta is 16384 bytes
  29. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_index.ibd.delta to ./xcredit/tb_index.ibd...
  30. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_role.ibd.delta is 16384 bytes
  31. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_role.ibd.delta to ./xcredit/tb_role.ibd...
  32. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_openapi_offer_log.ibd.delta is 16384 bytes
  33. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_openapi_offer_log.ibd.delta to ./xcredit/tb_openapi_offer_log.ibd...
  34. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_query_acquire_log.ibd.delta is 16384 bytes
  35. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_query_acquire_log.ibd.delta to ./xcredit/tb_query_acquire_log.ibd...
  36. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_cert.ibd.delta is 16384 bytes
  37. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_cert.ibd.delta to ./xcredit/tb_cert.ibd...
  38. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_openapi_acquire_log.ibd.delta is 16384 bytes
  39. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_openapi_acquire_log.ibd.delta to ./xcredit/tb_openapi_acquire_log.ibd...
  40. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_system_param.ibd.delta is 16384 bytes
  41. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_system_param.ibd.delta to ./xcredit/tb_system_param.ibd...
  42. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_sync_job.ibd.delta is 16384 bytes
  43. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_sync_job.ibd.delta to ./xcredit/tb_sync_job.ibd...
  44. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_analyze_index.ibd.delta is 16384 bytes
  45. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_analyze_index.ibd.delta to ./xcredit/tb_analyze_index.ibd...
  46. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_query_data_history.ibd.delta is 16384 bytes
  47. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_query_data_history.ibd.delta to ./xcredit/tb_query_data_history.ibd...
  48. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_data_complaint.ibd.delta is 16384 bytes
  49. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_data_complaint.ibd.delta to ./xcredit/tb_data_complaint.ibd...
  50. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_openapi.ibd.delta is 16384 bytes
  51. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_openapi.ibd.delta to ./xcredit/tb_openapi.ibd...
  52. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_role_resource.ibd.delta is 16384 bytes
  53. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_role_resource.ibd.delta to ./xcredit/tb_role_resource.ibd...
  54. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_query_index_log.ibd.delta is 16384 bytes
  55. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_query_index_log.ibd.delta to ./xcredit/tb_query_index_log.ibd...
  56. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_message.ibd.delta is 16384 bytes
  57. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_message.ibd.delta to ./xcredit/tb_message.ibd...
  58. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_admin.ibd.delta is 16384 bytes
  59. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_admin.ibd.delta to ./xcredit/tb_admin.ibd...
  60. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_query_offer_log.ibd.delta is 16384 bytes
  61. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_query_offer_log.ibd.delta to ./xcredit/tb_query_offer_log.ibd...
  62. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_index_log.ibd.delta is 16384 bytes
  63. Applying /backup/incr_backup/2018-06-12_10-40-49//xcredit/tb_index_log.ibd.delta to ./xcredit/tb_index_log.ibd...
  64. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//sys/sys_config.ibd.delta is 16384 bytes
  65. Applying /backup/incr_backup/2018-06-12_10-40-49//sys/sys_config.ibd.delta to ./sys/sys_config.ibd...
  66. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/plugin.ibd.delta is 16384 bytes
  67. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/plugin.ibd.delta to ./mysql/plugin.ibd...
  68. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/help_topic.ibd.delta is 16384 bytes
  69. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/help_topic.ibd.delta to ./mysql/help_topic.ibd...
  70. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/engine_cost.ibd.delta is 16384 bytes
  71. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/engine_cost.ibd.delta to ./mysql/engine_cost.ibd...
  72. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/user_bak.ibd.delta is 16384 bytes
  73. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/user_bak.ibd.delta to ./mysql/user_bak.ibd...
  74. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone.ibd.delta is 16384 bytes
  75. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone.ibd.delta to ./mysql/time_zone.ibd...
  76. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone_name.ibd.delta is 16384 bytes
  77. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone_name.ibd.delta to ./mysql/time_zone_name.ibd...
  78. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/innodb_index_stats.ibd.delta is 16384 bytes
  79. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/innodb_index_stats.ibd.delta to ./mysql/innodb_index_stats.ibd...
  80. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/slave_worker_info.ibd.delta is 16384 bytes
  81. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/slave_worker_info.ibd.delta to ./mysql/slave_worker_info.ibd...
  82. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/servers.ibd.delta is 16384 bytes
  83. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/servers.ibd.delta to ./mysql/servers.ibd...
  84. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone_transition.ibd.delta is 16384 bytes
  85. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone_transition.ibd.delta to ./mysql/time_zone_transition.ibd...
  86. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/slave_master_info.ibd.delta is 16384 bytes
  87. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/slave_master_info.ibd.delta to ./mysql/slave_master_info.ibd...
  88. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone_leap_second.ibd.delta is 16384 bytes
  89. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone_leap_second.ibd.delta to ./mysql/time_zone_leap_second.ibd...
  90. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone_transition_type.ibd.delta is 16384 bytes
  91. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/time_zone_transition_type.ibd.delta to ./mysql/time_zone_transition_type.ibd...
  92. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/help_relation.ibd.delta is 16384 bytes
  93. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/help_relation.ibd.delta to ./mysql/help_relation.ibd...
  94. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/slave_relay_log_info.ibd.delta is 16384 bytes
  95. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/slave_relay_log_info.ibd.delta to ./mysql/slave_relay_log_info.ibd...
  96. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/gtid_executed.ibd.delta is 16384 bytes
  97. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/gtid_executed.ibd.delta to ./mysql/gtid_executed.ibd...
  98. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/server_cost.ibd.delta is 16384 bytes
  99. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/server_cost.ibd.delta to ./mysql/server_cost.ibd...
  100. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/help_category.ibd.delta is 16384 bytes
  101. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/help_category.ibd.delta to ./mysql/help_category.ibd...
  102. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/help_keyword.ibd.delta is 16384 bytes
  103. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/help_keyword.ibd.delta to ./mysql/help_keyword.ibd...
  104. xtrabackup: page size for /backup/incr_backup/2018-06-12_10-40-49//mysql/innodb_table_stats.ibd.delta is 16384 bytes
  105. Applying /backup/incr_backup/2018-06-12_10-40-49//mysql/innodb_table_stats.ibd.delta to ./mysql/innodb_table_stats.ibd...
  106. xtrabackup: using the following InnoDB configuration for recovery:
  107. xtrabackup: innodb_data_home_dir = .
  108. xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
  109. xtrabackup: innodb_log_group_home_dir = /backup/incr_backup/2018-06-12_10-40-49/
  110. xtrabackup: innodb_log_files_in_group = 1
  111. xtrabackup: innodb_log_file_size = 8388608
  112. xtrabackup: Starting InnoDB instance for recovery.
  113. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
  114. InnoDB: PUNCH HOLE support available
  115. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  116. InnoDB: Uses event mutexes
  117. InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
  118. InnoDB: Compressed tables use zlib 1.2.3
  119. InnoDB: Number of pools: 1
  120. InnoDB: Using CPU crc32 instructions
  121. InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
  122. InnoDB: Completed initialization of buffer pool
  123. InnoDB: page_cleaner coordinator priority: -20
  124. InnoDB: Highest supported file format is Barracuda.
  125. InnoDB: Log scan progressed past the checkpoint lsn 1540210034
  126. InnoDB: Doing recovery: scanned up to log sequence number 1540210043 (0%)
  127. InnoDB: Doing recovery: scanned up to log sequence number 1540210043 (0%)
  128. InnoDB: Are you sure you are using the right ib_logfiles to start up the database? Log sequence number in the ib_logfiles is 1540210034, less than the log sequence number in the first system tablespace file header, 1540210052.
  129. InnoDB: Database was not shutdown normally!
  130. InnoDB: Starting crash recovery.
  131. InnoDB: xtrabackup: Last MySQL binlog file position 3349, file name mysql-bin.000001
  132. InnoDB: xtrabackup: Last MySQL binlog file position 3349, file name mysql-bin.000001

  133. xtrabackup: starting shutdown with innodb_fast_shutdown = 1
  134. InnoDB: Starting shutdown...
  135. InnoDB: Shutdown completed; log sequence number 1540210052
  136. InnoDB: Number of pools: 1
  137. 180612 11:04:08 [01] Copying /backup/incr_backup/2018-06-12_10-40-49/test/test.frm to ./test/test.frm
  138. 180612 11:04:08 [01] ...done
  139. 180612 11:04:08 [01] Copying /backup/incr_backup/2018-06-12_10-40-49/test/t_user_info.frm to ./test/t_user_info.frm
  140. 180612 11:04:08 [01] ...done
  141. 180612 11:04:08 [01] Copying /backup/incr_backup/2018-06-12_10-40-49/test/t_tou_info.frm to ./test/t_tou_info.frm
  142. 180612 11:04:08 [01] ...done
  143. 180612 11:04:08 [01] Copying /backup/incr_backup/2018-06-12_10-40-49/test/t_tou_info.MYI to ./test/t_tou_info.MYI
  144. 180612 11:04:08 [01] ...done
  145. 180612 11:04:08 [01] Copying /backup/incr_backup/2018-06-12_10-40