通过分析mysqldump的执行过程，分析执行mysqldump时对业务的影响

当运行mysqldump命令时，mysqldump执行过程会记录在general_log日志中。您可以通过查看日志来了解mysqldump 的运行情况。

1. 冲洗桌子。关闭所有打开的表对象并清除查询缓存。正在使用的表对象无法关闭，因此执行SQL请求可能会阻塞表刷新操作。

2. FTWRL（Flush Table with Read Lock）添加全局读锁，准备拍摄一致快照。

3. 使用一致快照开始事务。为了保证数据的一致性，该动作由–single-transaction参数决定。如果没有该参数，则不会执行此操作，并且无法保证备份数据的一致性。

4. 显示master状态；获取binlog位置信息；该动作由–master-data参数决定。如果没有此参数，则不会执行此类操作，并且备份数据中不存在主更改语句。

5. 解锁表并释放您在步骤2 中添加的全局读锁。

锁定时间：2023-05-06T16:49:07.655420+08:00

解锁时间：2023-05-06T16:49:07.658679+08:00

从锁定和解锁两个动作的时间来看，锁定时间约为3ms。当然，这是我的测试环境，数据量比较少，所以锁定时间较短。在生产环境中总是如此。

6. 开始执行备份相关操作。

显示数据库。

如果mysql 不存在，则显示数据库创建情况。

…………

概括：

为了保证数据的一致性，mysqldump在备份时添加了–single-transaction参数。这可以被其他SQL 阻止（当运行刷新表和运行ftwrl 时）。 返回）;

所以mysqldump添加–single-transaction参数后有优点也有缺点，但还是需要添加来保证数据的一致性。

优点：数据一致性有保证

坏处：

1. Mysqldump在刷新表和ftwrl时可能会阻塞，增加备份时间。

2、mysqldump执行ftwrl时，其他SQL被阻塞，业务受到影响。

建议：在非高峰时段进行备份操作

[root@localhost bin]# ./mysqldump -uroot -p11111 –single-transaction –master-data=1 -A back1.sql

这是运行mysqldump 时的General_log 日志：

[root@localhost log]# cat /app/mydata/data/localhost.log

2023-05-06T16:49:07.653407+08:00 15 使用套接字连接到root@localhost

2023-05-06T16:49:07.653762+08:00 15 查询/*!40100 SET @@SQL_MODE=” */

2023-05-06T16:49:07.654070+08:00 15 查询/*!40103 SET TIME_ZONE=’+00:00′ */

2023-05-06T16:49:07.654302+08:00 15 查询FLUSH /*!40101 LOCAL */表

2023-05-06T16:49:07.655420+08:00 15 查询带读锁的闪存表

2023-05-06T16:49:07.655629+08:00 15 查询集会话事务隔离级别重复读取

2023-05-06T16:49:07.655754+08:00 15 查询开始事务/*!40100 一致快照*/

2023-05-06T16:49:07.655998+08:00 15 查询SHOW VARIABLES LIKE ‘gtid_mode’

2023-05-06T16:49:07.657333+08:00 15 查询SHOW VARIABLES LIKE ‘gtid_mode’

2023-05-06T16:49:07.658491+08:00 15 查询SHOW MASTER 状态

2023-05-06T16:49:07.658679+08:00 15 查询解锁表

2023-05-06T16:49:07.658863+08:00 15 查询SELECT LOGFILE_GROUP_NAME、FILE_NAME、TOTAL_EXTENTS、INITIAL_SIZE、ENGINE、EXTRA FROM INFORMATION_SCHEMA.FILES，其中FILE_TYPE=’UNDO LOG’ 且FILE_NAME 不存在NULL AND LOGFILE_GROUP_NAME IS NOT NULL 按LOGFILE_GROUP_NAME、FILE_NAME 分组、ENGINE、TOTAL_EXTENTS、INITIAL_SIZE 按LOGFILE_GROUP_NAME 排序

