前言：相信大家对mysqldump应该不陌生，但是大家对mysqldump的原理及备份过程真的熟悉吗？今天，我们一起来深入理解一下mysqldump的备份原理及备份过程。

一、打开general_log

  1. root@localhost [(none)]>set global general_log=1;
  2. Query OK, 0 rows affected (0.00 sec)
  4. root@localhost [(none)]>show global variables like '%general%';
  5. +------------------+-----------------------------------+
  6. | Variable_name    | Value                             |
  7. +------------------+-----------------------------------+
  8. | general_log      | ON                                |
  9. | general_log_file | /storage/mysql/data/localhost.log |
  10. +------------------+-----------------------------------+
  11. 2 rows in set (0.00 sec)

二、开始备份

  1. /usr/local/mysql/bin/mysqldump -uroot -p -A --master-data=1 --single-transaction=1 >/tmp/dump.log

参数说明：

  1. -A备份全库

  2. master-data记录备份位置点

3.single-transaction避免锁表

三、查看general log

  1. /usr/local/mysql/bin/mysqld, Version: 5.7.20-log (MySQL Community Server (GPL)). started with:
  2. Tcp port: 3306  Unix socket: /tmp/mysql3306.sock
  3. Time                 Id Command    Argument
  4. 2018-04-16T02:49:57.340776Z        5 Connect    root@localhost on  using Socket
  5. 2018-04-16T02:49:57.340818Z        5 Query    /*!40100 SET @@SQL_MODE='' */
  6. 2018-04-16T02:49:57.340871Z        5 Query    /*!40103 SET TIME_ZONE='+00:00' */
  7. 2018-04-16T02:49:57.340985Z        5 Query    FLUSH /*!40101 LOCAL */ TABLES
  8. 2018-04-16T02:49:57.349781Z        5 Query    FLUSH TABLES WITH READ LOCK
  9. 2018-04-16T02:49:57.349874Z        5 Query    SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
  10. 2018-04-16T02:49:57.350204Z        5 Query    START TRANSACTION /*!40100 WITH CONSISTENT SNAPSHOT */
  11. 2018-04-16T02:49:57.350484Z        5 Query    SHOW VARIABLES LIKE 'gtid\_mode'
  12. 2018-04-16T02:49:57.352560Z        5 Query    SELECT @@GLOBAL.GTID_EXECUTED
  13. 2018-04-16T02:49:57.352665Z        5 Query    SHOW MASTER STATUS
  14. 2018-04-16T02:49:57.352708Z        5 Query    UNLOCK TABLES
  15. 2018-04-16T02:49:57.352781Z        5 Query    SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IS NOT NULL GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE, TOTAL_EXTENTS, INITIAL_SIZE ORDER BY LOGFILE_GROUP_NAME
  16. 2018-04-16T02:49:57.353360Z        5 Query    SELECT DISTINCT TABLESPACE_NAME, FILE_NAME, LOGFILE_GROUP_NAME, EXTENT_SIZE, INITIAL_SIZE, ENGINE FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' ORDER BY TABLESPACE_NAME, LOGFILE_GROUP_NAME
  17. 2018-04-16T02:49:57.354506Z        5 Query    SHOW DATABASES
  18. 2018-04-16T02:49:57.364135Z        5 Query    SHOW VARIABLES LIKE 'ndbinfo\_version'
  19. 2018-04-16T02:49:57.368598Z        5 Init DB    mysql
  20. 2018-04-16T02:49:57.368680Z        5 Query    SHOW CREATE DATABASE IF NOT EXISTS `mysql`
  21. 2018-04-16T02:49:57.368728Z        5 Query    SAVEPOINT sp
  22. 2018-04-16T02:49:57.368768Z        5 Query    show tables
  23. 2018-04-16T02:49:57.368954Z        5 Query    show table status like 'columns\_priv'
  24. 2018-04-16T02:49:57.369379Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  25. 2018-04-16T02:49:57.369422Z        5 Query    SET SESSION character_set_results = 'binary'
  26. 2018-04-16T02:49:57.369459Z        5 Query    show create table `columns_priv`
  27. 2018-04-16T02:49:57.369519Z        5 Query    SET SESSION character_set_results = 'utf8'
  28. 2018-04-16T02:49:57.369558Z        5 Query    show fields from `columns_priv`
  29. 2018-04-16T02:49:57.369794Z        5 Query    show fields from `columns_priv`
  30. 2018-04-16T02:49:57.370066Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `columns_priv`
  31. 2018-04-16T02:49:57.370157Z        5 Query    SET SESSION character_set_results = 'binary'
  32. 2018-04-16T02:49:57.370193Z        5 Query    use `mysql`
  33. 2018-04-16T02:49:57.370230Z        5 Query    select @@collation_database
  34. 2018-04-16T02:49:57.370275Z        5 Query    SHOW TRIGGERS LIKE 'columns\_priv'
  35. 2018-04-16T02:49:57.370552Z        5 Query    SET SESSION character_set_results = 'utf8'
  36. 2018-04-16T02:49:57.370599Z        5 Query    ROLLBACK TO SAVEPOINT sp
  37. 2018-04-16T02:49:57.370640Z        5 Query    show table status like 'db'
  38. 2018-04-16T02:49:57.371756Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  39. 2018-04-16T02:49:57.371809Z        5 Query    SET SESSION character_set_results = 'binary'
  40. 2018-04-16T02:49:57.371844Z        5 Query    show create table `db`
  41. 2018-04-16T02:49:57.371911Z        5 Query    SET SESSION character_set_results = 'utf8'
  42. 2018-04-16T02:49:57.371954Z        5 Query    show fields from `db`
  43. 2018-04-16T02:49:57.372316Z        5 Query    show fields from `db`
  44. 2018-04-16T02:49:57.372598Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `db`
  45. 2018-04-16T02:49:57.372722Z        5 Query    SET SESSION character_set_results = 'binary'
  46. 2018-04-16T02:49:57.372727Z        5 Query    use `mysql`
  47. 2018-04-16T02:49:57.372727Z        5 Query    select @@collation_database
  48. 2018-04-16T02:49:57.372751Z        5 Query    SHOW TRIGGERS LIKE 'db'
  49. 2018-04-16T02:49:57.373088Z        5 Query    SET SESSION character_set_results = 'utf8'
  50. 2018-04-16T02:49:57.373127Z        5 Query    ROLLBACK TO SAVEPOINT sp
  51. 2018-04-16T02:49:57.373163Z        5 Query    show table status like 'engine\_cost'
  52. 2018-04-16T02:49:57.373388Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  53. 2018-04-16T02:49:57.374807Z        5 Query    SET SESSION character_set_results = 'binary'
  54. 2018-04-16T02:49:57.375378Z        5 Query    show create table `engine_cost`
  55. 2018-04-16T02:49:57.375591Z        5 Query    SET SESSION character_set_results = 'utf8'
  56. 2018-04-16T02:49:57.375693Z        5 Query    show fields from `engine_cost`
  57. 2018-04-16T02:49:57.376387Z        5 Query    show fields from `engine_cost`
  58. 2018-04-16T02:49:57.376951Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `engine_cost`
  59. 2018-04-16T02:49:57.377090Z        5 Query    SET SESSION character_set_results = 'binary'
  60. 2018-04-16T02:49:57.377127Z        5 Query    use `mysql`
  61. 2018-04-16T02:49:57.377195Z        5 Query    select @@collation_database
  62. 2018-04-16T02:49:57.377240Z        5 Query    SHOW TRIGGERS LIKE 'engine\_cost'
  63. 2018-04-16T02:49:57.377532Z        5 Query    SET SESSION character_set_results = 'utf8'
  64. 2018-04-16T02:49:57.377567Z        5 Query    ROLLBACK TO SAVEPOINT sp
  65. 2018-04-16T02:49:57.377601Z        5 Query    show table status like 'event'
  66. 2018-04-16T02:49:57.377841Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  67. 2018-04-16T02:49:57.377871Z        5 Query    SET SESSION character_set_results = 'binary'
  68. 2018-04-16T02:49:57.378429Z        5 Query    show create table `event`
  69. 2018-04-16T02:49:57.378569Z        5 Query    SET SESSION character_set_results = 'utf8'
  70. 2018-04-16T02:49:57.378611Z        5 Query    show fields from `event`
  71. 2018-04-16T02:49:57.378923Z        5 Query    show fields from `event`
  72. 2018-04-16T02:49:57.379190Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `event`
  73. 2018-04-16T02:49:57.379292Z        5 Query    SET SESSION character_set_results = 'binary'
  74. 2018-04-16T02:49:57.379324Z        5 Query    use `mysql`
  75. 2018-04-16T02:49:57.379403Z        5 Query    select @@collation_database
  76. 2018-04-16T02:49:57.379445Z        5 Query    SHOW TRIGGERS LIKE 'event'
  77. 2018-04-16T02:49:57.379680Z        5 Query    SET SESSION character_set_results = 'utf8'
  78. 2018-04-16T02:49:57.379713Z        5 Query    ROLLBACK TO SAVEPOINT sp
  79. 2018-04-16T02:49:57.379745Z        5 Query    show table status like 'func'
  80. 2018-04-16T02:49:57.379848Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  81. 2018-04-16T02:49:57.379849Z        5 Query    SET SESSION character_set_results = 'binary'
  82. 2018-04-16T02:49:57.379849Z        5 Query    show create table `func`
  83. 2018-04-16T02:49:57.379864Z        5 Query    SET SESSION character_set_results = 'utf8'
  84. 2018-04-16T02:49:57.379901Z        5 Query    show fields from `func`
  85. 2018-04-16T02:49:57.380135Z        5 Query    show fields from `func`
  86. 2018-04-16T02:49:57.380326Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `func`
  87. 2018-04-16T02:49:57.380389Z        5 Query    SET SESSION character_set_results = 'binary'
  88. 2018-04-16T02:49:57.380418Z        5 Query    use `mysql`
  89. 2018-04-16T02:49:57.380787Z        5 Query    select @@collation_database
  90. 2018-04-16T02:49:57.380849Z        5 Query    SHOW TRIGGERS LIKE 'func'
  91. 2018-04-16T02:49:57.381077Z        5 Query    SET SESSION character_set_results = 'utf8'
  92. 2018-04-16T02:49:57.381110Z        5 Query    ROLLBACK TO SAVEPOINT sp
  93. 2018-04-16T02:49:57.381142Z        5 Query    show table status like 'help\_category'
  94. 2018-04-16T02:49:57.384920Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  95. 2018-04-16T02:49:57.385031Z        5 Query    SET SESSION character_set_results = 'binary'
  96. 2018-04-16T02:49:57.385074Z        5 Query    show create table `help_category`
  97. 2018-04-16T02:49:57.385153Z        5 Query    SET SESSION character_set_results = 'utf8'
  98. 2018-04-16T02:49:57.385209Z        5 Query    show fields from `help_category`
  99. 2018-04-16T02:49:57.385628Z        5 Query    show fields from `help_category`
  100. 2018-04-16T02:49:57.385867Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_category`
  101. 2018-04-16T02:49:57.386083Z        5 Query    SET SESSION character_set_results = 'binary'
  102. 2018-04-16T02:49:57.386124Z        5 Query    use `mysql`
  103. 2018-04-16T02:49:57.386164Z        5 Query    select @@collation_database
  104. 2018-04-16T02:49:57.386209Z        5 Query    SHOW TRIGGERS LIKE 'help\_category'
  105. 2018-04-16T02:49:57.386629Z        5 Query    SET SESSION character_set_results = 'utf8'
  106. 2018-04-16T02:49:57.386675Z        5 Query    ROLLBACK TO SAVEPOINT sp
  107. 2018-04-16T02:49:57.386715Z        5 Query    show table status like 'help\_keyword'
  108. 2018-04-16T02:49:57.388778Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  109. 2018-04-16T02:49:57.388845Z        5 Query    SET SESSION character_set_results = 'binary'
  110. 2018-04-16T02:49:57.389041Z        5 Query    show create table `help_keyword`
  111. 2018-04-16T02:49:57.390043Z        5 Query    SET SESSION character_set_results = 'utf8'
  112. 2018-04-16T02:49:57.390760Z        5 Query    show fields from `help_keyword`
  113. 2018-04-16T02:49:57.391227Z        5 Query    show fields from `help_keyword`
  114. 2018-04-16T02:49:57.391581Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_keyword`
  115. 2018-04-16T02:49:57.392486Z        5 Query    SET SESSION character_set_results = 'binary'
  116. 2018-04-16T02:49:57.392533Z        5 Query    use `mysql`
  117. 2018-04-16T02:49:57.392605Z        5 Query    select @@collation_database
  118. 2018-04-16T02:49:57.392656Z        5 Query    SHOW TRIGGERS LIKE 'help\_keyword'
  119. 2018-04-16T02:49:57.393672Z        5 Query    SET SESSION character_set_results = 'utf8'
  120. 2018-04-16T02:49:57.393727Z        5 Query    ROLLBACK TO SAVEPOINT sp
  121. 2018-04-16T02:49:57.393767Z        5 Query    show table status like 'help\_relation'
  122. 2018-04-16T02:49:57.395610Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  123. 2018-04-16T02:49:57.395676Z        5 Query    SET SESSION character_set_results = 'binary'
  124. 2018-04-16T02:49:57.395720Z        5 Query    show create table `help_relation`
  125. 2018-04-16T02:49:57.395786Z        5 Query    SET SESSION character_set_results = 'utf8'
  126. 2018-04-16T02:49:57.395833Z        5 Query    show fields from `help_relation`
  127. 2018-04-16T02:49:57.396137Z        5 Query    show fields from `help_relation`
  128. 2018-04-16T02:49:57.396362Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_relation`
  129. 2018-04-16T02:49:57.397177Z        5 Query    SET SESSION character_set_results = 'binary'
  130. 2018-04-16T02:49:57.397222Z        5 Query    use `mysql`
  131. 2018-04-16T02:49:57.397276Z        5 Query    select @@collation_database
  132. 2018-04-16T02:49:57.397320Z        5 Query    SHOW TRIGGERS LIKE 'help\_relation'
  133. 2018-04-16T02:49:57.397519Z        5 Query    SET SESSION character_set_results = 'utf8'
  134. 2018-04-16T02:49:57.397554Z        5 Query    ROLLBACK TO SAVEPOINT sp
  135. 2018-04-16T02:49:57.397587Z        5 Query    show table status like 'help\_topic'
  136. 2018-04-16T02:49:57.400086Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  137. 2018-04-16T02:49:57.400176Z        5 Query    SET SESSION character_set_results = 'binary'
  138. 2018-04-16T02:49:57.400221Z        5 Query    show create table `help_topic`
  139. 2018-04-16T02:49:57.400291Z        5 Query    SET SESSION character_set_results = 'utf8'
  140. 2018-04-16T02:49:57.400333Z        5 Query    show fields from `help_topic`
  141. 2018-04-16T02:49:57.400763Z        5 Query    show fields from `help_topic`
  142. 2018-04-16T02:49:57.400905Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_topic`
  143. 2018-04-16T02:49:57.412657Z        5 Query    SET SESSION character_set_results = 'binary'
  144. 2018-04-16T02:49:57.412714Z        5 Query    use `mysql`
  145. 2018-04-16T02:49:57.412778Z        5 Query    select @@collation_database
  146. 2018-04-16T02:49:57.412830Z        5 Query    SHOW TRIGGERS LIKE 'help\_topic'
  147. 2018-04-16T02:49:57.413155Z        5 Query    SET SESSION character_set_results = 'utf8'
  148. 2018-04-16T02:49:57.413190Z        5 Query    ROLLBACK TO SAVEPOINT sp
  149. 2018-04-16T02:49:57.413224Z        5 Query    show table status like 'innodb\_index\_stats'
  150. 2018-04-16T02:49:57.414208Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  151. 2018-04-16T02:49:57.414256Z        5 Query    SET SESSION character_set_results = 'binary'
  152. 2018-04-16T02:49:57.414291Z        5 Query    show create table `innodb_index_stats`
  153. 2018-04-16T02:49:57.414351Z        5 Query    SET SESSION character_set_results = 'utf8'
  154. 2018-04-16T02:49:57.414391Z        5 Query    show fields from `innodb_index_stats`
  155. 2018-04-16T02:49:57.414733Z        5 Query    show fields from `innodb_index_stats`
  156. 2018-04-16T02:49:57.415177Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `innodb_index_stats`
  157. 2018-04-16T02:49:57.415349Z        5 Query    SET SESSION character_set_results = 'binary'
  158. 2018-04-16T02:49:57.415629Z        5 Query    use `mysql`
  159. 2018-04-16T02:49:57.415718Z        5 Query    select @@collation_database
  160. 2018-04-16T02:49:57.415785Z        5 Query    SHOW TRIGGERS LIKE 'innodb\_index\_stats'
  161. 2018-04-16T02:49:57.416431Z        5 Query    SET SESSION character_set_results = 'utf8'
  162. 2018-04-16T02:49:57.416495Z        5 Query    ROLLBACK TO SAVEPOINT sp
  163. 2018-04-16T02:49:57.416540Z        5 Query    show table status like 'innodb\_table\_stats'
  164. 2018-04-16T02:49:57.418481Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  165. 2018-04-16T02:49:57.418611Z        5 Query    SET SESSION character_set_results = 'binary'
  166. 2018-04-16T02:49:57.418654Z        5 Query    show create table `innodb_table_stats`
  167. 2018-04-16T02:49:57.418718Z        5 Query    SET SESSION character_set_results = 'utf8'
  168. 2018-04-16T02:49:57.418759Z        5 Query    show fields from `innodb_table_stats`
  169. 2018-04-16T02:49:57.419108Z        5 Query    show fields from `innodb_table_stats`
  170. 2018-04-16T02:49:57.419338Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `innodb_table_stats`
  171. 2018-04-16T02:49:57.419560Z        5 Query    SET SESSION character_set_results = 'binary'
  172. 2018-04-16T02:49:57.419629Z        5 Query    use `mysql`
  173. 2018-04-16T02:49:57.419695Z        5 Query    select @@collation_database
  174. 2018-04-16T02:49:57.419745Z        5 Query    SHOW TRIGGERS LIKE 'innodb\_table\_stats'
  175. 2018-04-16T02:49:57.420213Z        5 Query    SET SESSION character_set_results = 'utf8'
  176. 2018-04-16T02:49:57.420256Z        5 Query    ROLLBACK TO SAVEPOINT sp
  177. 2018-04-16T02:49:57.420294Z        5 Query    show table status like 'ndb\_binlog\_index'
  178. 2018-04-16T02:49:57.421195Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  179. 2018-04-16T02:49:57.421241Z        5 Query    SET SESSION character_set_results = 'binary'
  180. 2018-04-16T02:49:57.421276Z        5 Query    show create table `ndb_binlog_index`
  181. 2018-04-16T02:49:57.421333Z        5 Query    SET SESSION character_set_results = 'utf8'
  182. 2018-04-16T02:49:57.421375Z        5 Query    show fields from `ndb_binlog_index`
  183. 2018-04-16T02:49:57.422813Z        5 Query    show fields from `ndb_binlog_index`
  184. 2018-04-16T02:49:57.424468Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `ndb_binlog_index`
  185. 2018-04-16T02:49:57.424712Z        5 Query    SET SESSION character_set_results = 'binary'
  186. 2018-04-16T02:49:57.424773Z        5 Query    use `mysql`
  187. 2018-04-16T02:49:57.424878Z        5 Query    select @@collation_database
  188. 2018-04-16T02:49:57.424999Z        5 Query    SHOW TRIGGERS LIKE 'ndb\_binlog\_index'
  189. 2018-04-16T02:49:57.425318Z        5 Query    SET SESSION character_set_results = 'utf8'
  190. 2018-04-16T02:49:57.425356Z        5 Query    ROLLBACK TO SAVEPOINT sp
  191. 2018-04-16T02:49:57.425391Z        5 Query    show table status like 'plugin'
  192. 2018-04-16T02:49:57.425760Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  193. 2018-04-16T02:49:57.425794Z        5 Query    SET SESSION character_set_results = 'binary'
  194. 2018-04-16T02:49:57.425825Z        5 Query    show create table `plugin`
  195. 2018-04-16T02:49:57.426179Z        5 Query    SET SESSION character_set_results = 'utf8'
  196. 2018-04-16T02:49:57.426265Z        5 Query    show fields from `plugin`
  197. 2018-04-16T02:49:57.426597Z        5 Query    show fields from `plugin`
  198. 2018-04-16T02:49:57.426793Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `plugin`
  199. 2018-04-16T02:49:57.426883Z        5 Query    SET SESSION character_set_results = 'binary'
  200. 2018-04-16T02:49:57.426884Z        5 Query    use `mysql`
  201. 2018-04-16T02:49:57.426884Z        5 Query    select @@collation_database
  202. 2018-04-16T02:49:57.426884Z        5 Query    SHOW TRIGGERS LIKE 'plugin'
  203. 2018-04-16T02:49:57.427096Z        5 Query    SET SESSION character_set_results = 'utf8'
  204. 2018-04-16T02:49:57.427134Z        5 Query    ROLLBACK TO SAVEPOINT sp
  205. 2018-04-16T02:49:57.427170Z        5 Query    show table status like 'proc'
  206. 2018-04-16T02:49:57.428638Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  207. 2018-04-16T02:49:57.428694Z        5 Query    SET SESSION character_set_results = 'binary'
  208. 2018-04-16T02:49:57.428734Z        5 Query    show create table `proc`
  209. 2018-04-16T02:49:57.428818Z        5 Query    SET SESSION character_set_results = 'utf8'
  210. 2018-04-16T02:49:57.428866Z        5 Query    show fields from `proc`
  211. 2018-04-16T02:49:57.429295Z        5 Query    show fields from `proc`
  212. 2018-04-16T02:49:57.429672Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `proc` WHERE db != 'sys'
  213. 2018-04-16T02:49:57.429860Z        5 Query    SET SESSION character_set_results = 'binary'
  214. 2018-04-16T02:49:57.429897Z        5 Query    use `mysql`
  215. 2018-04-16T02:49:57.429934Z        5 Query    select @@collation_database
  216. 2018-04-16T02:49:57.429939Z        5 Query    SHOW TRIGGERS LIKE 'proc'
  217. 2018-04-16T02:49:57.430000Z        5 Query    SET SESSION character_set_results = 'utf8'
  218. 2018-04-16T02:49:57.430057Z        5 Query    ROLLBACK TO SAVEPOINT sp
  219. 2018-04-16T02:49:57.430095Z        5 Query    show table status like 'procs\_priv'
  220. 2018-04-16T02:49:57.430342Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  221. 2018-04-16T02:49:57.430373Z        5 Query    SET SESSION character_set_results = 'binary'
  222. 2018-04-16T02:49:57.430403Z        5 Query    show create table `procs_priv`
  223. 2018-04-16T02:49:57.431264Z        5 Query    SET SESSION character_set_results = 'utf8'
  224. 2018-04-16T02:49:57.431416Z        5 Query    show fields from `procs_priv`
  225. 2018-04-16T02:49:57.431870Z        5 Query    show fields from `procs_priv`
  226. 2018-04-16T02:49:57.433097Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `procs_priv`
  227. 2018-04-16T02:49:57.433253Z        5 Query    SET SESSION character_set_results = 'binary'
  228. 2018-04-16T02:49:57.433300Z        5 Query    use `mysql`
  229. 2018-04-16T02:49:57.433432Z        5 Query    select @@collation_database
  230. 2018-04-16T02:49:57.433494Z        5 Query    SHOW TRIGGERS LIKE 'procs\_priv'
  231. 2018-04-16T02:49:57.433814Z        5 Query    SET SESSION character_set_results = 'utf8'
  232. 2018-04-16T02:49:57.433814Z        5 Query    ROLLBACK TO SAVEPOINT sp
  233. 2018-04-16T02:49:57.433815Z        5 Query    show table status like 'proxies\_priv'
  234. 2018-04-16T02:49:57.435368Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  235. 2018-04-16T02:49:57.435477Z        5 Query    SET SESSION character_set_results = 'binary'
  236. 2018-04-16T02:49:57.435579Z        5 Query    show create table `proxies_priv`
  237. 2018-04-16T02:49:57.435670Z        5 Query    SET SESSION character_set_results = 'utf8'
  238. 2018-04-16T02:49:57.435717Z        5 Query    show fields from `proxies_priv`
  239. 2018-04-16T02:49:57.436327Z        5 Query    show fields from `proxies_priv`
  240. 2018-04-16T02:49:57.436630Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `proxies_priv`
  241. 2018-04-16T02:49:57.436729Z        5 Query    SET SESSION character_set_results = 'binary'
  242. 2018-04-16T02:49:57.436764Z        5 Query    use `mysql`
  243. 2018-04-16T02:49:57.436835Z        5 Query    select @@collation_database
  244. 2018-04-16T02:49:57.436882Z        5 Query    SHOW TRIGGERS LIKE 'proxies\_priv'
  245. 2018-04-16T02:49:57.438374Z        5 Query    SET SESSION character_set_results = 'utf8'
  246. 2018-04-16T02:49:57.438730Z        5 Query    ROLLBACK TO SAVEPOINT sp
  247. 2018-04-16T02:49:57.438807Z        5 Query    show table status like 'server\_cost'
  248. 2018-04-16T02:49:57.440420Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  249. 2018-04-16T02:49:57.440483Z        5 Query    SET SESSION character_set_results = 'binary'
  250. 2018-04-16T02:49:57.440521Z        5 Query    show create table `server_cost`
  251. 2018-04-16T02:49:57.440570Z        5 Query    SET SESSION character_set_results = 'utf8'
  252. 2018-04-16T02:49:57.440598Z        5 Query    show fields from `server_cost`
  253. 2018-04-16T02:49:57.440855Z        5 Query    show fields from `server_cost`
  254. 2018-04-16T02:49:57.441196Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `server_cost`
  255. 2018-04-16T02:49:57.441313Z        5 Query    SET SESSION character_set_results = 'binary'
  256. 2018-04-16T02:49:57.441345Z        5 Query    use `mysql`
  257. 2018-04-16T02:49:57.441402Z        5 Query    select @@collation_database
  258. 2018-04-16T02:49:57.441445Z        5 Query    SHOW TRIGGERS LIKE 'server\_cost'
  259. 2018-04-16T02:49:57.441618Z        5 Query    SET SESSION character_set_results = 'utf8'
  260. 2018-04-16T02:49:57.441657Z        5 Query    ROLLBACK TO SAVEPOINT sp
  261. 2018-04-16T02:49:57.441691Z        5 Query    show table status like 'servers'
  262. 2018-04-16T02:49:57.441957Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  263. 2018-04-16T02:49:57.441995Z        5 Query    SET SESSION character_set_results = 'binary'
  264. 2018-04-16T02:49:57.442026Z        5 Query    show create table `servers`
  265. 2018-04-16T02:49:57.442081Z        5 Query    SET SESSION character_set_results = 'utf8'
  266. 2018-04-16T02:49:57.442117Z        5 Query    show fields from `servers`
  267. 2018-04-16T02:49:57.442334Z        5 Query    show fields from `servers`
  268. 2018-04-16T02:49:57.442555Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `servers`
  269. 2018-04-16T02:49:57.442637Z        5 Query    SET SESSION character_set_results = 'binary'
  270. 2018-04-16T02:49:57.442668Z        5 Query    use `mysql`
  271. 2018-04-16T02:49:57.442699Z        5 Query    select @@collation_database
  272. 2018-04-16T02:49:57.442745Z        5 Query    SHOW TRIGGERS LIKE 'servers'
  273. 2018-04-16T02:49:57.443624Z        5 Query    SET SESSION character_set_results = 'utf8'
  274. 2018-04-16T02:49:57.443666Z        5 Query    ROLLBACK TO SAVEPOINT sp
  275. 2018-04-16T02:49:57.443701Z        5 Query    show table status like 'slave\_master\_info'
  276. 2018-04-16T02:49:57.443942Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  277. 2018-04-16T02:49:57.443972Z        5 Query    SET SESSION character_set_results = 'binary'
  278. 2018-04-16T02:49:57.444000Z        5 Query    show create table `slave_master_info`
  279. 2018-04-16T02:49:57.444069Z        5 Query    SET SESSION character_set_results = 'utf8'
  280. 2018-04-16T02:49:57.444107Z        5 Query    show fields from `slave_master_info`
  281. 2018-04-16T02:49:57.444471Z        5 Query    show fields from `slave_master_info`
  282. 2018-04-16T02:49:57.444756Z        5 Query    SET SESSION character_set_results = 'binary'
  283. 2018-04-16T02:49:57.444801Z        5 Query    use `mysql`
  284. 2018-04-16T02:49:57.444841Z        5 Query    select @@collation_database
  285. 2018-04-16T02:49:57.444841Z        5 Query    SHOW TRIGGERS LIKE 'slave\_master\_info'
  286. 2018-04-16T02:49:57.445007Z        5 Query    SET SESSION character_set_results = 'utf8'
  287. 2018-04-16T02:49:57.445041Z        5 Query    ROLLBACK TO SAVEPOINT sp
  288. 2018-04-16T02:49:57.445076Z        5 Query    show table status like 'slave\_relay\_log\_info'
  289. 2018-04-16T02:49:57.445295Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  290. 2018-04-16T02:49:57.445326Z        5 Query    SET SESSION character_set_results = 'binary'
  291. 2018-04-16T02:49:57.445355Z        5 Query    show create table `slave_relay_log_info`
  292. 2018-04-16T02:49:57.445484Z        5 Query    SET SESSION character_set_results = 'utf8'
  293. 2018-04-16T02:49:57.446157Z        5 Query    show fields from `slave_relay_log_info`
  294. 2018-04-16T02:49:57.446517Z        5 Query    show fields from `slave_relay_log_info`
  295. 2018-04-16T02:49:57.446748Z        5 Query    SET SESSION character_set_results = 'binary'
  296. 2018-04-16T02:49:57.446790Z        5 Query    use `mysql`
  297. 2018-04-16T02:49:57.446847Z        5 Query    select @@collation_database
  298. 2018-04-16T02:49:57.446891Z        5 Query    SHOW TRIGGERS LIKE 'slave\_relay\_log\_info'
  299. 2018-04-16T02:49:57.447298Z        5 Query    SET SESSION character_set_results = 'utf8'
  300. 2018-04-16T02:49:57.447340Z        5 Query    ROLLBACK TO SAVEPOINT sp
  301. 2018-04-16T02:49:57.447378Z        5 Query    show table status like 'slave\_worker\_info'
  302. 2018-04-16T02:49:57.447675Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  303. 2018-04-16T02:49:57.447719Z        5 Query    SET SESSION character_set_results = 'binary'
  304. 2018-04-16T02:49:57.447752Z        5 Query    show create table `slave_worker_info`
  305. 2018-04-16T02:49:57.447813Z        5 Query    SET SESSION character_set_results = 'utf8'
  306. 2018-04-16T02:49:57.447852Z        5 Query    show fields from `slave_worker_info`
  307. 2018-04-16T02:49:57.448127Z        5 Query    show fields from `slave_worker_info`
  308. 2018-04-16T02:49:57.448359Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `slave_worker_info`
  309. 2018-04-16T02:49:57.448482Z        5 Query    SET SESSION character_set_results = 'binary'
  310. 2018-04-16T02:49:57.448517Z        5 Query    use `mysql`
  311. 2018-04-16T02:49:57.448553Z        5 Query    select @@collation_database
  312. 2018-04-16T02:49:57.448594Z        5 Query    SHOW TRIGGERS LIKE 'slave\_worker\_info'
  313. 2018-04-16T02:49:57.448852Z        5 Query    SET SESSION character_set_results = 'utf8'
  314. 2018-04-16T02:49:57.448888Z        5 Query    ROLLBACK TO SAVEPOINT sp
  315. 2018-04-16T02:49:57.449222Z        5 Query    show table status like 'tables\_priv'
  316. 2018-04-16T02:49:57.449777Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  317. 2018-04-16T02:49:57.450515Z        5 Query    SET SESSION character_set_results = 'binary'
  318. 2018-04-16T02:49:57.450641Z        5 Query    show create table `tables_priv`
  319. 2018-04-16T02:49:57.450713Z        5 Query    SET SESSION character_set_results = 'utf8'
  320. 2018-04-16T02:49:57.450759Z        5 Query    show fields from `tables_priv`
  321. 2018-04-16T02:49:57.451428Z        5 Query    show fields from `tables_priv`
  322. 2018-04-16T02:49:57.451749Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `tables_priv`
  323. 2018-04-16T02:49:57.451883Z        5 Query    SET SESSION character_set_results = 'binary'
  324. 2018-04-16T02:49:57.451920Z        5 Query    use `mysql`
  325. 2018-04-16T02:49:57.451989Z        5 Query    select @@collation_database
  326. 2018-04-16T02:49:57.452034Z        5 Query    SHOW TRIGGERS LIKE 'tables\_priv'
  327. 2018-04-16T02:49:57.452498Z        5 Query    SET SESSION character_set_results = 'utf8'
  328. 2018-04-16T02:49:57.452541Z        5 Query    ROLLBACK TO SAVEPOINT sp
  329. 2018-04-16T02:49:57.452580Z        5 Query    show table status like 'time\_zone'
  330. 2018-04-16T02:49:57.455651Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  331. 2018-04-16T02:49:57.455777Z        5 Query    SET SESSION character_set_results = 'binary'
  332. 2018-04-16T02:49:57.455825Z        5 Query    show create table `time_zone`
  333. 2018-04-16T02:49:57.455956Z        5 Query    SET SESSION character_set_results = 'utf8'
  334. 2018-04-16T02:49:57.456006Z        5 Query    show fields from `time_zone`
  335. 2018-04-16T02:49:57.456323Z        5 Query    show fields from `time_zone`
  336. 2018-04-16T02:49:57.456736Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone`
  337. 2018-04-16T02:49:57.456849Z        5 Query    SET SESSION character_set_results = 'binary'
  338. 2018-04-16T02:49:57.456855Z        5 Query    use `mysql`
  339. 2018-04-16T02:49:57.456855Z        5 Query    select @@collation_database
  340. 2018-04-16T02:49:57.456856Z        5 Query    SHOW TRIGGERS LIKE 'time\_zone'
  341. 2018-04-16T02:49:57.457149Z        5 Query    SET SESSION character_set_results = 'utf8'
  342. 2018-04-16T02:49:57.457187Z        5 Query    ROLLBACK TO SAVEPOINT sp
  343. 2018-04-16T02:49:57.457224Z        5 Query    show table status like 'time\_zone\_leap\_second'
  344. 2018-04-16T02:49:57.458266Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  345. 2018-04-16T02:49:57.458307Z        5 Query    SET SESSION character_set_results = 'binary'
  346. 2018-04-16T02:49:57.458339Z        5 Query    show create table `time_zone_leap_second`
  347. 2018-04-16T02:49:57.458390Z        5 Query    SET SESSION character_set_results = 'utf8'
  348. 2018-04-16T02:49:57.458429Z        5 Query    show fields from `time_zone_leap_second`
  349. 2018-04-16T02:49:57.458669Z        5 Query    show fields from `time_zone_leap_second`
  350. 2018-04-16T02:49:57.458944Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_leap_second`
  351. 2018-04-16T02:49:57.459037Z        5 Query    SET SESSION character_set_results = 'binary'
  352. 2018-04-16T02:49:57.459072Z        5 Query    use `mysql`
  353. 2018-04-16T02:49:57.459131Z        5 Query    select @@collation_database
  354. 2018-04-16T02:49:57.459176Z        5 Query    SHOW TRIGGERS LIKE 'time\_zone\_leap\_second'
  355. 2018-04-16T02:49:57.459458Z        5 Query    SET SESSION character_set_results = 'utf8'
  356. 2018-04-16T02:49:57.459495Z        5 Query    ROLLBACK TO SAVEPOINT sp
  357. 2018-04-16T02:49:57.459530Z        5 Query    show table status like 'time\_zone\_name'
  358. 2018-04-16T02:49:57.459741Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  359. 2018-04-16T02:49:57.459772Z        5 Query    SET SESSION character_set_results = 'binary'
  360. 2018-04-16T02:49:57.459802Z        5 Query    show create table `time_zone_name`
  361. 2018-04-16T02:49:57.459849Z        5 Query    SET SESSION character_set_results = 'utf8'
  362. 2018-04-16T02:49:57.460361Z        5 Query    show fields from `time_zone_name`
  363. 2018-04-16T02:49:57.460729Z        5 Query    show fields from `time_zone_name`
  364. 2018-04-16T02:49:57.460977Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_name`
  365. 2018-04-16T02:49:57.461111Z        5 Query    SET SESSION character_set_results = 'binary'
  366. 2018-04-16T02:49:57.461148Z        5 Query    use `mysql`
  367. 2018-04-16T02:49:57.461213Z        5 Query    select @@collation_database
  368. 2018-04-16T02:49:57.461257Z        5 Query    SHOW TRIGGERS LIKE 'time\_zone\_name'
  369. 2018-04-16T02:49:57.461533Z        5 Query    SET SESSION character_set_results = 'utf8'
  370. 2018-04-16T02:49:57.461569Z        5 Query    ROLLBACK TO SAVEPOINT sp
  371. 2018-04-16T02:49:57.461604Z        5 Query    show table status like 'time\_zone\_transition'
  372. 2018-04-16T02:49:57.461810Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  373. 2018-04-16T02:49:57.461842Z        5 Query    SET SESSION character_set_results = 'binary'
  374. 2018-04-16T02:49:57.461871Z        5 Query    show create table `time_zone_transition`
  375. 2018-04-16T02:49:57.461918Z        5 Query    SET SESSION character_set_results = 'utf8'
  376. 2018-04-16T02:49:57.461918Z        5 Query    show fields from `time_zone_transition`
  377. 2018-04-16T02:49:57.461921Z        5 Query    show fields from `time_zone_transition`
  378. 2018-04-16T02:49:57.462092Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_transition`
  379. 2018-04-16T02:49:57.462181Z        5 Query    SET SESSION character_set_results = 'binary'
  380. 2018-04-16T02:49:57.462212Z        5 Query    use `mysql`
  381. 2018-04-16T02:49:57.462244Z        5 Query    select @@collation_database
  382. 2018-04-16T02:49:57.462284Z        5 Query    SHOW TRIGGERS LIKE 'time\_zone\_transition'
  383. 2018-04-16T02:49:57.463295Z        5 Query    SET SESSION character_set_results = 'utf8'
  384. 2018-04-16T02:49:57.463396Z        5 Query    ROLLBACK TO SAVEPOINT sp
  385. 2018-04-16T02:49:57.463433Z        5 Query    show table status like 'time\_zone\_transition\_type'
  386. 2018-04-16T02:49:57.463626Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  387. 2018-04-16T02:49:57.463666Z        5 Query    SET SESSION character_set_results = 'binary'
  388. 2018-04-16T02:49:57.463697Z        5 Query    show create table `time_zone_transition_type`
  389. 2018-04-16T02:49:57.463752Z        5 Query    SET SESSION character_set_results = 'utf8'
  390. 2018-04-16T02:49:57.463789Z        5 Query    show fields from `time_zone_transition_type`
  391. 2018-04-16T02:49:57.464036Z        5 Query    show fields from `time_zone_transition_type`
  392. 2018-04-16T02:49:57.464262Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_transition_type`
  393. 2018-04-16T02:49:57.464358Z        5 Query    SET SESSION character_set_results = 'binary'
  394. 2018-04-16T02:49:57.464392Z        5 Query    use `mysql`
  395. 2018-04-16T02:49:57.464427Z        5 Query    select @@collation_database
  396. 2018-04-16T02:49:57.464468Z        5 Query    SHOW TRIGGERS LIKE 'time\_zone\_transition\_type'
  397. 2018-04-16T02:49:57.464708Z        5 Query    SET SESSION character_set_results = 'utf8'
  398. 2018-04-16T02:49:57.464749Z        5 Query    ROLLBACK TO SAVEPOINT sp
  399. 2018-04-16T02:49:57.464784Z        5 Query    show table status like 'user'
  400. 2018-04-16T02:49:57.465133Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  401. 2018-04-16T02:49:57.465173Z        5 Query    SET SESSION character_set_results = 'binary'
  402. 2018-04-16T02:49:57.465208Z        5 Query    show create table `user`
  403. 2018-04-16T02:49:57.465314Z        5 Query    SET SESSION character_set_results = 'utf8'
  404. 2018-04-16T02:49:57.465363Z        5 Query    show fields from `user`
  405. 2018-04-16T02:49:57.467603Z        5 Query    show fields from `user`
  406. 2018-04-16T02:49:57.468580Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `user`
  407. 2018-04-16T02:49:57.469348Z        5 Query    SET SESSION character_set_results = 'binary'
  408. 2018-04-16T02:49:57.469395Z        5 Query    use `mysql`
  409. 2018-04-16T02:49:57.469460Z        5 Query    select @@collation_database
  410. 2018-04-16T02:49:57.469517Z        5 Query    SHOW TRIGGERS LIKE 'user'
  411. 2018-04-16T02:49:57.472364Z        5 Query    SET SESSION character_set_results = 'utf8'
  412. 2018-04-16T02:49:57.472569Z        5 Query    ROLLBACK TO SAVEPOINT sp
  413. 2018-04-16T02:49:57.472638Z        5 Query    RELEASE SAVEPOINT sp
  414. 2018-04-16T02:49:57.472651Z        5 Query    show table status like 'general\_log'
  415. 2018-04-16T02:49:57.473893Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  416. 2018-04-16T02:49:57.473946Z        5 Query    SET SESSION character_set_results = 'binary'
  417. 2018-04-16T02:49:57.473982Z        5 Query    show create table `general_log`
  418. 2018-04-16T02:49:57.474126Z        5 Query    SET SESSION character_set_results = 'utf8'
  419. 2018-04-16T02:49:57.474189Z        5 Query    show fields from `general_log`
  420. 2018-04-16T02:49:57.474473Z        5 Query    show fields from `general_log`
  421. 2018-04-16T02:49:57.474704Z        5 Query    show table status like 'slow\_log'
  422. 2018-04-16T02:49:57.476210Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  423. 2018-04-16T02:49:57.476262Z        5 Query    SET SESSION character_set_results = 'binary'
  424. 2018-04-16T02:49:57.476301Z        5 Query    show create table `slow_log`
  425. 2018-04-16T02:49:57.476366Z        5 Query    SET SESSION character_set_results = 'utf8'
  426. 2018-04-16T02:49:57.476412Z        5 Query    show fields from `slow_log`
  427. 2018-04-16T02:49:57.477747Z        5 Query    show fields from `slow_log`
  428. 2018-04-16T02:49:57.478026Z        5 Init DB    xucl
  429. 2018-04-16T02:49:57.478063Z        5 Query    SHOW CREATE DATABASE IF NOT EXISTS `xucl`
  430. 2018-04-16T02:49:57.478122Z        5 Query    SAVEPOINT sp
  431. 2018-04-16T02:49:57.478156Z        5 Query    show tables
  432. 2018-04-16T02:49:57.478277Z        5 Query    show table status like 't'
  433. 2018-04-16T02:49:57.484854Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  434. 2018-04-16T02:49:57.484946Z        5 Query    SET SESSION character_set_results = 'binary'
  435. 2018-04-16T02:49:57.484994Z        5 Query    show create table `t`
  436. 2018-04-16T02:49:57.485053Z        5 Query    SET SESSION character_set_results = 'utf8'
  437. 2018-04-16T02:49:57.485177Z        5 Query    show fields from `t`
  438. 2018-04-16T02:49:57.485452Z        5 Query    show fields from `t`
  439. 2018-04-16T02:49:57.485643Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `t`
  440. 2018-04-16T02:49:57.485738Z        5 Query    SET SESSION character_set_results = 'binary'
  441. 2018-04-16T02:49:57.485745Z        5 Query    use `xucl`
  442. 2018-04-16T02:49:57.485746Z        5 Query    select @@collation_database
  443. 2018-04-16T02:49:57.485746Z        5 Query    SHOW TRIGGERS LIKE 't'
  444. 2018-04-16T02:49:57.486028Z        5 Query    SET SESSION character_set_results = 'utf8'
  445. 2018-04-16T02:49:57.486073Z        5 Query    ROLLBACK TO SAVEPOINT sp
  446. 2018-04-16T02:49:57.486116Z        5 Query    show table status like 't1'
  447. 2018-04-16T02:49:57.487247Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  448. 2018-04-16T02:49:57.487404Z        5 Query    SET SESSION character_set_results = 'binary'
  449. 2018-04-16T02:49:57.487475Z        5 Query    show create table `t1`
  450. 2018-04-16T02:49:57.487572Z        5 Query    SET SESSION character_set_results = 'utf8'
  451. 2018-04-16T02:49:57.487674Z        5 Query    show fields from `t1`
  452. 2018-04-16T02:49:57.487929Z        5 Query    show fields from `t1`
  453. 2018-04-16T02:49:57.488236Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `t1`
  454. 2018-04-16T02:49:57.490837Z        5 Query    SET SESSION character_set_results = 'binary'
  455. 2018-04-16T02:49:57.491087Z        5 Query    use `xucl`
  456. 2018-04-16T02:49:57.491188Z        5 Query    select @@collation_database
  457. 2018-04-16T02:49:57.491258Z        5 Query    SHOW TRIGGERS LIKE 't1'
  458. 2018-04-16T02:49:57.491863Z        5 Query    SET SESSION character_set_results = 'utf8'
  459. 2018-04-16T02:49:57.491863Z        5 Query    ROLLBACK TO SAVEPOINT sp
  460. 2018-04-16T02:49:57.491864Z        5 Query    show table status like 'user'
  461. 2018-04-16T02:49:57.493604Z        5 Query    SET SQL_QUOTE_SHOW_CREATE=1
  462. 2018-04-16T02:49:57.493662Z        5 Query    SET SESSION character_set_results = 'binary'
  463. 2018-04-16T02:49:57.493702Z        5 Query    show create table `user`
  464. 2018-04-16T02:49:57.493806Z        5 Query    SET SESSION character_set_results = 'utf8'
  465. 2018-04-16T02:49:57.493854Z        5 Query    show fields from `user`
  466. 2018-04-16T02:49:57.494333Z        5 Query    show fields from `user`
  467. 2018-04-16T02:49:57.494698Z        5 Query    SELECT /*!40001 SQL_NO_CACHE */ * FROM `user`
  468. 2018-04-16T02:49:57.495340Z        5 Query    SET SESSION character_set_results = 'binary'
  469. 2018-04-16T02:49:57.495385Z        5 Query    use `xucl`
  470. 2018-04-16T02:49:57.495499Z        5 Query    select @@collation_database
  471. 2018-04-16T02:49:57.495581Z        5 Query    SHOW TRIGGERS LIKE 'user'
  472. 2018-04-16T02:49:57.495871Z        5 Query    SET SESSION character_set_results = 'utf8'
  473. 2018-04-16T02:49:57.495909Z        5 Query    ROLLBACK TO SAVEPOINT sp
  474. 2018-04-16T02:49:57.495965Z        5 Query    RELEASE SAVEPOINT sp
  475. 2018-04-16T02:49:57.506959Z        5 Quit

4.解析备份过程

通过general log可以看到，首先进行的是FLUSH TABLES操作，即关闭所有打开的表，然后给所有表加上只读锁，接着开启更改会话级隔离等级为RR，开启一致性快照，获取复制信息，释放全局读锁，然后就是结合save point一个表一个表导出数据，只到最后结束，断开连接，原事务中止。
结合下面的流程图看就比较清晰了：

【MySQL】深入理解mysqldump过程 - 图1