API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 13th, 2017
119
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 33.87 KB | None | 0 0
raw download clone embed print report
  1. vagrant@n2:~$ sudo su
  2. root@n2:/home/vagrant# ulimit -n 256000 && /usr/bin/innobackupex --defaults-file=/etc/mysql/my.cnf --no-backup-locks --stream=xbstream /var/lib/mysql/ | socat - TCP4:192.168.33.13:9999
  3. 170913 19:37:53 innobackupex: Starting the backup operation
  4.  
  5. IMPORTANT: Please check that the backup run completes successfully.
  6. At the end of a successful backup run innobackupex
  7. prints "completed OK!".
  8.  
  9. 170913 19:37:53 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/lib/mysql/mysql.sock' as 'backupuser' (using password: YES).
  10. 170913 19:37:53 version_check Connected to MySQL server
  11. 170913 19:37:53 version_check Executing a version check against the server...
  12. 170913 19:37:53 version_check Done.
  13. 170913 19:37:53 Connecting to MySQL server host: localhost, user: backupuser, password: set, port: not set, socket: /var/lib/mysql/mysql.sock
  14. Using server version 5.7.19-17-log
  15. /usr/bin/innobackupex version 2.4.8 based on MySQL server 5.7.13 Linux (x86_64) (revision id: 97330f7)
  16. xtrabackup: uses posix_fadvise().
  17. xtrabackup: cd to /var/lib/mysql
  18. xtrabackup: open files limit requested 0, set to 256000
  19. xtrabackup: using the following InnoDB configuration:
  20. xtrabackup: innodb_data_home_dir = .
  21. xtrabackup: innodb_data_file_path = ibdata1:100M:autoextend
  22. xtrabackup: innodb_log_group_home_dir = ./
  23. xtrabackup: innodb_log_files_in_group = 2
  24. xtrabackup: innodb_log_file_size = 268435456
  25. xtrabackup: using O_DIRECT
  26. InnoDB: Number of pools: 1
  27. 170913 19:37:53 >> log scanned up to (2545243)
  28. xtrabackup: Generating a list of tablespaces
  29. InnoDB: Allocated tablespace ID 8 for mysql/time_zone_name, old maximum was 0
  30. 170913 19:37:54 [01] Streaming ./ibdata1
  31. 170913 19:37:54 [01] ...done
  32. 170913 19:37:54 [01] Streaming ./mysql/time_zone_name.ibd
  33. 170913 19:37:54 [01] ...done
  34. 170913 19:37:54 [01] Streaming ./mysql/time_zone_transition_type.ibd
  35. 170913 19:37:54 [01] ...done
  36. 170913 19:37:54 [01] Streaming ./mysql/innodb_index_stats.ibd
  37. 170913 19:37:54 [01] ...done
  38. 170913 19:37:54 [01] Streaming ./mysql/time_zone_leap_second.ibd
  39. 170913 19:37:54 [01] ...done
  40. 170913 19:37:54 [01] Streaming ./mysql/help_keyword.ibd
  41. 170913 19:37:54 [01] ...done
  42. 170913 19:37:54 [01] Streaming ./mysql/innodb_table_stats.ibd
  43. 170913 19:37:54 [01] ...done
  44. 170913 19:37:54 [01] Streaming ./mysql/help_category.ibd
  45. 170913 19:37:54 [01] ...done
  46. 170913 19:37:54 [01] Streaming ./mysql/time_zone.ibd
  47. 170913 19:37:54 [01] ...done
  48. 170913 19:37:54 [01] Streaming ./mysql/help_topic.ibd
  49. 170913 19:37:54 [01] ...done
  50. 170913 19:37:54 [01] Streaming ./mysql/slave_relay_log_info.ibd
  51. 170913 19:37:54 [01] ...done
  52. 170913 19:37:54 [01] Streaming ./mysql/slave_master_info.ibd
  53. 170913 19:37:54 [01] ...done
  54. 170913 19:37:54 [01] Streaming ./mysql/server_cost.ibd
  55. 170913 19:37:54 [01] ...done
  56. 170913 19:37:54 [01] Streaming ./mysql/time_zone_transition.ibd
  57. 170913 19:37:54 [01] ...done
  58. 170913 19:37:54 [01] Streaming ./mysql/gtid_executed.ibd
  59. 170913 19:37:54 [01] ...done
  60. 170913 19:37:54 [01] Streaming ./mysql/servers.ibd
  61. 170913 19:37:54 [01] ...done
  62. 170913 19:37:54 [01] Streaming ./mysql/engine_cost.ibd
  63. 170913 19:37:54 [01] ...done
  64. 170913 19:37:54 [01] Streaming ./mysql/plugin.ibd
  65. 170913 19:37:54 [01] ...done
  66. 170913 19:37:54 [01] Streaming ./mysql/help_relation.ibd
  67. 170913 19:37:54 [01] ...done
  68. 170913 19:37:54 [01] Streaming ./mysql/slave_worker_info.ibd
  69. 170913 19:37:54 [01] ...done
  70. 170913 19:37:54 [01] Streaming ./sys/sys_config.ibd
  71. 170913 19:37:54 [01] ...done
  72. 170913 19:37:54 >> log scanned up to (2545243)
  73. 170913 19:37:55 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
  74. 170913 19:37:55 Executing FLUSH TABLES WITH READ LOCK...
  75. 170913 19:37:55 Starting to backup non-InnoDB tables and files
  76. 170913 19:37:55 [01] Streaming ./mysql/func.MYI to <STDOUT>
  77. 170913 19:37:55 [01] ...done
  78. 170913 19:37:55 [01] Streaming ./mysql/func.frm to <STDOUT>
  79. 170913 19:37:55 [01] ...done
  80. 170913 19:37:55 [01] Streaming ./mysql/engine_cost.frm to <STDOUT>
  81. 170913 19:37:55 [01] ...done
  82. 170913 19:37:55 [01] Streaming ./mysql/time_zone.frm to <STDOUT>
  83. 170913 19:37:55 [01] ...done
  84. 170913 19:37:55 [01] Streaming ./mysql/user.MYI to <STDOUT>
  85. 170913 19:37:55 [01] ...done
  86. 170913 19:37:55 [01] Streaming ./mysql/db.frm to <STDOUT>
  87. 170913 19:37:55 [01] ...done
  88. 170913 19:37:55 [01] Streaming ./mysql/servers.frm to <STDOUT>
  89. 170913 19:37:55 [01] ...done
  90. 170913 19:37:55 [01] Streaming ./mysql/general_log.frm to <STDOUT>
  91. 170913 19:37:55 [01] ...done
  92. 170913 19:37:55 [01] Streaming ./mysql/event.MYI to <STDOUT>
  93. 170913 19:37:55 [01] ...done
  94. 170913 19:37:55 [01] Streaming ./mysql/user.frm to <STDOUT>
  95. 170913 19:37:55 [01] ...done
  96. 170913 19:37:55 [01] Streaming ./mysql/event.MYD to <STDOUT>
  97. 170913 19:37:55 [01] ...done
  98. 170913 19:37:55 [01] Streaming ./mysql/slave_relay_log_info.frm to <STDOUT>
  99. 170913 19:37:55 [01] ...done
  100. 170913 19:37:55 [01] Streaming ./mysql/db.opt to <STDOUT>
  101. 170913 19:37:55 [01] ...done
  102. 170913 19:37:55 [01] Streaming ./mysql/columns_priv.MYD to <STDOUT>
  103. 170913 19:37:55 [01] ...done
  104. 170913 19:37:55 [01] Streaming ./mysql/general_log.CSV to <STDOUT>
  105. 170913 19:37:55 [01] ...done
  106. 170913 19:37:55 [01] Streaming ./mysql/help_topic.frm to <STDOUT>
  107. 170913 19:37:55 [01] ...done
  108. 170913 19:37:55 [01] Streaming ./mysql/ndb_binlog_index.frm to <STDOUT>
  109. 170913 19:37:55 [01] ...done
  110. 170913 19:37:55 [01] Streaming ./mysql/proc.MYD to <STDOUT>
  111. 170913 19:37:55 [01] ...done
  112. 170913 19:37:55 [01] Streaming ./mysql/time_zone_leap_second.frm to <STDOUT>
  113. 170913 19:37:55 [01] ...done
  114. 170913 19:37:55 [01] Streaming ./mysql/user.MYD to <STDOUT>
  115. 170913 19:37:55 [01] ...done
  116. 170913 19:37:55 [01] Streaming ./mysql/server_cost.frm to <STDOUT>
  117. 170913 19:37:55 [01] ...done
  118. 170913 19:37:55 [01] Streaming ./mysql/procs_priv.frm to <STDOUT>
  119. 170913 19:37:55 [01] ...done
  120. 170913 19:37:55 [01] Streaming ./mysql/gtid_executed.frm to <STDOUT>
  121. 170913 19:37:55 [01] ...done
  122. 170913 19:37:55 [01] Streaming ./mysql/time_zone_transition.frm to <STDOUT>
  123. 170913 19:37:55 [01] ...done
  124. 170913 19:37:55 [01] Streaming ./mysql/db.MYI to <STDOUT>
  125. 170913 19:37:55 [01] ...done
  126. 170913 19:37:55 [01] Streaming ./mysql/tables_priv.MYI to <STDOUT>
  127. 170913 19:37:55 [01] ...done
  128. 170913 19:37:55 [01] Streaming ./mysql/help_category.frm to <STDOUT>
  129. 170913 19:37:55 [01] ...done
  130. 170913 19:37:55 [01] Streaming ./mysql/tables_priv.frm to <STDOUT>
  131. 170913 19:37:55 [01] ...done
  132. 170913 19:37:55 [01] Streaming ./mysql/help_keyword.frm to <STDOUT>
  133. 170913 19:37:55 [01] ...done
  134. 170913 19:37:55 [01] Streaming ./mysql/help_relation.frm to <STDOUT>
  135. 170913 19:37:55 [01] ...done
  136. 170913 19:37:55 [01] Streaming ./mysql/general_log.CSM to <STDOUT>
  137. 170913 19:37:55 [01] ...done
  138. 170913 19:37:55 [01] Streaming ./mysql/event.frm to <STDOUT>
  139. 170913 19:37:55 [01] ...done
  140. 170913 19:37:55 [01] Streaming ./mysql/slow_log.CSV to <STDOUT>
  141. 170913 19:37:55 [01] ...done
  142. 170913 19:37:55 [01] Streaming ./mysql/ndb_binlog_index.MYI to <STDOUT>
  143. 170913 19:37:55 [01] ...done
  144. 170913 19:37:55 [01] Streaming ./mysql/db.MYD to <STDOUT>
  145. 170913 19:37:55 [01] ...done
  146. 170913 19:37:55 [01] Streaming ./mysql/time_zone_name.frm to <STDOUT>
  147. 170913 19:37:55 [01] ...done
  148. 170913 19:37:55 [01] Streaming ./mysql/time_zone_transition_type.frm to <STDOUT>
  149. 170913 19:37:55 [01] ...done
  150. 170913 19:37:55 [01] Streaming ./mysql/proxies_priv.frm to <STDOUT>
  151. 170913 19:37:55 [01] ...done
  152. 170913 19:37:55 [01] Streaming ./mysql/slow_log.frm to <STDOUT>
  153. 170913 19:37:55 [01] ...done
  154. 170913 19:37:55 [01] Streaming ./mysql/proxies_priv.MYI to <STDOUT>
  155. 170913 19:37:55 [01] ...done
  156. 170913 19:37:55 [01] Streaming ./mysql/slave_worker_info.frm to <STDOUT>
  157. 170913 19:37:55 [01] ...done
  158. 170913 19:37:55 [01] Streaming ./mysql/procs_priv.MYD to <STDOUT>
  159. 170913 19:37:55 [01] ...done
  160. 170913 19:37:55 [01] Streaming ./mysql/slave_master_info.frm to <STDOUT>
  161. 170913 19:37:55 [01] ...done
  162. 170913 19:37:55 [01] Streaming ./mysql/func.MYD to <STDOUT>
  163. 170913 19:37:55 [01] ...done
  164. 170913 19:37:55 [01] Streaming ./mysql/innodb_index_stats.frm to <STDOUT>
  165. 170913 19:37:55 [01] ...done
  166. 170913 19:37:55 [01] Streaming ./mysql/slow_log.CSM to <STDOUT>
  167. 170913 19:37:55 [01] ...done
  168. 170913 19:37:55 [01] Streaming ./mysql/ndb_binlog_index.MYD to <STDOUT>
  169. 170913 19:37:55 [01] ...done
  170. 170913 19:37:55 [01] Streaming ./mysql/innodb_table_stats.frm to <STDOUT>
  171. 170913 19:37:55 [01] ...done
  172. 170913 19:37:55 [01] Streaming ./mysql/columns_priv.MYI to <STDOUT>
  173. 170913 19:37:55 [01] ...done
  174. 170913 19:37:55 [01] Streaming ./mysql/tables_priv.MYD to <STDOUT>
  175. 170913 19:37:55 [01] ...done
  176. 170913 19:37:55 [01] Streaming ./mysql/procs_priv.MYI to <STDOUT>
  177. 170913 19:37:55 [01] ...done
  178. 170913 19:37:55 [01] Streaming ./mysql/plugin.frm to <STDOUT>
  179. 170913 19:37:55 [01] ...done
  180. 170913 19:37:55 [01] Streaming ./mysql/proc.frm to <STDOUT>
  181. 170913 19:37:55 [01] ...done
  182. 170913 19:37:55 [01] Streaming ./mysql/proc.MYI to <STDOUT>
  183. 170913 19:37:55 [01] ...done
  184. 170913 19:37:55 [01] Streaming ./mysql/columns_priv.frm to <STDOUT>
  185. 170913 19:37:55 [01] ...done
  186. 170913 19:37:55 [01] Streaming ./mysql/proxies_priv.MYD to <STDOUT>
  187. 170913 19:37:55 [01] ...done
  188. 170913 19:37:55 [01] Streaming ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to <STDOUT>
  189. 170913 19:37:55 [01] ...done
  190. 170913 19:37:55 [01] Streaming ./sys/memory_by_thread_by_current_bytes.frm to <STDOUT>
  191. 170913 19:37:55 [01] ...done
  192. 170913 19:37:55 [01] Streaming ./sys/schema_table_statistics.frm to <STDOUT>
  193. 170913 19:37:55 [01] ...done
  194. 170913 19:37:55 [01] Streaming ./sys/x@0024memory_by_user_by_current_bytes.frm to <STDOUT>
  195. 170913 19:37:55 [01] ...done
  196. 170913 19:37:55 [01] Streaming ./sys/host_summary.frm to <STDOUT>
  197. 170913 19:37:55 [01] ...done
  198. 170913 19:37:55 [01] Streaming ./sys/version.frm to <STDOUT>
  199. 170913 19:37:55 [01] ...done
  200. 170913 19:37:55 [01] Streaming ./sys/x@0024ps_schema_table_statistics_io.frm to <STDOUT>
  201. 170913 19:37:55 [01] ...done
  202. 170913 19:37:55 [01] Streaming ./sys/x@0024schema_table_lock_waits.frm to <STDOUT>
  203. 170913 19:37:55 [01] ...done
  204. 170913 19:37:55 [01] Streaming ./sys/innodb_lock_waits.frm to <STDOUT>
  205. 170913 19:37:55 [01] ...done
  206. 170913 19:37:55 [01] Streaming ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to <STDOUT>
  207. 170913 19:37:55 [01] ...done
  208. 170913 19:37:55 [01] Streaming ./sys/x@0024user_summary_by_file_io.frm to <STDOUT>
  209. 170913 19:37:55 [01] ...done
  210. 170913 19:37:55 [01] Streaming ./sys/x@0024innodb_lock_waits.frm to <STDOUT>
  211. 170913 19:37:55 [01] ...done
  212. 170913 19:37:55 [01] Streaming ./sys/x@0024wait_classes_global_by_avg_latency.frm to <STDOUT>
  213. 170913 19:37:55 [01] ...done
  214. 170913 19:37:55 [01] Streaming ./sys/user_summary.frm to <STDOUT>
  215. 170913 19:37:55 [01] ...done
  216. 170913 19:37:55 [01] Streaming ./sys/x@0024host_summary_by_stages.frm to <STDOUT>
  217. 170913 19:37:55 [01] ...done
  218. 170913 19:37:55 [01] Streaming ./sys/io_global_by_wait_by_latency.frm to <STDOUT>
  219. 170913 19:37:55 [01] ...done
  220. 170913 19:37:55 [01] Streaming ./sys/session_ssl_status.frm to <STDOUT>
  221. 170913 19:37:55 [01] ...done
  222. 170913 19:37:55 [01] Streaming ./sys/schema_auto_increment_columns.frm to <STDOUT>
  223. 170913 19:37:55 [01] ...done
  224. 170913 19:37:55 [01] Streaming ./sys/metrics.frm to <STDOUT>
  225. 170913 19:37:55 [01] ...done
  226. 170913 19:37:55 [01] Streaming ./sys/x@0024statements_with_full_table_scans.frm to <STDOUT>
  227. 170913 19:37:55 [01] ...done
  228. 170913 19:37:55 [01] Streaming ./sys/x@0024waits_by_host_by_latency.frm to <STDOUT>
  229. 170913 19:37:55 [01] ...done
  230. 170913 19:37:55 [01] Streaming ./sys/sys_config_insert_set_user.TRN to <STDOUT>
  231. 170913 19:37:55 [01] ...done
  232. 170913 19:37:55 [01] Streaming ./sys/session.frm to <STDOUT>
  233. 170913 19:37:55 [01] ...done
  234. 170913 19:37:55 [01] Streaming ./sys/x@0024user_summary.frm to <STDOUT>
  235. 170913 19:37:55 [01] ...done
  236. 170913 19:37:55 [01] Streaming ./sys/sys_config.TRG to <STDOUT>
  237. 170913 19:37:55 [01] ...done
  238. 170913 19:37:55 [01] Streaming ./sys/x@0024host_summary_by_statement_latency.frm to <STDOUT>
  239. 170913 19:37:55 [01] ...done
  240. 170913 19:37:55 [01] Streaming ./sys/x@0024schema_flattened_keys.frm to <STDOUT>
  241. 170913 19:37:55 [01] ...done
  242. 170913 19:37:55 [01] Streaming ./sys/user_summary_by_file_io.frm to <STDOUT>
  243. 170913 19:37:55 [01] ...done
  244. 170913 19:37:55 [01] Streaming ./sys/memory_global_total.frm to <STDOUT>
  245. 170913 19:37:55 [01] ...done
  246. 170913 19:37:55 [01] Streaming ./sys/x@0024user_summary_by_stages.frm to <STDOUT>
  247. 170913 19:37:55 [01] ...done
  248. 170913 19:37:55 [01] Streaming ./sys/statements_with_sorting.frm to <STDOUT>
  249. 170913 19:37:55 [01] ...done
  250. 170913 19:37:55 [01] Streaming ./sys/io_global_by_file_by_bytes.frm to <STDOUT>
  251. 170913 19:37:55 [01] ...done
  252. 170913 19:37:55 [01] Streaming ./sys/x@0024user_summary_by_statement_latency.frm to <STDOUT>
  253. 170913 19:37:55 [01] ...done
  254. 170913 19:37:55 [01] Streaming ./sys/wait_classes_global_by_avg_latency.frm to <STDOUT>
  255. 170913 19:37:55 [01] ...done
  256. 170913 19:37:55 [01] Streaming ./sys/x@0024memory_global_total.frm to <STDOUT>
  257. 170913 19:37:55 [01] ...done
  258. 170913 19:37:55 [01] Streaming ./sys/sys_config.frm to <STDOUT>
  259. 170913 19:37:55 [01] ...done
  260. 170913 19:37:55 [01] Streaming ./sys/schema_tables_with_full_table_scans.frm to <STDOUT>
  261. 170913 19:37:55 [01] ...done
  262. 170913 19:37:55 [01] Streaming ./sys/schema_table_lock_waits.frm to <STDOUT>
  263. 170913 19:37:55 [01] ...done
  264. 170913 19:37:55 [01] Streaming ./sys/memory_by_host_by_current_bytes.frm to <STDOUT>
  265. 170913 19:37:55 [01] ...done
  266. 170913 19:37:55 [01] Streaming ./sys/x@0024io_global_by_wait_by_latency.frm to <STDOUT>
  267. 170913 19:37:55 [01] ...done
  268. 170913 19:37:55 [01] Streaming ./sys/x@0024schema_table_statistics.frm to <STDOUT>
  269. 170913 19:37:55 [01] ...done
  270. 170913 19:37:55 [01] Streaming ./sys/x@0024host_summary_by_file_io.frm to <STDOUT>
  271. 170913 19:37:55 [01] ...done
  272. 170913 19:37:55 [01] Streaming ./sys/db.opt to <STDOUT>
  273. 170913 19:37:55 [01] ...done
  274. 170913 19:37:55 [01] Streaming ./sys/x@0024innodb_buffer_stats_by_schema.frm to <STDOUT>
  275. 170913 19:37:55 [01] ...done
  276. 170913 19:37:55 [01] Streaming ./sys/x@0024innodb_buffer_stats_by_table.frm to <STDOUT>
  277. 170913 19:37:55 [01] ...done
  278. 170913 19:37:55 [01] Streaming ./sys/innodb_buffer_stats_by_schema.frm to <STDOUT>
  279. 170913 19:37:55 [01] ...done
  280. 170913 19:37:55 [01] Streaming ./sys/statements_with_full_table_scans.frm to <STDOUT>
  281. 170913 19:37:55 [01] ...done
  282. 170913 19:37:55 [01] Streaming ./sys/user_summary_by_statement_type.frm to <STDOUT>
  283. 170913 19:37:55 [01] ...done
  284. 170913 19:37:55 [01] Streaming ./sys/latest_file_io.frm to <STDOUT>
  285. 170913 19:37:55 [01] ...done
  286. 170913 19:37:55 [01] Streaming ./sys/processlist.frm to <STDOUT>
  287. 170913 19:37:55 [01] ...done
  288. 170913 19:37:55 [01] Streaming ./sys/x@0024processlist.frm to <STDOUT>
  289. 170913 19:37:55 [01] ...done
  290. 170913 19:37:55 [01] Streaming ./sys/x@0024host_summary_by_statement_type.frm to <STDOUT>
  291. 170913 19:37:55 [01] ...done
  292. 170913 19:37:55 [01] Streaming ./sys/schema_object_overview.frm to <STDOUT>
  293. 170913 19:37:55 [01] ...done
  294. 170913 19:37:55 [01] Streaming ./sys/statement_analysis.frm to <STDOUT>
  295. 170913 19:37:55 [01] ...done
  296. 170913 19:37:55 [01] Streaming ./sys/host_summary_by_stages.frm to <STDOUT>
  297. 170913 19:37:55 [01] ...done
  298. 170913 19:37:55 [01] Streaming ./sys/x@0024statements_with_errors_or_warnings.frm to <STDOUT>
  299. 170913 19:37:55 [01] ...done
  300. 170913 19:37:55 [01] Streaming ./sys/x@0024latest_file_io.frm to <STDOUT>
  301. 170913 19:37:55 [01] ...done
  302. 170913 19:37:55 [01] Streaming ./sys/io_by_thread_by_latency.frm to <STDOUT>
  303. 170913 19:37:55 [01] ...done
  304. 170913 19:37:55 [01] Streaming ./sys/wait_classes_global_by_latency.frm to <STDOUT>
  305. 170913 19:37:55 [01] ...done
  306. 170913 19:37:55 [01] Streaming ./sys/x@0024host_summary.frm to <STDOUT>
  307. 170913 19:37:55 [01] ...done
  308. 170913 19:37:55 [01] Streaming ./sys/x@0024wait_classes_global_by_latency.frm to <STDOUT>
  309. 170913 19:37:55 [01] ...done
  310. 170913 19:37:55 [01] Streaming ./sys/x@0024statements_with_sorting.frm to <STDOUT>
  311. 170913 19:37:55 [01] ...done
  312. 170913 19:37:55 [01] Streaming ./sys/x@0024statements_with_temp_tables.frm to <STDOUT>
  313. 170913 19:37:55 [01] ...done
  314. 170913 19:37:55 [01] Streaming ./sys/x@0024host_summary_by_file_io_type.frm to <STDOUT>
  315. 170913 19:37:55 [01] ...done
  316. 170913 19:37:55 [01] Streaming ./sys/statements_with_temp_tables.frm to <STDOUT>
  317. 170913 19:37:55 [01] ...done
  318. 170913 19:37:55 [01] Streaming ./sys/x@0024session.frm to <STDOUT>
  319. 170913 19:37:55 [01] ...done
  320. 170913 19:37:55 [01] Streaming ./sys/x@0024io_global_by_wait_by_bytes.frm to <STDOUT>
  321. 170913 19:37:55 [01] ...done
  322. 170913 19:37:55 [01] Streaming ./sys/sys_config_update_set_user.TRN to <STDOUT>
  323. 170913 19:37:55 [01] ...done
  324. 170913 19:37:55 [01] Streaming ./sys/schema_table_statistics_with_buffer.frm to <STDOUT>
  325. 170913 19:37:55 [01] ...done
  326. 170913 19:37:55 [01] Streaming ./sys/statements_with_errors_or_warnings.frm to <STDOUT>
  327. 170913 19:37:55 [01] ...done
  328. 170913 19:37:55 [01] Streaming ./sys/x@0024waits_by_user_by_latency.frm to <STDOUT>
  329. 170913 19:37:55 [01] ...done
  330. 170913 19:37:55 [01] Streaming ./sys/x@0024schema_index_statistics.frm to <STDOUT>
  331. 170913 19:37:55 [01] ...done
  332. 170913 19:37:55 [01] Streaming ./sys/x@0024waits_global_by_latency.frm to <STDOUT>
  333. 170913 19:37:55 [01] ...done
  334. 170913 19:37:55 [01] Streaming ./sys/waits_by_host_by_latency.frm to <STDOUT>
  335. 170913 19:37:55 [01] ...done
  336. 170913 19:37:55 [01] Streaming ./sys/x@0024io_global_by_file_by_bytes.frm to <STDOUT>
  337. 170913 19:37:55 [01] ...done
  338. 170913 19:37:55 [01] Streaming ./sys/io_global_by_file_by_latency.frm to <STDOUT>
  339. 170913 19:37:55 [01] ...done
  340. 170913 19:37:55 [01] Streaming ./sys/ps_check_lost_instrumentation.frm to <STDOUT>
  341. 170913 19:37:55 [01] ...done
  342. 170913 19:37:55 [01] Streaming ./sys/x@0024memory_global_by_current_bytes.frm to <STDOUT>
  343. 170913 19:37:55 [01] ...done
  344. 170913 19:37:55 [01] Streaming ./sys/x@0024ps_digest_avg_latency_distribution.frm to <STDOUT>
  345. 170913 19:37:55 [01] ...done
  346. 170913 19:37:55 [01] Streaming ./sys/host_summary_by_statement_type.frm to <STDOUT>
  347. 170913 19:37:55 [01] ...done
  348. 170913 19:37:55 [01] Streaming ./sys/user_summary_by_stages.frm to <STDOUT>
  349. 170913 19:37:55 [01] ...done
  350. 170913 19:37:55 [01] Streaming ./sys/x@0024statement_analysis.frm to <STDOUT>
  351. 170913 19:37:55 [01] ...done
  352. 170913 19:37:55 [01] Streaming ./sys/statements_with_runtimes_in_95th_percentile.frm to <STDOUT>
  353. 170913 19:37:55 [01] ...done
  354. 170913 19:37:55 [01] Streaming ./sys/host_summary_by_file_io_type.frm to <STDOUT>
  355. 170913 19:37:55 [01] ...done
  356. 170913 19:37:55 [01] Streaming ./sys/x@0024user_summary_by_file_io_type.frm to <STDOUT>
  357. 170913 19:37:55 [01] ...done
  358. 170913 19:37:55 [01] Streaming ./sys/host_summary_by_file_io.frm to <STDOUT>
  359. 170913 19:37:55 [01] ...done
  360. 170913 19:37:55 [01] Streaming ./sys/waits_by_user_by_latency.frm to <STDOUT>
  361. 170913 19:37:55 [01] ...done
  362. 170913 19:37:55 [01] Streaming ./sys/x@0024io_global_by_file_by_latency.frm to <STDOUT>
  363. 170913 19:37:55 [01] ...done
  364. 170913 19:37:55 [01] Streaming ./sys/x@0024io_by_thread_by_latency.frm to <STDOUT>
  365. 170913 19:37:55 [01] ...done
  366. 170913 19:37:55 [01] Streaming ./sys/memory_global_by_current_bytes.frm to <STDOUT>
  367. 170913 19:37:55 [01] ...done
  368. 170913 19:37:55 [01] Streaming ./sys/schema_unused_indexes.frm to <STDOUT>
  369. 170913 19:37:55 [01] ...done
  370. 170913 19:37:55 [01] Streaming ./sys/schema_redundant_indexes.frm to <STDOUT>
  371. 170913 19:37:55 [01] ...done
  372. 170913 19:37:55 [01] Streaming ./sys/io_global_by_wait_by_bytes.frm to <STDOUT>
  373. 170913 19:37:55 [01] ...done
  374. 170913 19:37:55 [01] Streaming ./sys/innodb_buffer_stats_by_table.frm to <STDOUT>
  375. 170913 19:37:55 [01] ...done
  376. 170913 19:37:55 [01] Streaming ./sys/memory_by_user_by_current_bytes.frm to <STDOUT>
  377. 170913 19:37:55 [01] ...done
  378. 170913 19:37:55 [01] Streaming ./sys/x@0024memory_by_host_by_current_bytes.frm to <STDOUT>
  379. 170913 19:37:55 [01] ...done
  380. 170913 19:37:55 [01] Streaming ./sys/x@0024user_summary_by_statement_type.frm to <STDOUT>
  381. 170913 19:37:55 [01] ...done
  382. 170913 19:37:55 [01] Streaming ./sys/host_summary_by_statement_latency.frm to <STDOUT>
  383. 170913 19:37:55 [01] ...done
  384. 170913 19:37:55 [01] Streaming ./sys/user_summary_by_statement_latency.frm to <STDOUT>
  385. 170913 19:37:55 [01] ...done
  386. 170913 19:37:55 [01] Streaming ./sys/x@0024schema_table_statistics_with_buffer.frm to <STDOUT>
  387. 170913 19:37:55 [01] ...done
  388. 170913 19:37:55 [01] Streaming ./sys/waits_global_by_latency.frm to <STDOUT>
  389. 170913 19:37:55 [01] ...done
  390. 170913 19:37:55 [01] Streaming ./sys/schema_index_statistics.frm to <STDOUT>
  391. 170913 19:37:55 [01] ...done
  392. 170913 19:37:55 [01] Streaming ./sys/x@0024schema_tables_with_full_table_scans.frm to <STDOUT>
  393. 170913 19:37:55 [01] ...done
  394. 170913 19:37:55 [01] Streaming ./sys/user_summary_by_file_io_type.frm to <STDOUT>
  395. 170913 19:37:55 [01] ...done
  396. 170913 19:37:55 [01] Streaming ./sys/x@0024memory_by_thread_by_current_bytes.frm to <STDOUT>
  397. 170913 19:37:55 [01] ...done
  398. 170913 19:37:55 [01] Streaming ./performance_schema/global_status.frm to <STDOUT>
  399. 170913 19:37:55 [01] ...done
  400. 170913 19:37:55 [01] Streaming ./performance_schema/events_waits_summary_by_user_by_event_name.frm to <STDOUT>
  401. 170913 19:37:55 [01] ...done
  402. 170913 19:37:55 [01] Streaming ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to <STDOUT>
  403. 170913 19:37:55 [01] ...done
  404. 170913 19:37:55 [01] Streaming ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to <STDOUT>
  405. 170913 19:37:55 [01] ...done
  406. 170913 19:37:55 [01] Streaming ./performance_schema/user_variables_by_thread.frm to <STDOUT>
  407. 170913 19:37:55 [01] ...done
  408. 170913 19:37:55 [01] Streaming ./performance_schema/events_stages_current.frm to <STDOUT>
  409. 170913 19:37:55 [01] ...done
  410. 170913 19:37:55 [01] Streaming ./performance_schema/events_transactions_history.frm to <STDOUT>
  411. 170913 19:37:55 [01] ...done
  412. 170913 19:37:55 [01] Streaming ./performance_schema/session_variables.frm to <STDOUT>
  413. 170913 19:37:55 [01] ...done
  414. 170913 19:37:55 [01] Streaming ./performance_schema/table_io_waits_summary_by_table.frm to <STDOUT>
  415. 170913 19:37:55 [01] ...done
  416. 170913 19:37:55 [01] Streaming ./performance_schema/threads.frm to <STDOUT>
  417. 170913 19:37:55 [01] ...done
  418. 170913 19:37:55 [01] Streaming ./performance_schema/cond_instances.frm to <STDOUT>
  419. 170913 19:37:55 [01] ...done
  420. 170913 19:37:55 [01] Streaming ./performance_schema/memory_summary_by_account_by_event_name.frm to <STDOUT>
  421. 170913 19:37:55 [01] ...done
  422. 170913 19:37:55 [01] Streaming ./performance_schema/events_transactions_history_long.frm to <STDOUT>
  423. 170913 19:37:55 [01] ...done
  424. 170913 19:37:55 [01] Streaming ./performance_schema/hosts.frm to <STDOUT>
  425. 170913 19:37:55 [01] ...done
  426. 170913 19:37:55 [01] Streaming ./performance_schema/metadata_locks.frm to <STDOUT>
  427. 170913 19:37:55 [01] ...done
  428. 170913 19:37:55 [01] Streaming ./performance_schema/status_by_thread.frm to <STDOUT>
  429. 170913 19:37:55 [01] ...done
  430. 170913 19:37:55 [01] Streaming ./performance_schema/events_stages_history_long.frm to <STDOUT>
  431. 170913 19:37:55 [01] ...done
  432. 170913 19:37:55 [01] Streaming ./performance_schema/replication_applier_status.frm to <STDOUT>
  433. 170913 19:37:55 [01] ...done
  434. 170913 19:37:55 [01] Streaming ./performance_schema/prepared_statements_instances.frm to <STDOUT>
  435. 170913 19:37:55 [01] ...done
  436. 170913 19:37:55 [01] Streaming ./performance_schema/status_by_host.frm to <STDOUT>
  437. 170913 19:37:55 [01] ...done
  438. 170913 19:37:55 [01] Streaming ./performance_schema/events_waits_summary_by_host_by_event_name.frm to <STDOUT>
  439. 170913 19:37:55 [01] ...done
  440. 170913 19:37:55 [01] Streaming ./performance_schema/events_transactions_summary_global_by_event_name.frm to <STDOUT>
  441. 170913 19:37:55 [01] ...done
  442. 170913 19:37:55 [01] Streaming ./performance_schema/file_instances.frm to <STDOUT>
  443. 170913 19:37:55 [01] ...done
  444. 170913 19:37:55 [01] Streaming ./performance_schema/replication_connection_status.frm to <STDOUT>
  445. 170913 19:37:55 [01] ...done
  446. 170913 19:37:55 [01] Streaming ./performance_schema/table_handles.frm to <STDOUT>
  447. 170913 19:37:55 [01] ...done
  448. 170913 19:37:55 [01] Streaming ./performance_schema/status_by_account.frm to <STDOUT>
  449. 170913 19:37:55 [01] ...done
  450. 170913 19:37:55 [01] Streaming ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to <STDOUT>
  451. 170913 19:37:55 [01] ...done
  452. 170913 19:37:55 [01] Streaming ./performance_schema/status_by_user.frm to <STDOUT>
  453. 170913 19:37:55 [01] ...done
  454. 170913 19:37:55 [01] Streaming ./performance_schema/db.opt to <STDOUT>
  455. 170913 19:37:55 [01] ...done
  456. 170913 19:37:55 [01] Streaming ./performance_schema/events_stages_summary_by_user_by_event_name.frm to <STDOUT>
  457. 170913 19:37:55 [01] ...done
  458. 170913 19:37:55 [01] Streaming ./performance_schema/performance_timers.frm to <STDOUT>
  459. 170913 19:37:55 [01] ...done
  460. 170913 19:37:55 [01] Streaming ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to <STDOUT>
  461. 170913 19:37:55 [01] ...done
  462. 170913 19:37:55 [01] Streaming ./performance_schema/events_stages_history.frm to <STDOUT>
  463. 170913 19:37:55 [01] ...done
  464. 170913 19:37:55 [01] Streaming ./performance_schema/events_waits_history.frm to <STDOUT>
  465. 170913 19:37:55 [01] ...done
  466. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_history_long.frm to <STDOUT>
  467. 170913 19:37:55 [01] ...done
  468. 170913 19:37:55 [01] Streaming ./performance_schema/events_transactions_current.frm to <STDOUT>
  469. 170913 19:37:55 [01] ...done
  470. 170913 19:37:55 [01] Streaming ./performance_schema/events_waits_current.frm to <STDOUT>
  471. 170913 19:37:55 [01] ...done
  472. 170913 19:37:55 [01] Streaming ./performance_schema/events_waits_summary_by_account_by_event_name.frm to <STDOUT>
  473. 170913 19:37:55 [01] ...done
  474. 170913 19:37:55 [01] Streaming ./performance_schema/socket_summary_by_event_name.frm to <STDOUT>
  475. 170913 19:37:55 [01] ...done
  476. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_summary_by_program.frm to <STDOUT>
  477. 170913 19:37:55 [01] ...done
  478. 170913 19:37:55 [01] Streaming ./performance_schema/replication_applier_status_by_worker.frm to <STDOUT>
  479. 170913 19:37:55 [01] ...done
  480. 170913 19:37:55 [01] Streaming ./performance_schema/accounts.frm to <STDOUT>
  481. 170913 19:37:55 [01] ...done
  482. 170913 19:37:55 [01] Streaming ./performance_schema/users.frm to <STDOUT>
  483. 170913 19:37:55 [01] ...done
  484. 170913 19:37:55 [01] Streaming ./performance_schema/events_waits_history_long.frm to <STDOUT>
  485. 170913 19:37:55 [01] ...done
  486. 170913 19:37:55 [01] Streaming ./performance_schema/mutex_instances.frm to <STDOUT>
  487. 170913 19:37:55 [01] ...done
  488. 170913 19:37:55 [01] Streaming ./performance_schema/rwlock_instances.frm to <STDOUT>
  489. 170913 19:37:55 [01] ...done
  490. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_summary_by_account_by_event_name.frm to <STDOUT>
  491. 170913 19:37:55 [01] ...done
  492. 170913 19:37:55 [01] Streaming ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to <STDOUT>
  493. 170913 19:37:55 [01] ...done
  494. 170913 19:37:55 [01] Streaming ./performance_schema/events_waits_summary_global_by_event_name.frm to <STDOUT>
  495. 170913 19:37:55 [01] ...done
  496. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_summary_global_by_event_name.frm to <STDOUT>
  497. 170913 19:37:55 [01] ...done
  498. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_summary_by_user_by_event_name.frm to <STDOUT>
  499. 170913 19:37:55 [01] ...done
  500. 170913 19:37:55 [01] Streaming ./performance_schema/setup_actors.frm to <STDOUT>
  501. 170913 19:37:55 [01] ...done
  502. 170913 19:37:55 [01] Streaming ./performance_schema/table_io_waits_summary_by_index_usage.frm to <STDOUT>
  503. 170913 19:37:55 [01] ...done
  504. 170913 19:37:55 [01] Streaming ./performance_schema/events_stages_summary_by_account_by_event_name.frm to <STDOUT>
  505. 170913 19:37:55 [01] ...done
  506. 170913 19:37:55 [01] Streaming ./performance_schema/replication_applier_status_by_coordinator.frm to <STDOUT>
  507. 170913 19:37:55 [01] ...done
  508. 170913 19:37:55 [01] Streaming ./performance_schema/file_summary_by_event_name.frm to <STDOUT>
  509. 170913 19:37:55 [01] ...done
  510. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_summary_by_digest.frm to <STDOUT>
  511. 170913 19:37:55 [01] ...done
  512. 170913 19:37:55 [01] Streaming ./performance_schema/socket_instances.frm to <STDOUT>
  513. 170913 19:37:55 [01] ...done
  514. 170913 19:37:55 [01] Streaming ./performance_schema/memory_summary_by_thread_by_event_name.frm to <STDOUT>
  515. 170913 19:37:55 [01] ...done
  516. 170913 19:37:55 [01] Streaming ./performance_schema/setup_objects.frm to <STDOUT>
  517. 170913 19:37:55 [01] ...done
  518. 170913 19:37:55 [01] Streaming ./performance_schema/session_status.frm to <STDOUT>
  519. 170913 19:37:55 [01] ...done
  520. 170913 19:37:55 [01] Streaming ./performance_schema/replication_group_member_stats.frm to <STDOUT>
  521. 170913 19:37:55 [01] ...done
  522. 170913 19:37:55 [01] Streaming ./performance_schema/replication_connection_configuration.frm to <STDOUT>
  523. 170913 19:37:55 [01] ...done
  524. 170913 19:37:55 [01] Streaming ./performance_schema/session_connect_attrs.frm to <STDOUT>
  525. 170913 19:37:55 [01] ...done
  526. 170913 19:37:55 [01] Streaming ./performance_schema/setup_consumers.frm to <STDOUT>
  527. 170913 19:37:55 [01] ...done
  528. 170913 19:37:55 [01] Streaming ./performance_schema/events_waits_summary_by_instance.frm to <STDOUT>
  529. 170913 19:37:55 [01] ...done
  530. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to <STDOUT>
  531. 170913 19:37:55 [01] ...done
  532. 170913 19:37:55 [01] Streaming ./performance_schema/memory_summary_global_by_event_name.frm to <STDOUT>
  533. 170913 19:37:55 [01] ...done
  534. 170913 19:37:55 [01] Streaming ./performance_schema/setup_instruments.frm to <STDOUT>
  535. 170913 19:37:55 [01] ...done
  536. 170913 19:37:55 [01] Streaming ./performance_schema/objects_summary_global_by_type.frm to <STDOUT>
  537. 170913 19:37:55 [01] ...done
  538. 170913 19:37:55 [01] Streaming ./performance_schema/memory_summary_by_user_by_event_name.frm to <STDOUT>
  539. 170913 19:37:55 [01] ...done
  540. 170913 19:37:55 [01] Streaming ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to <STDOUT>
  541. 170913 19:37:55 [01] ...done
  542. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_summary_by_host_by_event_name.frm to <STDOUT>
  543. 170913 19:37:55 [01] ...done
  544. 170913 19:37:55 [01] Streaming ./performance_schema/socket_summary_by_instance.frm to <STDOUT>
  545. 170913 19:37:55 [01] ...done
  546. 170913 19:37:55 [01] Streaming ./performance_schema/file_summary_by_instance.frm to <STDOUT>
  547. 170913 19:37:55 [01] ...done
  548. 170913 19:37:55 [01] Streaming ./performance_schema/variables_by_thread.frm to <STDOUT>
  549. 170913 19:37:55 [01] ...done
  550. 170913 19:37:55 [01] Streaming ./performance_schema/memory_summary_by_host_by_event_name.frm to <STDOUT>
  551. 170913 19:37:55 [01] ...done
  552. 170913 19:37:55 [01] Streaming ./performance_schema/global_variables.frm to <STDOUT>
  553. 170913 19:37:55 [01] ...done
  554. 170913 19:37:55 [01] Streaming ./performance_schema/replication_applier_configuration.frm to <STDOUT>
  555. 170913 19:37:55 [01] ...done
  556. 170913 19:37:55 [01] Streaming ./performance_schema/events_stages_summary_global_by_event_name.frm to <STDOUT>
  557. 170913 19:37:55 [01] ...done
  558. 170913 19:37:55 [01] Streaming ./performance_schema/events_stages_summary_by_host_by_event_name.frm to <STDOUT>
  559. 170913 19:37:55 [01] ...done
  560. 170913 19:37:55 [01] Streaming ./performance_schema/replication_group_members.frm to <STDOUT>
  561. 170913 19:37:55 [01] ...done
  562. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_current.frm to <STDOUT>
  563. 170913 19:37:55 [01] ...done
  564. 170913 19:37:55 [01] Streaming ./performance_schema/setup_timers.frm to <STDOUT>
  565. 170913 19:37:55 [01] ...done
  566. 170913 19:37:55 [01] Streaming ./performance_schema/session_account_connect_attrs.frm to <STDOUT>
  567. 170913 19:37:55 [01] ...done
  568. 170913 19:37:55 [01] Streaming ./performance_schema/host_cache.frm to <STDOUT>
  569. 170913 19:37:55 [01] ...done
  570. 170913 19:37:55 [01] Streaming ./performance_schema/table_lock_waits_summary_by_table.frm to <STDOUT>
  571. 170913 19:37:55 [01] ...done
  572. 170913 19:37:55 [01] Streaming ./performance_schema/events_statements_history.frm to <STDOUT>
  573. 170913 19:37:55 [01] ...done
  574. 170913 19:37:55 Finished backing up non-InnoDB tables and files
  575. 170913 19:37:55 [00] Streaming <STDOUT>
  576. 170913 19:37:55 [00] ...done
  577. 170913 19:37:55 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
  578. xtrabackup: The latest check point (for incremental): '2545234'
  579. 170913 19:37:55 >> log scanned up to (2545243)
  580. xtrabackup: Stopping log copying thread.
  581.  
  582. 170913 19:37:55 Executing UNLOCK TABLES
  583. 170913 19:37:55 All tables unlocked
  584. 170913 19:37:55 [00] Streaming ib_buffer_pool to <STDOUT>
  585. 170913 19:37:55 [00] ...done
  586. 170913 19:37:55 Backup created in directory '/var/lib/mysql/'
  587. MySQL binlog position: filename 'binlog.000001', position '2798', GTID of the last change 'a23999b1-9854-11e7-bf6a-080027075903:1-10'
  588. 170913 19:37:55 [00] Streaming <STDOUT>
  589. 170913 19:37:55 [00] ...done
  590. 170913 19:37:55 [00] Streaming <STDOUT>
  591. 170913 19:37:55 [00] ...done
  592. xtrabackup: Transaction log of lsn (2545234) to (2545243) was copied.
  593. 170913 19:37:55 completed OK!
  594. root@n2:/home/vagrant#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!