2023-05-06T16:49:07.659256+08:00 15 查询SELECT DISTINCT TABLESPACE_NAME, FILE_NAME, LOGFILE_GROUP_NAME, EXTENT_SIZE, INITIAL_SIZE, ENGINE FROM INFORMATION_SCHEMA.FILES WHERE FILE_TY PE=TABLE SPACE_NAME , LOGFILE_GROUP_NAME

2023-05-06T16:49:07.659577+08:00 15 显示查询数据库

2023-05-06T16:49:07.659988+08:00 15 查询SHOW VARIABLES LIKE ‘ndbinfo\_version’

2023-05-06T16:49:07.661163+08:00 15 DB mysql初始化

2023-05-06T16:49:07.661265+08:00 15 查询显示创建数据库如果不存在`mysql`

2023-05-06T16:49:07.661451+08:00 15 查询SAVEPOINT sp

2023-05-06T16:49:07.661569+08:00 15 查询显示表

2023-05-06T16:49:07.661900+08:00 15 查询显示“columns\_priv”等表的状态

2023-05-06T16:49:07.662334+08:00 15 查询设置SQL_QUOTE_SHOW_CREATE=1

2023-05-06T16:49:07.662414+08:00 15 查询SET SESSION Character_set_results=’binary’

2023-05-06T16:49:07.662510+08:00 15 查询显示创建表`columns_priv`

2023-05-06T16:49:07.662672+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.662824+08:00 15 查询显示`columns_priv`字段

2023-05-06T16:49:07.663257+08:00 15 查询显示`columns_priv`字段

2023-05-06T16:49:07.663646+08:00 15 查询SELECT /*!40001 SQL_NO_CACHE */* FROM `columns_priv`

2023-05-06T16:49:07.663884+08:00 15 查询SET SESSION Character_set_results=’binary’

2023-05-06T16:49:07.663967+08:00 15 查询使用“mysql”

2023-05-06T16:49:07.664181+08:00 15 查询选择@@collation_database

2023-05-06T16:49:07.664408+08:00 15 查询SHOW TRIGGERS LIKE ‘columns\_priv’

2023-05-06T16:49:07.664763+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.664875+08:00 15 查询回滚到保存点sp

2023-05-06T16:49:07.665001+08:00 15 查询显示表状态如“db”

2023-05-06T16:49:07.665438+08:00 15 查询设置SQL_QUOTE_SHOW_CREATE=1

2023-05-06T16:49:07.665565+08:00 15 查询SET SESSION Character_set_results=’binary’

2023-05-06T16:49:07.665679+08:00 15 查询显示创建表`db`

2023-05-06T16:49:07.665825+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.665942+08:00 15 查询显示`db`字段

2023-05-06T16:49:07.666367+08:00 15 查询显示`db`字段

2023-05-06T16:49:07.666941+08:00 15 查询SELECT /*!40001 SQL_NO_CACHE */* FROM `db`

2023-05-06T16:49:07.667567+08:00 15 查询SET SESSION Character_set_results=’binary’

2023-05-06T16:49:07.667997+08:00 15 查询使用“mysql”

2023-05-06T16:49:07.668283+08:00 15 查询选择@@collation_database

2023-05-06T16:49:07.668408+08:00 15 查询SHOW TRIGGERS LIKE ‘db’

2023-05-06T16:49:07.668783+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.668874+08:00 15 查询回滚到保存点sp

2023-05-06T16:49:07.668992+08:00 15 查询显示“engine\_cost”等表的状态

2023-05-06T16:49:07.669510+08:00 15 查询设置SQL_QUOTE_SHOW_CREATE=1

2023-05-06T16:49:07.669832+08:00 15 查询SET SESSION Character_set_results=’binary’

2023-05-06T16:49:07.670086+08:00 15 查询显示创建表`engine_cost`

2023-05-06T16:49:07.670368+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.670692+08:00 15 查询显示`engine_cost`字段

2023-05-06T16:49:07.671166+08:00 15 查询显示`engine_cost`字段

