查看mysqldump整个过程

set global general_log=on;
复制

MySQL [(none)]> show variables like '%gen%';
+------------------+---------------------+
| Variable_name    | Value               |
+------------------+---------------------+
| general_log      | ON                  |
| general_log_file | /data/mysql/myk.log |
+------------------+---------------------+


复制

mysqldump omp > omp.sql
复制

2021-02-02T17:30:55.758722+08:00          143 Connect   root@localhost on  using Socket
2021-02-02T17:30:55.759116+08:00          143 Query     /*!40100 SET @@SQL_MODE='' */
2021-02-02T17:30:55.759515+08:00          143 Query     /*!40103 SET TIME_ZONE='+00:00' */
2021-02-02T17:30:55.759866+08:00          143 Query     SHOW VARIABLES LIKE 'gtid\_mode'
2021-02-02T17:30:55.764310+08:00          143 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 AND LOGFILE_GROUP_NAME IN (SELECT DISTINCT LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('omp'))) GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE, TOTAL_EXTENTS, INITIAL_SIZE ORDER BY LOGFILE_GROUP_NAME
2021-02-02T17:30:55.775402+08:00          143 Query     SELECT DISTINCT TABLESPACE_NAME, FILE_NAME, LOGFILE_GROUP_NAME, EXTENT_SIZE, INITIAL_SIZE, ENGINE FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('omp')) ORDER BY TABLESPACE_NAME, LOGFILE_GROUP_NAME
2021-02-02T17:30:55.780200+08:00          143 Query     SHOW VARIABLES LIKE 'ndbinfo\_version'
2021-02-02T17:30:55.782856+08:00          143 Init DB   omp
2021-02-02T17:30:55.783241+08:00          143 Query     show tables
2021-02-02T17:30:55.783822+08:00          143 Query     LOCK TABLES `t_omp_i18n` READ /*!32311 LOCAL */,`t_omp_key` READ /*!32311 LOCAL */
2021-02-02T17:30:55.784545+08:00          143 Query     show table status like 't\_omp\_i18n'
2021-02-02T17:30:55.785290+08:00          143 Query     SET SQL_QUOTE_SHOW_CREATE=1
2021-02-02T17:30:55.785643+08:00          143 Query     SET SESSION character_set_results = 'binary'
2021-02-02T17:30:55.786039+08:00          143 Query     show create table `t_omp_i18n`
2021-02-02T17:30:55.786477+08:00          143 Query     SET SESSION character_set_results = 'utf8'
2021-02-02T17:30:55.786824+08:00          143 Query     show fields from `t_omp_i18n`
2021-02-02T17:30:55.787957+08:00          143 Query     show fields from `t_omp_i18n`
2021-02-02T17:30:55.789038+08:00          143 Query     SELECT /*!40001 SQL_NO_CACHE */ * FROM `t_omp_i18n`
2021-02-02T17:30:55.887486+08:00          143 Query     SET SESSION character_set_results = 'binary'
2021-02-02T17:30:55.887728+08:00          143 Query     use `omp`
2021-02-02T17:30:55.887980+08:00          143 Query     select @@collation_database
2021-02-02T17:30:55.888215+08:00          143 Query     SHOW TRIGGERS LIKE 't\_omp\_i18n'
2021-02-02T17:30:55.889025+08:00          143 Query     SET SESSION character_set_results = 'utf8'
2021-02-02T17:30:55.889227+08:00          143 Query     show table status like 't\_omp\_key'
2021-02-02T17:30:55.889709+08:00          143 Query     SET SQL_QUOTE_SHOW_CREATE=1
2021-02-02T17:30:55.889867+08:00          143 Query     SET SESSION character_set_results = 'binary'
2021-02-02T17:30:55.890045+08:00          143 Query     show create table `t_omp_key`
2021-02-02T17:30:55.890283+08:00          143 Query     SET SESSION character_set_results = 'utf8'
2021-02-02T17:30:55.890478+08:00          143 Query     show fields from `t_omp_key`
2021-02-02T17:30:55.891365+08:00          143 Query     show fields from `t_omp_key`
2021-02-02T17:30:55.892211+08:00          143 Query     SELECT /*!40001 SQL_NO_CACHE */ * FROM `t_omp_key`
2021-02-02T17:30:55.986112+08:00          143 Query     SET SESSION character_set_results = 'binary'
2021-02-02T17:30:55.986355+08:00          143 Query     use `omp`
2021-02-02T17:30:55.986663+08:00          143 Query     select @@collation_database
2021-02-02T17:30:55.986878+08:00          143 Query     SHOW TRIGGERS LIKE 't\_omp\_key'
2021-02-02T17:30:55.987708+08:00          143 Query     SET SESSION character_set_results = 'utf8'
2021-02-02T17:30:55.987968+08:00          143 Query     UNLOCK TABLES
2021-02-02T17:30:55.997812+08:00          143 Quit
复制