pos怎么备份(mysqldump备份过程及原理)

快鱼网 2022年12月27日 09:11:58 22 0

备份语句:

./mysqldump -uroot -p --master-data=2 --single-transaction --all-databases>/usr/local/aa.sql

一定要加2个参数，master-data=2 用来记录binlog和pos的位置， single-transaction 用来保存事务一致性

备份的过程

1.调用FTWRL(flush tables with read lock)，全局禁止读写

2.开启快照读,加一个session级别的RR隔离级别，获取此时的快照(仅对innodb表起作用)

3.备份非innodb表数据(*.frm,*.myi,*.myd等)

4.非innodb表备份完毕后，释放FTWRL锁

5.逐一备份innodb表数据

6.备份完成。

下面是通过general_log跟踪的备份信息

2020-01-09 14:25:31.

2020-01-09 14:25:37. root@localhost on using Socket

2020-01-09 14:25:37. /*! SET @@SQL_MODE='' */

2020-01-09 14:25:37. /*! SET TIME_ZONE='+00:00' */

2020-01-09 06:25:37. FLUSH /*! LOCAL */ TABLES

2020-01-09 06:25:37. FLUSH TABLES WITH READ LOCK

2020-01-09 06:25:37. SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ

2020-01-09 06:25:37. START TRANSACTION /*! WITH CONSISTENT SNAPSHOT */

2020-01-09 06:25:37. SHOW VARIABLES LIKE 'gtid\\_mode'

2020-01-09 06:25:37. SELECT @@GLOBAL.GTID_EXECUTED

2020-01-09 06:25:37. SHOW MASTER STATUS

2020-01-09 06:25:37. UNLOCK TABLES

2020-01-09 06:25:37. 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

2020-01-09 06:25:37. 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

2020-01-09 06:25:37. SHOW DATABASES

2020-01-09 06:25:37. SHOW VARIABLES LIKE 'ndbinfo\\_version'

2020-01-09 06:25:37. 2be98ca

2020-01-09 06:25:37. SHOW CREATE DATABASE IF NOT EXISTS `2be98ca`

2020-01-09 06:25:37. SAVEPOINT sp

2020-01-09 06:25:37. show tables

2020-01-09 06:25:37. RELEASE SAVEPOINT sp

2020-01-09 06:25:37. mysql

2020-01-09 06:25:37. SHOW CREATE DATABASE IF NOT EXISTS `mysql`

2020-01-09 06:25:37. SAVEPOINT sp

2020-01-09 06:25:37. show tables

2020-01-09 06:25:37. show table status like 'columns\\_priv'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `columns_priv`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `columns_priv`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `columns_priv`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'columns\\_priv'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'db'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `db`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `db`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `db`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'db'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'engine\\_cost'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `engine_cost`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `engine_cost`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `engine_cost`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'engine\\_cost'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'event'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `event`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `event`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `event`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'event'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'func'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `func`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `func`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `func`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'func'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'gtid\\_executed'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `gtid_executed`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `gtid_executed`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'gtid\\_executed'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'help\\_category'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `help_category`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `help_category`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `help_category`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'help\\_category'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'help\\_keyword'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `help_keyword`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `help_keyword`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `help_keyword`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'help\\_keyword'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'help\\_relation'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `help_relation`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `help_relation`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `help_relation`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'help\\_relation'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'help\\_topic'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `help_topic`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `help_topic`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `help_topic`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'help\\_topic'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'innodb\\_index\\_stats'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `innodb_index_stats`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `innodb_index_stats`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `innodb_index_stats`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'innodb\\_index\\_stats'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'innodb\\_table\\_stats'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `innodb_table_stats`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `innodb_table_stats`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `innodb_table_stats`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'innodb\\_table\\_stats'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'ndb\\_binlog\\_index'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `ndb_binlog_index`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `ndb_binlog_index`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `ndb_binlog_index`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'ndb\\_binlog\\_index'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'plugin'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `plugin`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `plugin`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `plugin`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'plugin'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'proc'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `proc`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `proc`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `proc` WHERE db != 'sys'

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'proc'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'procs\\_priv'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `procs_priv`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `procs_priv`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `procs_priv`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'procs\\_priv'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'proxies\\_priv'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `proxies_priv`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `proxies_priv`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `proxies_priv`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'proxies\\_priv'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'server\\_cost'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `server_cost`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `server_cost`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `server_cost`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'server\\_cost'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'servers'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `servers`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `servers`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `servers`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'servers'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'slave\\_master\\_info'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `slave_master_info`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `slave_master_info`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'slave\\_master\\_info'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'slave\\_relay\\_log\\_info'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `slave_relay_log_info`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `slave_relay_log_info`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'slave\\_relay\\_log\\_info'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'slave\\_worker\\_info'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `slave_worker_info`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `slave_worker_info`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `slave_worker_info`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'slave\\_worker\\_info'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'tables\\_priv'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `tables_priv`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `tables_priv`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `tables_priv`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'tables\\_priv'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'time\\_zone'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `time_zone`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `time_zone`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `time_zone`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'time\\_zone'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'time\\_zone\\_leap\\_second'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `time_zone_leap_second`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `time_zone_leap_second`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `time_zone_leap_second`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'time\\_zone\\_leap\\_second'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'time\\_zone\\_name'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `time_zone_name`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `time_zone_name`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `time_zone_name`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'time\\_zone\\_name'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'time\\_zone\\_transition'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `time_zone_transition`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `time_zone_transition`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `time_zone_transition`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'time\\_zone\\_transition'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'time\\_zone\\_transition\\_type'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `time_zone_transition_type`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `time_zone_transition_type`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `time_zone_transition_type`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'time\\_zone\\_transition\\_type'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'user'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `user`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `user`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `user`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `mysql`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 'user'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. RELEASE SAVEPOINT sp