2023-05-06T16:49:07.671639+08:00 15 查询SELECT /*!40001 SQL_NO_CACHE */* FROM `engine_cost`

2023-05-06T16:49:07.671917+08:00 15 查询SET SESSION Character_set_results=’binary’

2023-05-06T16:49:07.672066+08:00 15 查询使用“mysql”

2023-05-06T16:49:07.672190+08:00 15 查询选择@@collation_database

2023-05-06T16:49:07.672310+08:00 15 查询SHOW TRIGGERS LIKE ‘engine\_cost’

2023-05-06T16:49:07.672912+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.673074+08:00 15 查询回滚到保存点sp

2023-05-06T16:49:07.673200+08:00 15 查询显示表状态，如“事件”

2023-05-06T16:49:07.674618+08:00 15 查询设置SQL_QUOTE_SHOW_CREATE=1

2023-05-06T16:49:07.674747+08:00 15 查询SET SESSION Character_set_results=’binary’

2023-05-06T16:49:07.675018+08:00 15 查询显示创建表`event`

2023-05-06T16:49:07.675243+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.675457+08:00 15 查询显示`event`字段

2023-05-06T16:49:07.675936+08:00 15 查询显示`event`字段

2023-05-06T16:49:07.676352+08:00 15 查询SELECT /*!40001 SQL_NO_CACHE */* FROM `event`

2023-05-06T16:49:07.676591+08:00 15 查询SET SESSIONCharacter_set_results=’binary’

2023-05-06T16:49:07.676697+08:00 15 查询使用“mysql”

2023-05-06T16:49:07.676864+08:00 15 查询选择@@collation_database

2023-05-06T16:49:07.676979+08:00 15 查询SHOW TRIGGERS LIKE ‘event’

2023-05-06T16:49:07.677345+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.677422+08:00 15 查询回滚到保存点sp

2023-05-06T16:49:07.677573+08:00 15 查询显示“func”等表的状态

2023-05-06T16:49:07.677968+08:00 15 查询设置SQL_QUOTE_SHOW_CREATE=1

2023-05-06T16:49:07.678046+08:00 15 查询SET SESSIONCharacter_set_results=’binary’

2023-05-06T16:49:07.678146+08:00 15 查询显示创建表`func`

2023-05-06T16:49:07.678271+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.678390+08:00 15 从`func`查询显示字段

2023-05-06T16:49:07.678670+08:00 15 从`func`查询显示字段

2023-05-06T16:49:07.678904+08:00 15 查询SELECT /*!40001 SQL_NO_CACHE */* FROM `func`

2023-05-06T16:49:07.679130+08:00 15 查询SET SESSIONCharacter_set_results=’binary’

2023-05-06T16:49:07.679232+08:00 15 查询使用“mysql”

2023-05-06T16:49:07.679343+08:00 15 查询选择@@collation_database

2023-05-06T16:49:07.679460+08:00 15 查询SHOW TRIGGERS LIKE ‘func’

2023-05-06T16:49:07.679796+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.679892+08:00 15 查询回滚到保存点sp

2023-05-06T16:49:07.680003+08:00 15 查询显示表状态，如“gtid\_executed”

2023-05-06T16:49:07.680353+08:00 15 查询设置SQL_QUOTE_SHOW_CREATE=1

2023-05-06T16:49:07.680457+08:00 15 查询SET SESSIONCharacter_set_results=’binary’

2023-05-06T16:49:07.680585+08:00 15 查询显示创建表`gtid_execulated`

2023-05-06T16:49:07.680722+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.680895+08:00 15 查询显示`gtid_execulated`字段

2023-05-06T16:49:07.681350+08:00 15 查询显示`gtid_execulated`字段

2023-05-06T16:49:07.681652+08:00 15 查询SET SESSION Character_set_results=’binary’

2023-05-06T16:49:07.681757+08:00 15 查询使用“mysql”

2023-05-06T16:49:07.681874+08:00 15 查询选择@@collation_database

2023-05-06T16:49:07.681996+08:00 15 查询显示触发器如“gtid\_executed”

