備份語句:
./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.465721
2020-01-09 14:25:37.254971root@localhost on using Socket
2020-01-09 14:25:37.256728/*!40100 SET @@SQL_MODE='' */
2020-01-09 14:25:37.257217/*!40103 SET TIME_ZONE='+00:00' */
2020-01-09 06:25:37.257368FLUSH /*!40101 LOCAL */ TABLES
2020-01-09 06:25:37.261228FLUSH TABLES WITH READ LOCK
2020-01-09 06:25:37.263641SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
2020-01-09 06:25:37.264344START TRANSACTION /*!40100 WITH CONSISTENT SNAPSHOT */
2020-01-09 06:25:37.264591SHOW VARIABLES LIKE 'gtid\\\\_mode'
2020-01-09 06:25:37.267103SELECT @@GLOBAL.GTID_EXECUTED
2020-01-09 06:25:37.267322SHOW MASTER STATUS
2020-01-09 06:25:37.267421UNLOCK TABLES
2020-01-09 06:25:37.267663SELECT 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.268152SELECT 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.268613SHOW DATABASES
2020-01-09 06:25:37.269245SHOW VARIABLES LIKE 'ndbinfo\\\\_version'
2020-01-09 06:25:37.2723752be98c699824a
2020-01-09 06:25:37.272541SHOW CREATE DATABASE IF NOT EXISTS `2be98c699824a`
2020-01-09 06:25:37.272715SAVEPOINT sp
2020-01-09 06:25:37.272788show tables
2020-01-09 06:25:37.272933RELEASE SAVEPOINT sp
2020-01-09 06:25:37.273037mysql
2020-01-09 06:25:37.273984SHOW CREATE DATABASE IF NOT EXISTS `mysql`
2020-01-09 06:25:37.274944SAVEPOINT sp
2020-01-09 06:25:37.275192show tables
2020-01-09 06:25:37.276090show table status like 'columns\\\\_priv'
2020-01-09 06:25:37.277079SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.277286SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.277503show create table `columns_priv`
2020-01-09 06:25:37.277964SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.278290show fields from `columns_priv`
2020-01-09 06:25:37.280886show fields from `columns_priv`
2020-01-09 06:25:37.281761SELECT /*!40001 SQL_NO_CACHE */ * FROM `columns_priv`
2020-01-09 06:25:37.281957SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.282172use `mysql`
2020-01-09 06:25:37.282283select @@collation_database
2020-01-09 06:25:37.282571SHOW TRIGGERS LIKE 'columns\\\\_priv'
2020-01-09 06:25:37.283185SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.283343ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.283443show table status like 'db'
2020-01-09 06:25:37.284102SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.284240SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.284329show create table `db`
2020-01-09 06:25:37.284491SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.284879show fields from `db`
2020-01-09 06:25:37.285848show fields from `db`
2020-01-09 06:25:37.286919SELECT /*!40001 SQL_NO_CACHE */ * FROM `db`
2020-01-09 06:25:37.287279SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.287382use `mysql`
2020-01-09 06:25:37.287467select @@collation_database
2020-01-09 06:25:37.287705SHOW TRIGGERS LIKE 'db'
2020-01-09 06:25:37.288257SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.288361ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.288435show table status like 'engine\\\\_cost'
2020-01-09 06:25:37.288858SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.288979SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.289070show create table `engine_cost`
2020-01-09 06:25:37.289180SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.289257show fields from `engine_cost`
2020-01-09 06:25:37.289656show fields from `engine_cost`
2020-01-09 06:25:37.290054SELECT /*!40001 SQL_NO_CACHE */ * FROM `engine_cost`
2020-01-09 06:25:37.290259SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.290335use `mysql`
2020-01-09 06:25:37.290409select @@collation_database
2020-01-09 06:25:37.290488SHOW TRIGGERS LIKE 'engine\\\\_cost'
2020-01-09 06:25:37.290927SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.291028ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.291357show table status like 'event'
2020-01-09 06:25:37.293132SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.293636SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.293951show create table `event`
2020-01-09 06:25:37.294398SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.294591show fields from `event`
2020-01-09 06:25:37.295208show fields from `event`
2020-01-09 06:25:37.296390SELECT /*!40001 SQL_NO_CACHE */ * FROM `event`
2020-01-09 06:25:37.296705SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.296832use `mysql`
2020-01-09 06:25:37.296994select @@collation_database
2020-01-09 06:25:37.297468SHOW TRIGGERS LIKE 'event'
2020-01-09 06:25:37.298009SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.298161ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.298266show table status like 'func'
2020-01-09 06:25:37.298661SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.298743SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.298805show create table `func`
2020-01-09 06:25:37.298886SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.298955show fields from `func`
2020-01-09 06:25:37.299290show fields from `func`
2020-01-09 06:25:37.299533SELECT /*!40001 SQL_NO_CACHE */ * FROM `func`
2020-01-09 06:25:37.299736SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.299846use `mysql`
2020-01-09 06:25:37.299925select @@collation_database
2020-01-09 06:25:37.300009SHOW TRIGGERS LIKE 'func'
2020-01-09 06:25:37.300476SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.300548ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.300701show table status like 'gtid\\\\_executed'
2020-01-09 06:25:37.301239SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.301328SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.301390show create table `gtid_executed`
2020-01-09 06:25:37.301469SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.301538show fields from `gtid_executed`
2020-01-09 06:25:37.301928show fields from `gtid_executed`
2020-01-09 06:25:37.302236SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.302313use `mysql`
2020-01-09 06:25:37.302396select @@collation_database
2020-01-09 06:25:37.302475SHOW TRIGGERS LIKE 'gtid\\\\_executed'
2020-01-09 06:25:37.302870SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.302971ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.303038show table status like 'help\\\\_category'
2020-01-09 06:25:37.303413SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.303480SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.303539show create table `help_category`
2020-01-09 06:25:37.303711SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.303790show fields from `help_category`
2020-01-09 06:25:37.304070show fields from `help_category`
2020-01-09 06:25:37.304515SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_category`
2020-01-09 06:25:37.304992SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.305129use `mysql`
2020-01-09 06:25:37.305213select @@collation_database
2020-01-09 06:25:37.305309SHOW TRIGGERS LIKE 'help\\\\_category'
2020-01-09 06:25:37.305760SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.305844ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.305911show table status like 'help\\\\_keyword'
2020-01-09 06:25:37.306276SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.306353SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.306414show create table `help_keyword`
2020-01-09 06:25:37.306494SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.306563show fields from `help_keyword`
2020-01-09 06:25:37.306909show fields from `help_keyword`
2020-01-09 06:25:37.307206SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_keyword`
2020-01-09 06:25:37.307993SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.308068use `mysql`
2020-01-09 06:25:37.308199select @@collation_database
2020-01-09 06:25:37.308281SHOW TRIGGERS LIKE 'help\\\\_keyword'
2020-01-09 06:25:37.308609SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.308785ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.308851show table status like 'help\\\\_relation'
2020-01-09 06:25:37.309172SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.309249SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.309313show create table `help_relation`
2020-01-09 06:25:37.309409SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.309477show fields from `help_relation`
2020-01-09 06:25:37.309833show fields from `help_relation`
2020-01-09 06:25:37.310075SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_relation`
2020-01-09 06:25:37.314300SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.314514use `mysql`
2020-01-09 06:25:37.314672select @@collation_database
2020-01-09 06:25:37.314815SHOW TRIGGERS LIKE 'help\\\\_relation'
2020-01-09 06:25:37.315357SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.315451ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.315538show table status like 'help\\\\_topic'
2020-01-09 06:25:37.315905SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.315980SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.316052show create table `help_topic`
2020-01-09 06:25:37.316251SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.316331show fields from `help_topic`
2020-01-09 06:25:37.316606show fields from `help_topic`
2020-01-09 06:25:37.316942SELECT /*!40001 SQL_NO_CACHE */ * FROM `help_topic`
2020-01-09 06:25:37.332752SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.332867use `mysql`
2020-01-09 06:25:37.332944select @@collation_database
2020-01-09 06:25:37.333028SHOW TRIGGERS LIKE 'help\\\\_topic'
2020-01-09 06:25:37.333454SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.333526ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.333591show table status like 'innodb\\\\_index\\\\_stats'
2020-01-09 06:25:37.333949SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.334020SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.334080show create table `innodb_index_stats`
2020-01-09 06:25:37.334164SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.334299show fields from `innodb_index_stats`
2020-01-09 06:25:37.334592show fields from `innodb_index_stats`
2020-01-09 06:25:37.334957SELECT /*!40001 SQL_NO_CACHE */ * FROM `innodb_index_stats`
2020-01-09 06:25:37.335229SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.335315use `mysql`
2020-01-09 06:25:37.335383select @@collation_database
2020-01-09 06:25:37.335456SHOW TRIGGERS LIKE 'innodb\\\\_index\\\\_stats'
2020-01-09 06:25:37.335882SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.335961ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.336027show table status like 'innodb\\\\_table\\\\_stats'
2020-01-09 06:25:37.336363SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.336425SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.336485show create table `innodb_table_stats`
2020-01-09 06:25:37.336566SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.336635show fields from `innodb_table_stats`
2020-01-09 06:25:37.337005show fields from `innodb_table_stats`
2020-01-09 06:25:37.337327SELECT /*!40001 SQL_NO_CACHE */ * FROM `innodb_table_stats`
2020-01-09 06:25:37.337467SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.337531use `mysql`
2020-01-09 06:25:37.337597select @@collation_database
2020-01-09 06:25:37.337667SHOW TRIGGERS LIKE 'innodb\\\\_table\\\\_stats'
2020-01-09 06:25:37.338036SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.338110ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.338174show table status like 'ndb\\\\_binlog\\\\_index'
2020-01-09 06:25:37.340122SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.340318SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.340402show create table `ndb_binlog_index`
2020-01-09 06:25:37.340512SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.340588show fields from `ndb_binlog_index`
2020-01-09 06:25:37.341047show fields from `ndb_binlog_index`
2020-01-09 06:25:37.341448SELECT /*!40001 SQL_NO_CACHE */ * FROM `ndb_binlog_index`
2020-01-09 06:25:37.341574SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.341641use `mysql`
2020-01-09 06:25:37.341750select @@collation_database
2020-01-09 06:25:37.341830SHOW TRIGGERS LIKE 'ndb\\\\_binlog\\\\_index'
2020-01-09 06:25:37.342126SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.342248ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.342335show table status like 'plugin'
2020-01-09 06:25:37.342604SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.342668SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.342849show create table `plugin`
2020-01-09 06:25:37.342930SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.342999show fields from `plugin`
2020-01-09 06:25:37.343315show fields from `plugin`
2020-01-09 06:25:37.343569SELECT /*!40001 SQL_NO_CACHE */ * FROM `plugin`
2020-01-09 06:25:37.343722SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.343793use `mysql`
2020-01-09 06:25:37.343860select @@collation_database
2020-01-09 06:25:37.343930SHOW TRIGGERS LIKE 'plugin'
2020-01-09 06:25:37.344259SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.344348ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.344414show table status like 'proc'
2020-01-09 06:25:37.344762SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.344836SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.344941show create table `proc`
2020-01-09 06:25:37.345045SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.345118show fields from `proc`
2020-01-09 06:25:37.345738show fields from `proc`
2020-01-09 06:25:37.346177SELECT /*!40001 SQL_NO_CACHE */ * FROM `proc` WHERE db != 'sys'
2020-01-09 06:25:37.346488SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.346561use `mysql`
2020-01-09 06:25:37.346628select @@collation_database
2020-01-09 06:25:37.346795SHOW TRIGGERS LIKE 'proc'
2020-01-09 06:25:37.347162SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.347297ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.347363show table status like 'procs\\\\_priv'
2020-01-09 06:25:37.347668SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.347828SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.347911show create table `procs_priv`
2020-01-09 06:25:37.348015SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.348085show fields from `procs_priv`
2020-01-09 06:25:37.348506show fields from `procs_priv`
2020-01-09 06:25:37.348893SELECT /*!40001 SQL_NO_CACHE */ * FROM `procs_priv`
2020-01-09 06:25:37.349051SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.349125use `mysql`
2020-01-09 06:25:37.349347select @@collation_database
2020-01-09 06:25:37.349476SHOW TRIGGERS LIKE 'procs\\\\_priv'
2020-01-09 06:25:37.349933SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.350046ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.350115show table status like 'proxies\\\\_priv'
2020-01-09 06:25:37.350547SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.350615SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.350677show create table `proxies_priv`
2020-01-09 06:25:37.350837SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.350917show fields from `proxies_priv`
2020-01-09 06:25:37.351199show fields from `proxies_priv`
2020-01-09 06:25:37.352378SELECT /*!40001 SQL_NO_CACHE */ * FROM `proxies_priv`
2020-01-09 06:25:37.353345SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.353897use `mysql`
2020-01-09 06:25:37.354325select @@collation_database
2020-01-09 06:25:37.354463SHOW TRIGGERS LIKE 'proxies\\\\_priv'
2020-01-09 06:25:37.354996SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.355167ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.355267show table status like 'server\\\\_cost'
2020-01-09 06:25:37.355630SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.355699SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.355846show create table `server_cost`
2020-01-09 06:25:37.355956SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.356039show fields from `server_cost`
2020-01-09 06:25:37.356396show fields from `server_cost`
2020-01-09 06:25:37.356641SELECT /*!40001 SQL_NO_CACHE */ * FROM `server_cost`
2020-01-09 06:25:37.356870SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.356942use `mysql`
2020-01-09 06:25:37.357011select @@collation_database
2020-01-09 06:25:37.357083SHOW TRIGGERS LIKE 'server\\\\_cost'
2020-01-09 06:25:37.357459SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.357530ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.357594show table status like 'servers'
2020-01-09 06:25:37.357940SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.358009SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.358068show create table `servers`
2020-01-09 06:25:37.358152SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.358219show fields from `servers`
2020-01-09 06:25:37.358569show fields from `servers`
2020-01-09 06:25:37.358901SELECT /*!40001 SQL_NO_CACHE */ * FROM `servers`
2020-01-09 06:25:37.359035SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.359100use `mysql`
2020-01-09 06:25:37.359166select @@collation_database
2020-01-09 06:25:37.359237SHOW TRIGGERS LIKE 'servers'
2020-01-09 06:25:37.359717SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.359905ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.359986show table status like 'slave\\\\_master\\\\_info'
2020-01-09 06:25:37.360335SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.360409SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.360489show create table `slave_master_info`
2020-01-09 06:25:37.360594SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.360665show fields from `slave_master_info`
2020-01-09 06:25:37.361087show fields from `slave_master_info`
2020-01-09 06:25:37.361505SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.361579use `mysql`
2020-01-09 06:25:37.361650select @@collation_database
2020-01-09 06:25:37.361725SHOW TRIGGERS LIKE 'slave\\\\_master\\\\_info'
2020-01-09 06:25:37.362184SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.362370ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.362468show table status like 'slave\\\\_relay\\\\_log\\\\_info'
2020-01-09 06:25:37.363885SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.364059SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.364147show create table `slave_relay_log_info`
2020-01-09 06:25:37.364326SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.364440show fields from `slave_relay_log_info`
2020-01-09 06:25:37.365117show fields from `slave_relay_log_info`
2020-01-09 06:25:37.365874SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.366075use `mysql`
2020-01-09 06:25:37.366188select @@collation_database
2020-01-09 06:25:37.366382SHOW TRIGGERS LIKE 'slave\\\\_relay\\\\_log\\\\_info'
2020-01-09 06:25:37.366856SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.366952ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.367023show table status like 'slave\\\\_worker\\\\_info'
2020-01-09 06:25:37.367375SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.367448SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.367513show create table `slave_worker_info`
2020-01-09 06:25:37.367620SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.367690show fields from `slave_worker_info`
2020-01-09 06:25:37.368089show fields from `slave_worker_info`
2020-01-09 06:25:37.368485SELECT /*!40001 SQL_NO_CACHE */ * FROM `slave_worker_info`
2020-01-09 06:25:37.368625SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.368691use `mysql`
2020-01-09 06:25:37.368758select @@collation_database
2020-01-09 06:25:37.368920SHOW TRIGGERS LIKE 'slave\\\\_worker\\\\_info'
2020-01-09 06:25:37.369218SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.369340ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.369405show table status like 'tables\\\\_priv'
2020-01-09 06:25:37.369713SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.369872SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.370113show create table `tables_priv`
2020-01-09 06:25:37.370385SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.370551show fields from `tables_priv`
2020-01-09 06:25:37.372596show fields from `tables_priv`
2020-01-09 06:25:37.373233SELECT /*!40001 SQL_NO_CACHE */ * FROM `tables_priv`
2020-01-09 06:25:37.373493SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.373582use `mysql`
2020-01-09 06:25:37.373652select @@collation_database
2020-01-09 06:25:37.373725SHOW TRIGGERS LIKE 'tables\\\\_priv'
2020-01-09 06:25:37.374100SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.374180ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.374247show table status like 'time\\\\_zone'
2020-01-09 06:25:37.374629SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.374713SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.374831show create table `time_zone`
2020-01-09 06:25:37.374933SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.375008show fields from `time_zone`
2020-01-09 06:25:37.375337show fields from `time_zone`
2020-01-09 06:25:37.375628SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone`
2020-01-09 06:25:37.375762SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.375949use `mysql`
2020-01-09 06:25:37.376068select @@collation_database
2020-01-09 06:25:37.376157SHOW TRIGGERS LIKE 'time\\\\_zone'
2020-01-09 06:25:37.376565SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.376638ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.376703show table status like 'time\\\\_zone\\\\_leap\\\\_second'
2020-01-09 06:25:37.377874SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.377990SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.378058show create table `time_zone_leap_second`
2020-01-09 06:25:37.378140SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.378210show fields from `time_zone_leap_second`
2020-01-09 06:25:37.378554show fields from `time_zone_leap_second`
2020-01-09 06:25:37.379082SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_leap_second`
2020-01-09 06:25:37.379372SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.379537use `mysql`
2020-01-09 06:25:37.379614select @@collation_database
2020-01-09 06:25:37.379694SHOW TRIGGERS LIKE 'time\\\\_zone\\\\_leap\\\\_second'
2020-01-09 06:25:37.380160SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.380242ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.380368show table status like 'time\\\\_zone\\\\_name'
2020-01-09 06:25:37.380693SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.380757SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.380869show create table `time_zone_name`
2020-01-09 06:25:37.380947SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.381016show fields from `time_zone_name`
2020-01-09 06:25:37.381255show fields from `time_zone_name`
2020-01-09 06:25:37.381581SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_name`
2020-01-09 06:25:37.381713SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.381777use `mysql`
2020-01-09 06:25:37.381898select @@collation_database
2020-01-09 06:25:37.381971SHOW TRIGGERS LIKE 'time\\\\_zone\\\\_name'
2020-01-09 06:25:37.382251SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.382388ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.382461show table status like 'time\\\\_zone\\\\_transition'
2020-01-09 06:25:37.382718SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.382781SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.382903show create table `time_zone_transition`
2020-01-09 06:25:37.383354SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.384683show fields from `time_zone_transition`
2020-01-09 06:25:37.385754show fields from `time_zone_transition`
2020-01-09 06:25:37.386273SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_transition`
2020-01-09 06:25:37.386526SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.386616use `mysql`
2020-01-09 06:25:37.386687select @@collation_database
2020-01-09 06:25:37.386761SHOW TRIGGERS LIKE 'time\\\\_zone\\\\_transition'
2020-01-09 06:25:37.387166SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.387238ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.387322show table status like 'time\\\\_zone\\\\_transition\\\\_type'
2020-01-09 06:25:37.387732SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.387818SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.387966show create table `time_zone_transition_type`
2020-01-09 06:25:37.388059SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.388149show fields from `time_zone_transition_type`
2020-01-09 06:25:37.388513show fields from `time_zone_transition_type`
2020-01-09 06:25:37.388767SELECT /*!40001 SQL_NO_CACHE */ * FROM `time_zone_transition_type`
2020-01-09 06:25:37.388965SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.389050use `mysql`
2020-01-09 06:25:37.389119select @@collation_database
2020-01-09 06:25:37.389193SHOW TRIGGERS LIKE 'time\\\\_zone\\\\_transition\\\\_type'
2020-01-09 06:25:37.389573SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.389649ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.389713show table status like 'user'
2020-01-09 06:25:37.390159SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.390226SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.390296show create table `user`
2020-01-09 06:25:37.390495SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.390575show fields from `user`
2020-01-09 06:25:37.391061show fields from `user`
2020-01-09 06:25:37.391544SELECT /*!40001 SQL_NO_CACHE */ * FROM `user`
2020-01-09 06:25:37.391745SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.391831use `mysql`
2020-01-09 06:25:37.392001select @@collation_database
2020-01-09 06:25:37.392076SHOW TRIGGERS LIKE 'user'
2020-01-09 06:25:37.392458SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.392554ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.392609RELEASE SAVEPOINT sp
2020-01-09 06:25:37.392666show table status like 'general\\\\_log'
2020-01-09 06:25:37.392924SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.393004SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.393063show create table `general_log`
2020-01-09 06:25:37.393137SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.393203show fields from `general_log`
2020-01-09 06:25:37.393545show fields from `general_log`
2020-01-09 06:25:37.393788show table status like 'slow\\\\_log'
2020-01-09 06:25:37.394248SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.394384SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.394459show create table `slow_log`
2020-01-09 06:25:37.394539SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.394607show fields from `slow_log`
2020-01-09 06:25:37.395084show fields from `slow_log`
2020-01-09 06:25:37.395937test
2020-01-09 06:25:37.396037SHOW CREATE DATABASE IF NOT EXISTS `test`
2020-01-09 06:25:37.396107SAVEPOINT sp
2020-01-09 06:25:37.396167show tables
2020-01-09 06:25:37.396315show table status like 't\\\\_api\\\\_product\\\\_charging'
2020-01-09 06:25:37.397635SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.397736SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.397803show create table `t_api_product_charging`
2020-01-09 06:25:37.397922SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.397993show fields from `t_api_product_charging`
2020-01-09 06:25:37.398409show fields from `t_api_product_charging`
2020-01-09 06:25:37.400818SELECT /*!40001 SQL_NO_CACHE */ * FROM `t_api_product_charging`
2020-01-09 06:25:37.401333SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.401542use `test`
2020-01-09 06:25:37.401618select @@collation_database
2020-01-09 06:25:37.401697SHOW TRIGGERS LIKE 't\\\\_api\\\\_product\\\\_charging'
2020-01-09 06:25:37.402091SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.402167ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.402235show table status like 't\\\\_user'
2020-01-09 06:25:37.403661SET SQL_QUOTE_SHOW_CREATE=1
2020-01-09 06:25:37.403758SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.403844show create table `t_user`
2020-01-09 06:25:37.403942SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.404013show fields from `t_user`
2020-01-09 06:25:37.404455show fields from `t_user`
2020-01-09 06:25:37.404877SELECT /*!40001 SQL_NO_CACHE */ * FROM `t_user`
2020-01-09 06:25:37.408194SET SESSION character_set_results = 'binary'
2020-01-09 06:25:37.408379use `test`
2020-01-09 06:25:37.408458select @@collation_database
2020-01-09 06:25:37.408541SHOW TRIGGERS LIKE 't\\\\_user'
2020-01-09 06:25:37.408938SET SESSION character_set_results = 'utf8'
2020-01-09 06:25:37.409033ROLLBACK TO SAVEPOINT sp
2020-01-09 06:25:37.409089RELEASE SAVEPOINT sp
2020-01-09 06:25:37.411920
2020-01-09 14:25:43.535697SET PROFILING = 1
2020-01-09 14:25:43.538465SET profiling_history_size = 0
2020-01-09 14:25:43.540374SET profiling_history_size = 15
2020-01-09 14:25:43.543659SHOW STATUS
2020-01-09 14:25:43.547477select event_time,argument from general_log LIMIT 0, 1000
閱讀更多 碩果累累1316 的文章