2020-01-09 06:25:37. show table status like 'general\\_log'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `general_log`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `general_log`

2020-01-09 06:25:37. show table status like 'slow\\_log'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `slow_log`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `slow_log`

2020-01-09 06:25:37. test

2020-01-09 06:25:37. SHOW CREATE DATABASE IF NOT EXISTS `test`

2020-01-09 06:25:37. SAVEPOINT sp

2020-01-09 06:25:37. show tables

2020-01-09 06:25:37. show table status like 't\\_api\\_product\\_charging'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `t_api_product_charging`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `t_api_product_charging`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `t_api_product_charging`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `test`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 't\\_api\\_product\\_charging'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. show table status like 't\\_user'

2020-01-09 06:25:37. SET SQL_QUOTE_SHOW_CREATE=1

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. show create table `t_user`

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. show fields from `t_user`

2020-01-09 06:25:37. SELECT /*! SQL_NO_CACHE */ * FROM `t_user`

2020-01-09 06:25:37. SET SESSION character_set_results = 'binary'

2020-01-09 06:25:37. use `test`

2020-01-09 06:25:37. select @@collation_database

2020-01-09 06:25:37. SHOW TRIGGERS LIKE 't\\_user'

2020-01-09 06:25:37. SET SESSION character_set_results = 'utf8'

2020-01-09 06:25:37. ROLLBACK TO SAVEPOINT sp

2020-01-09 06:25:37. RELEASE SAVEPOINT sp

2020-01-09 06:25:37.

2020-01-09 14:25:43. SET PROFILING = 1

2020-01-09 14:25:43. SET profiling_history_size = 0

2020-01-09 14:25:43. SET profiling_history_size = 15

2020-01-09 14:25:43. SHOW STATUS

2020-01-09 14:25:43. select event_time,argument from general_log LIMIT 0, 1000

标签： 2020

本文地址： https://www.kyudaisuisou.com/toutiao/147776.html

文章来源：快鱼网

版权声明：①本站除快鱼网签约编辑原创内容以外，部分内容来源于网络、由互联网用户自发贡献，仅供学习参考。
②文章观点仅代表原作者本人不代表本站立场，并不完全代表本站赞同其观点和对其真实性负责。
③文章版权归原作者所有，部分转载文章仅为传播更多信息、受益服务用户之目的，如信息标记有误，请联系站长修正。
④本站一律禁止以任何方式发布或转载任何违法违规的相关信息，如发现本站上有涉嫌侵权/违规及任何不妥的内容，请第一时间反馈。发送邮件到 88667178@qq.com，经核实立即修正或删除。