2023-05-06T16:49:07.682292+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.682406+08:00 15 查询回滚到保存点sp

2023-05-06T16:49:07.682515+08:00 15 查询显示表状态，如“help\_category”

2023-05-06T16:49:07.683563+08:00 15 查询设置SQL_QUOTE_SHOW_CREATE=1

2023-05-06T16:49:07.684073+08:00 15 查询SET SESSION Character_set_results=’binary’

2023-05-06T16:49:07.684307+08:00 15 查询显示创建表`help_category`

2023-05-06T16:49:07.684656+08:00 15 查询设置会话Character_set_results=’utf8′

2023-05-06T16:49:07.684776+08:00 15 查询显示`help_category`字段

2023-05-06T16:49:07.685045+08:00 15 查询显示`help_category`字段

2023-05-06T16:49:07.685342+08:00 15 查询SELECT /*!40001 SQL_NO_CACHE */* FROM `help_category`

2023-05-06T16:49:07.685701+08:00 15 查询SET SESSIONcharacter_set_re

sults = ‘binary’
2023-05-06T16:49:07.685822+08:00 15 Query use `mysql`
2023-05-06T16:49:07.685900+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.686046+08:00 15 Query SHOW TRIGGERS LIKE ‘help\_category’
2023-05-06T16:49:07.686775+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.687001+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.687125+08:00 15 Query show table status like ‘help\_keyword’
2023-05-06T16:49:07.687570+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.687774+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.687868+08:00 15 Query show create table `help_keyword`
2023-05-06T16:49:07.688045+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.688175+08:00 15 Query show fields from `help_keyword`
2023-05-06T16:49:07.688458+08:00 15 Query show fields from `help_keyword`
2023-05-06T16:49:07.688725+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_keyword`
2023-05-06T16:49:07.689499+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.689609+08:00 15 Query use `mysql`
2023-05-06T16:49:07.689721+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.689850+08:00 15 Query SHOW TRIGGERS LIKE ‘help\_keyword’
2023-05-06T16:49:07.690155+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.690261+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.690370+08:00 15 Query show table status like ‘help\_relation’
2023-05-06T16:49:07.690726+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.690830+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.690898+08:00 15 Query show create table `help_relation`
2023-05-06T16:49:07.691019+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.691138+08:00 15 Query show fields from `help_relation`
2023-05-06T16:49:07.691423+08:00 15 Query show fields from `help_relation`
2023-05-06T16:49:07.691682+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_relation`
2023-05-06T16:49:07.692502+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.692631+08:00 15 Query use `mysql`
2023-05-06T16:49:07.692744+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.692870+08:00 15 Query SHOW TRIGGERS LIKE ‘help\_relation’
2023-05-06T16:49:07.693166+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.693272+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.693379+08:00 15 Query show table status like ‘help\_topic’
2023-05-06T16:49:07.693680+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.693784+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.693883+08:00 15 Query show create table `help_topic`
2023-05-06T16:49:07.694017+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.694135+08:00 15 Query show fields from `help_topic`
2023-05-06T16:49:07.694389+08:00 15 Query show fields from `help_topic`
2023-05-06T16:49:07.694670+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_topic`
2023-05-06T16:49:07.702139+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.702228+08:00 15 Query use `mysql`
2023-05-06T16:49:07.702385+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.702538+08:00 15 Query SHOW TRIGGERS LIKE ‘help\_topic’
2023-05-06T16:49:07.703375+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.703701+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.704028+08:00 15 Query show table status like ‘innodb\_index\_stats’
2023-05-06T16:49:07.704592+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.704839+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.705105+08:00 15 Query show create table `innodb_index_stats`
2023-05-06T16:49:07.705350+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.705514+08:00 15 Query show fields from `innodb_index_stats`
2023-05-06T16:49:07.705934+08:00 15 Query show fields from `innodb_index_stats`
2023-05-06T16:49:07.706296+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `innodb_index_stats`
2023-05-06T16:49:07.706585+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.706737+08:00 15 Query use `mysql`
2023-05-06T16:49:07.706824+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.706921+08:00 15 Query SHOW TRIGGERS LIKE ‘innodb\_index\_stats’
2023-05-06T16:49:07.707294+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.707392+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.707555+08:00 15 Query show table status like ‘innodb\_table\_stats’
2023-05-06T16:49:07.707965+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.708045+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.708146+08:00 15 Query show create table `innodb_table_stats`
2023-05-06T16:49:07.708278+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.708397+08:00 15 Query show fields from `innodb_table_stats`
2023-05-06T16:49:07.708683+08:00 15 Query show fields from `innodb_table_stats`
2023-05-06T16:49:07.708929+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `innodb_table_stats`
2023-05-06T16:49:07.709100+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.709204+08:00 15 Query use `mysql`
2023-05-06T16:49:07.709314+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.709430+08:00 15 Query SHOW TRIGGERS LIKE ‘innodb\_table\_stats’
2023-05-06T16:49:07.709726+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.709830+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.709929+08:00 15 Query show table status like ‘ndb\_binlog\_index’
2023-05-06T16:49:07.710245+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.710349+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.710454+08:00 15 Query show create table `ndb_binlog_index`
2023-05-06T16:49:07.710592+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.710710+08:00 15 Query show fields from `ndb_binlog_index`
2023-05-06T16:49:07.710959+08:00 15 Query show fields from `ndb_binlog_index`
2023-05-06T16:49:07.711226+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `ndb_binlog_index`
2023-05-06T16:49:07.711414+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.711529+08:00 15 Query use `mysql`
2023-05-06T16:49:07.711635+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.711751+08:00 15 Query SHOW TRIGGERS LIKE ‘ndb\_binlog\_index’
2023-05-06T16:49:07.712024+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.712135+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.712241+08:00 15 Query show table status like ‘plugin’
2023-05-06T16:49:07.712733+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.712866+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.713108+08:00 15 Query show create table `plugin`
2023-05-06T16:49:07.713474+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.713954+08:00 15 Query show fields from `plugin`
2023-05-06T16:49:07.714359+08:00 15 Query show fields from `plugin`
2023-05-06T16:49:07.714651+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `plugin`
2023-05-06T16:49:07.714789+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.714881+08:00 15 Query use `mysql`
2023-05-06T16:49:07.714998+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.715121+08:00 15 Query SHOW TRIGGERS LIKE ‘plugin’
2023-05-06T16:49:07.715431+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.715551+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.715663+08:00 15 Query show table status like ‘proc’
2023-05-06T16:49:07.715981+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.716095+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.716205+08:00 15 Query show create table `proc`
2023-05-06T16:49:07.716352+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.716522+08:00 15 Query show fields from `proc`
2023-05-06T16:49:07.716858+08:00 15 Query show fields from `proc`
2023-05-06T16:49:07.717223+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `proc` WHERE db != ‘sys’
2023-05-06T16:49:07.717482+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.717593+08:00 15 Query use `mysql`
2023-05-06T16:49:07.717708+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.717830+08:00 15 Query SHOW TRIGGERS LIKE ‘proc’
2023-05-06T16:49:07.718105+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.718219+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.718331+08:00 15 Query show table status like ‘procs\_priv’
2023-05-06T16:49:07.718758+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.718875+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.718990+08:00 15 Query show create table `procs_priv`
2023-05-06T16:49:07.719134+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.719305+08:00 15 Query show fields from `procs_priv`
2023-05-06T16:49:07.719971+08:00 15 Query show fields from `procs_priv`
2023-05-06T16:49:07.720303+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `procs_priv`
2023-05-06T16:49:07.720456+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.720599+08:00 15 Query use `mysql`
2023-05-06T16:49:07.720731+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.720934+08:00 15 Query SHOW TRIGGERS LIKE ‘procs\_priv’
2023-05-06T16:49:07.721442+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.721641+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.721760+08:00 15 Query show table status like ‘proxies\_priv’
2023-05-06T16:49:07.722194+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.722276+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.722443+08:00 15 Query show create table `proxies_priv`
2023-05-06T16:49:07.722630+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.722808+08:00 15 Query show fields from `proxies_priv`
2023-05-06T16:49:07.723088+08:00 15 Query show fields from `proxies_priv`
2023-05-06T16:49:07.723357+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `proxies_priv`
2023-05-06T16:49:07.723571+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.723683+08:00 15 Query use `mysql`
2023-05-06T16:49:07.723796+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.723908+08:00 15 Query SHOW TRIGGERS LIKE ‘proxies\_priv’
2023-05-06T16:49:07.724204+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.724315+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.724435+08:00 15 Query show table status like ‘server\_cost’
2023-05-06T16:49:07.724813+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.724946+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.725056+08:00 15 Query show create table `server_cost`
2023-05-06T16:49:07.725180+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.725299+08:00 15 Query show fields from `server_cost`
2023-05-06T16:49:07.725573+08:00 15 Query show fields from `server_cost`
2023-05-06T16:49:07.725825+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `server_cost`
2023-05-06T16:49:07.725980+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.726087+08:00 15 Query use `mysql`
2023-05-06T16:49:07.726196+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.726312+08:00 15 Query SHOW TRIGGERS LIKE ‘server\_cost’
2023-05-06T16:49:07.726614+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.726719+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.726826+08:00 15 Query show table status like ‘servers’
2023-05-06T16:49:07.727084+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.727191+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.727296+08:00 15 Query show create table `servers`
2023-05-06T16:49:07.727433+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.727553+08:00 15 Query show fields from `servers`
2023-05-06T16:49:07.727808+08:00 15 Query show fields from `servers`
2023-05-06T16:49:07.728057+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `servers`
2023-05-06T16:49:07.728198+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.728303+08:00 15 Query use `mysql`
2023-05-06T16:49:07.728423+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.728539+08:00 15 Query SHOW TRIGGERS LIKE ‘servers’
2023-05-06T16:49:07.728817+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.728911+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.729022+08:00 15 Query show table status like ‘slave\_master\_info’
2023-05-06T16:49:07.729392+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.729496+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.729602+08:00 15 Query show create table `slave_master_info`
2023-05-06T16:49:07.729747+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.729872+08:00 15 Query show fields from `slave_master_info`
2023-05-06T16:49:07.730188+08:00 15 Query show fields from `slave_master_info`
2023-05-06T16:49:07.730570+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.730686+08:00 15 Query use `mysql`
2023-05-06T16:49:07.730796+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.730900+08:00 15 Query SHOW TRIGGERS LIKE ‘slave\_master\_info’
2023-05-06T16:49:07.731284+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.731405+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.731556+08:00 15 Query show table status like ‘slave\_relay\_log\_info’
2023-05-06T16:49:07.731877+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.731982+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.732094+08:00 15 Query show create table `slave_relay_log_info`
2023-05-06T16:49:07.732232+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.732417+08:00 15 Query show fields from `slave_relay_log_info`
2023-05-06T16:49:07.732828+08:00 15 Query show fields from `slave_relay_log_info`
2023-05-06T16:49:07.733243+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.733651+08:00 15 Query use `mysql`
2023-05-06T16:49:07.733960+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.734173+08:00 15 Query SHOW TRIGGERS LIKE ‘slave\_relay\_log\_info’
2023-05-06T16:49:07.734601+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.734686+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.734809+08:00 15 Query show table status like ‘slave\_worker\_info’
2023-05-06T16:49:07.735254+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.735392+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.735705+08:00 15 Query show create table `slave_worker_info`
2023-05-06T16:49:07.735858+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.736035+08:00 15 Query show fields from `slave_worker_info`
2023-05-06T16:49:07.736355+08:00 15 Query show fields from `slave_worker_info`
2023-05-06T16:49:07.736920+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `slave_worker_info`
2023-05-06T16:49:07.737106+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.737299+08:00 15 Query use `mysql`
2023-05-06T16:49:07.737425+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.737541+08:00 15 Query SHOW TRIGGERS LIKE ‘slave\_worker\_info’
2023-05-06T16:49:07.737878+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.737992+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.738107+08:00 15 Query show table status like ‘tables\_priv’
2023-05-06T16:49:07.738444+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.738615+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.738721+08:00 15 Query show create table `tables_priv`
2023-05-06T16:49:07.738861+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.738985+08:00 15 Query show fields from `tables_priv`
2023-05-06T16:49:07.739269+08:00 15 Query show fields from `tables_priv`
2023-05-06T16:49:07.739599+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `tables_priv`
2023-05-06T16:49:07.739776+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.739881+08:00 15 Query use `mysql`
2023-05-06T16:49:07.739993+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.740110+08:00 15 Query SHOW TRIGGERS LIKE ‘tables\_priv’
2023-05-06T16:49:07.740410+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.740520+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.740629+08:00 15 Query show table status like ‘time\_zone’
2023-05-06T16:49:07.740900+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.741008+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.741114+08:00 15 Query show create table `time_zone`
2023-05-06T16:49:07.741240+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.741388+08:00 15 Query show fields from `time_zone`
2023-05-06T16:49:07.741628+08:00 15 Query show fields from `time_zone`
2023-05-06T16:49:07.741878+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone`
2023-05-06T16:49:07.742009+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.742112+08:00 15 Query use `mysql`
2023-05-06T16:49:07.742221+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.742335+08:00 15 Query SHOW TRIGGERS LIKE ‘time\_zone’
2023-05-06T16:49:07.742645+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.742845+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.742954+08:00 15 Query show table status like ‘time\_zone\_leap\_second’
2023-05-06T16:49:07.743286+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.743403+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.743517+08:00 15 Query show create table `time_zone_leap_second`
2023-05-06T16:49:07.743639+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.743757+08:00 15 Query show fields from `time_zone_leap_second`
2023-05-06T16:49:07.743986+08:00 15 Query show fields from `time_zone_leap_second`
2023-05-06T16:49:07.744228+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_leap_second`
2023-05-06T16:49:07.744357+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.744937+08:00 15 Query use `mysql`
2023-05-06T16:49:07.745354+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.745769+08:00 15 Query SHOW TRIGGERS LIKE ‘time\_zone\_leap\_second’
2023-05-06T16:49:07.746044+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.746157+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.746266+08:00 15 Query show table status like ‘time\_zone\_name’
2023-05-06T16:49:07.746564+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.746669+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.746775+08:00 15 Query show create table `time_zone_name`
2023-05-06T16:49:07.746883+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.747001+08:00 15 Query show fields from `time_zone_name`
2023-05-06T16:49:07.747238+08:00 15 Query show fields from `time_zone_name`
2023-05-06T16:49:07.747495+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_name`
2023-05-06T16:49:07.747624+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.747727+08:00 15 Query use `mysql`
2023-05-06T16:49:07.747836+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.747938+08:00 15 Query SHOW TRIGGERS LIKE ‘time\_zone\_name’
2023-05-06T16:49:07.748208+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.748312+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.748427+08:00 15 Query show table status like ‘time\_zone\_transition’
2023-05-06T16:49:07.748695+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.748798+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.748863+08:00 15 Query show create table `time_zone_transition`
2023-05-06T16:49:07.748984+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.749096+08:00 15 Query show fields from `time_zone_transition`
2023-05-06T16:49:07.749329+08:00 15 Query show fields from `time_zone_transition`
2023-05-06T16:49:07.749580+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_transition`
2023-05-06T16:49:07.749707+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.749809+08:00 15 Query use `mysql`
2023-05-06T16:49:07.749907+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.750022+08:00 15 Query SHOW TRIGGERS LIKE ‘time\_zone\_transition’
2023-05-06T16:49:07.750290+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.750396+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.750506+08:00 15 Query show table status like ‘time\_zone\_transition\_type’
2023-05-06T16:49:07.750860+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.751200+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.751342+08:00 15 Query show create table `time_zone_transition_type`
2023-05-06T16:49:07.751484+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.751605+08:00 15 Query show fields from `time_zone_transition_type`
2023-05-06T16:49:07.751978+08:00 15 Query show fields from `time_zone_transition_type`
2023-05-06T16:49:07.752382+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_transition_type`
2023-05-06T16:49:07.752550+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.752673+08:00 15 Query use `mysql`
2023-05-06T16:49:07.752801+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.752933+08:00 15 Query SHOW TRIGGERS LIKE ‘time\_zone\_transition\_type’
2023-05-06T16:49:07.753254+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.753382+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.753509+08:00 15 Query show table status like ‘user’
2023-05-06T16:49:07.753943+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.754075+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.754193+08:00 15 Query show create table `user`
2023-05-06T16:49:07.754358+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.754480+08:00 15 Query show fields from `user`
2023-05-06T16:49:07.754893+08:00 15 Query show fields from `user`
2023-05-06T16:49:07.755268+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `user`
2023-05-06T16:49:07.755539+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.755646+08:00 15 Query use `mysql`
2023-05-06T16:49:07.755759+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.755882+08:00 15 Query SHOW TRIGGERS LIKE ‘user’
2023-05-06T16:49:07.756173+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.756279+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.756394+08:00 15 Query RELEASE SAVEPOINT sp
2023-05-06T16:49:07.756543+08:00 15 Query show table status like ‘general\_log’
2023-05-06T16:49:07.756862+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.756968+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.757075+08:00 15 Query show create table `general_log`
2023-05-06T16:49:07.757196+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.757309+08:00 15 Query show fields from `general_log`
2023-05-06T16:49:07.757575+08:00 15 Query show fields from `general_log`
2023-05-06T16:49:07.757819+08:00 15 Query show table status like ‘slow\_log’
2023-05-06T16:49:07.758172+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.758278+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.758395+08:00 15 Query show create table `slow_log`
2023-05-06T16:49:07.758518+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.758630+08:00 15 Query show fields from `slow_log`
2023-05-06T16:49:07.758876+08:00 15 Query show fields from `slow_log`
2023-05-06T16:49:07.759132+08:00 15 Init DB zss
2023-05-06T16:49:07.759234+08:00 15 Query SHOW CREATE DATABASE IF NOT EXISTS `zss`
2023-05-06T16:49:07.759353+08:00 15 Query SAVEPOINT sp
2023-05-06T16:49:07.759456+08:00 15 Query show tables
2023-05-06T16:49:07.759607+08:00 15 Query show table status like ‘aa’
2023-05-06T16:49:07.759894+08:00 15 Query SET SQL_QUOTE_SHOW_CREATE=1
2023-05-06T16:49:07.759999+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.760104+08:00 15 Query show create table `aa`
2023-05-06T16:49:07.760227+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.760340+08:00 15 Query show fields from `aa`
2023-05-06T16:49:07.760571+08:00 15 Query show fields from `aa`
2023-05-06T16:49:07.760806+08:00 15 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `aa`
2023-05-06T16:49:07.760915+08:00 15 Query SET SESSION character_set_results = ‘binary’
2023-05-06T16:49:07.761017+08:00 15 Query use `zss`
2023-05-06T16:49:07.761126+08:00 15 Query select @@collation_database
2023-05-06T16:49:07.761241+08:00 15 Query SHOW TRIGGERS LIKE ‘aa’
2023-05-06T16:49:07.761515+08:00 15 Query SET SESSION character_set_results = ‘utf8’
2023-05-06T16:49:07.761623+08:00 15 Query ROLLBACK TO SAVEPOINT sp
2023-05-06T16:49:07.761727+08:00 15 Query RELEASE SAVEPOINT sp
2023-05-06T16:49:07.761838+08:00 15 Query SHOW VARIABLES LIKE ‘gtid_mode’
2023-05-06T16:49:07.764231+08:00 15 Quit
[END] 2023/5/6 16:50:52