背景

前边几篇文章我简单介绍了使用mysqlshell备份数据库及恢复备份数据的方式.这篇文章我们简单探讨一下mysqlshell备份数据库的原理.主要结合mysqlshell的输出以及mysql general_log

mysqlshell备份整个实例的原理

mysqlshell输出:

MySQL 10.10.119.63:33060+ ssl JS > util.dumpInstance("/mysqlsh",{threads : 8,ocimds:true,compatibility:["strip_restricted_grants"],bytesPerChunk:"1M"})Acquiring global read lockGlobal read lock acquiredGathering information - doneAll transactions have been startedLocking instance for backupGlobal read lock has been releasedChecking for compatibility with MySQL Database Service 8.0.26NOTE: User 'donor'@'%' had restricted privilege (BACKUP_ADMIN) removedNOTE: User 'lzm'@'%' had restricted privileges (AUDIT_ADMIN, BACKUP_ADMIN, BINLOG_ADMIN, BINLOG_ENCRYPTION_ADMIN, CLONE_ADMIN, CREATE TABLESPACE, ENCRYPTION_KEY_ADMIN, FILE, GROUP_REPLICATION_ADMIN, INNODB_REDO_LOG_ARCHIVE, INNODB_REDO_LOG_ENABLE, PERSIST_RO_VARIABLES_ADMIN, RELOAD, REPLICATION_SLAVE_ADMIN, ROLE_ADMIN, SERVICE_CONNECTION_ADMIN, SESSION_VARIABLES_ADMIN, SET_USER_ID, SHOW_ROUTINE, SHUTDOWN, SUPER, SYSTEM_USER, SYSTEM_VARIABLES_ADMIN, TABLE_ENCRYPTION_ADMIN) removedNOTE: User 'repl_mgr'@'%' had restricted privilege (BACKUP_ADMIN) removedNOTE: User 'root'@'127.0.0.1' had restricted privileges (AUDIT_ADMIN, BACKUP_ADMIN, BINLOG_ADMIN, BINLOG_ENCRYPTION_ADMIN, CLONE_ADMIN, CREATE TABLESPACE, ENCRYPTION_KEY_ADMIN, FILE, GROUP_REPLICATION_ADMIN, INNODB_REDO_LOG_ARCHIVE, INNODB_REDO_LOG_ENABLE, PERSIST_RO_VARIABLES_ADMIN, RELOAD, REPLICATION_SLAVE_ADMIN, ROLE_ADMIN, SERVICE_CONNECTION_ADMIN, SESSION_VARIABLES_ADMIN, SET_USER_ID, SHOW_ROUTINE, SHUTDOWN, SUPER, SYSTEM_USER, SYSTEM_VARIABLES_ADMIN, TABLE_ENCRYPTION_ADMIN) removedNOTE: User 'root'@'localhost' had restricted privileges (AUDIT_ADMIN, BACKUP_ADMIN, BINLOG_ADMIN, BINLOG_ENCRYPTION_ADMIN, CLONE_ADMIN, CREATE TABLESPACE, ENCRYPTION_KEY_ADMIN, FILE, GROUP_REPLICATION_ADMIN, INNODB_REDO_LOG_ARCHIVE, INNODB_REDO_LOG_ENABLE, PERSIST_RO_VARIABLES_ADMIN, PROXY, RELOAD, REPLICATION_SLAVE_ADMIN, ROLE_ADMIN, SERVICE_CONNECTION_ADMIN, SESSION_VARIABLES_ADMIN, SET_USER_ID, SHOW_ROUTINE, SHUTDOWN, SUPER, SYSTEM_USER, SYSTEM_VARIABLES_ADMIN, TABLE_ENCRYPTION_ADMIN) removedNOTE: Database test_1 had unsupported ENCRYPTION option commented outNOTE: Database test_2 had unsupported ENCRYPTION option commented outNOTE: Database test had unsupported ENCRYPTION option commented outNOTE: Database lzm had unsupported ENCRYPTION option commented outCompatibility issues with MySQL Database Service 8.0.26 were found and repaired. Please review the changes made before loading them.Writing global DDL filesWriting users DDLWriting DDL for schema `test_1`Writing DDL for table `test_1`.`T_CM_CUST`Writing DDL for schema `test_2`Writing DDL for table `test_2`.`checkpoint_lox`Writing DDL for table `test_2`.`T_HM_PropertyRight`Writing DDL for table `test_2`.`checkpoint`Writing DDL for table `test_2`.`T_HM_OWNER`Preparing data dump for table `test_1`.`T_CM_CUST`Data dump for table `test_1`.`T_CM_CUST` will be chunked using column `PKID`Preparing data dump for table `test_2`.`checkpoint_lox`Data dump for table `test_2`.`checkpoint_lox` will be chunked using columns `group_name`, `group_key`, `log_cmplt_csn`, `log_cmplt_xids_seq`Preparing data dump for table `test_2`.`checkpoint`Data dump for table `test_2`.`checkpoint` will be chunked using columns `group_name`, `group_key`Preparing data dump for table `test_2`.`T_HM_PropertyRight`Data dump for table `test_2`.`T_HM_PropertyRight` will be chunked using column `pkid`Preparing data dump for table `test_2`.`T_HM_OWNER`Data dump for table `test_2`.`T_HM_OWNER` will be chunked using column `pkid`Preparing data dump for table `test_2`.`T_HM_HOUSE`Data dump for table `test_2`.`T_HM_HOUSE` will be chunked using column `pkid`Preparing data dump for table `test_2`.`T_HM_HOUSEDEL`Data dump for table `test_2`.`T_HM_HOUSEDEL` will be chunked using column `pkid`Preparing data dump for table `test`.`t1`Data dump for table `test`.`t1` will be chunked using column `c1`Preparing data dump for table `lzm`.`sbtest1`Data dump for table `lzm`.`sbtest1` will be chunked using column `id`Writing DDL for table `test_2`.`T_HM_HOUSE`Running data dump using 8 threads.NOTE: Progress information uses estimated values and may not be accurate.Writing DDL for table `test_2`.`T_HM_HOUSEDEL`Writing DDL for schema `test`Writing DDL for table `test`.`t1`Writing DDL for schema `lzm`Writing DDL for table `lzm`.`sbtest1`NOTE: Table statistics not available for `test_2`.`checkpoint_lox`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `test_2`.`checkpoint_lox`;' first.NOTE: Table statistics not available for `test_2`.`checkpoint`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `test_2`.`checkpoint`;' first.Data dump for table `test_1`.`T_CM_CUST` will be written to 4 filesData dump for table `test_2`.`checkpoint_lox` will be written to 1 fileData dump for table `test_2`.`T_HM_PropertyRight` will be written to 1 fileData dump for table `test_2`.`T_HM_OWNER` will be written to 1 fileNOTE: Table statistics not available for `test`.`t1`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `test`.`t1`;' first.Data dump for table `test_2`.`T_HM_HOUSE` will be written to 1 fileData dump for table `test`.`t1` will be written to 1 fileData dump for table `test_2`.`T_HM_HOUSEDEL` will be written to 4 filesData dump for table `lzm`.`sbtest1` will be written to 23 files Data dump for table `test_2`.`checkpoint` will be written to 1 file 1 thds dumping - 102% (128.91K rows / ~125.17K rows), 0.00 rows/s, 0.00 B/s uncompressed, 0.00 B/s compressed Duration: 00:00:00s Schemas dumped: 4 Tables dumped: 9 Uncompressed data size: 25.67 MB Compressed data size: 9.88 MB Compression ratio: 2.6 Rows written: 128906 Bytes written: 9.88 MB Average uncompressed throughput: 25.67 MB/s Average compressed throughput: 9.88 MB/s

mysql general_log的输出:

2021-08-18T02:54:47.923098Z10758 QuerySELECT @@GLOBAL.port2021-08-18T02:54:47.926847Z10774 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:47.927053Z10774 QuerySET SQL_MODE = ''2021-08-18T02:54:47.927204Z10774 QuerySET NAMES 'utf8mb4'2021-08-18T02:54:47.927351Z10774 QuerySET SESSION net_write_timeout = 18002021-08-18T02:54:47.927471Z10774 QuerySET SESSION wait_timeout = 315360002021-08-18T02:54:47.927580Z10774 QuerySET TIME_ZONE = '+00:00'2021-08-18T02:54:47.927722Z10774 QuerySELECT CURRENT_USER()2021-08-18T02:54:47.927911Z10774 QuerySELECT PRIVILEGE_TYPE FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE GRANTEE=''lzm'@'%'' LIMIT 12021-08-18T02:54:47.928440Z10774 QuerySHOW PRIVILEGES2021-08-18T02:54:47.928687Z10774 QuerySELECT @@GLOBAL.activate_all_roles_on_login2021-08-18T02:54:47.928855Z10774 QuerySELECT default_role_user, default_role_host FROM mysql.default_roles WHERE user='lzm' AND host='%'2021-08-18T02:54:47.929228Z10774 QuerySHOW GRANTS FOR 'lzm'@'%'2021-08-18T02:54:47.929518Z10774 QueryFLUSH NO_WRITE_TO_BINLOG TABLES2021-08-18T02:54:47.933815Z10774 QueryFLUSH TABLES WITH READ LOCK2021-08-18T02:54:47.933978Z10774 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.934108Z10774 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.934507Z10774 QuerySELECT @@GLOBAL.VERSION2021-08-18T02:54:47.934821Z10774 QuerySELECT SCHEMA_NAME,DEFAULT_COLLATION_NAME FROM information_schema.schemata WHERE (STRCMP(SCHEMA_NAME COLLATE utf8_bin,'information_schema')&STRCMP(SCHEMA_NAME COLLATE utf8_bin,'mysql')&STRCMP(SCHEMA_NAME COLLATE utf8_bin,'ndbinfo')&STRCMP(SCHEMA_NAME COLLATE utf8_bin,'performance_schema')&STRCMP(SCHEMA_NAME COLLATE utf8_bin,'sys'))!=02021-08-18T02:54:47.937729Z10774 QuerySELECT TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE,TABLE_ROWS,AVG_ROW_LENGTH,ENGINE,CREATE_OPTIONS,TABLE_COMMENT FROM information_schema.tables WHERE (STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'test')&STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'lzm')&STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')&STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'crm_prd'))=02021-08-18T02:54:47.939327Z10780 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:47.939500Z10780 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.939644Z10780 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.939768Z10780 QuerySET SQL_MODE = ''2021-08-18T02:54:47.939875Z10780 QuerySET NAMES 'utf8mb4'2021-08-18T02:54:47.940003Z10780 QuerySET SESSION net_write_timeout = 18002021-08-18T02:54:47.940106Z10780 QuerySET SESSION wait_timeout = 315360002021-08-18T02:54:47.940125Z10774 QuerySHOW VARIABLES LIKE 'ndbinfo_version'2021-08-18T02:54:47.940225Z10780 QuerySET TIME_ZONE = '+00:00'2021-08-18T02:54:47.940636Z10776 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:47.940945Z10778 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:47.940985Z10776 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.941056Z10782 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:47.941133Z10776 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.941180Z10775 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:47.941258Z10776 QuerySET SQL_MODE = ''2021-08-18T02:54:47.941311Z10782 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.941379Z10781 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:47.941192Z10778 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.941459Z10775 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.941536Z10782 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.941543Z10776 QuerySET NAMES 'utf8mb4'2021-08-18T02:54:47.941539Z10781 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.941646Z10775 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.941654Z10779 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:47.941708Z10782 QuerySET SQL_MODE = ''2021-08-18T02:54:47.941723Z10781 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.941791Z10776 QuerySET SESSION net_write_timeout = 18002021-08-18T02:54:47.941799Z10775 QuerySET SQL_MODE = ''2021-08-18T02:54:47.941847Z10782 QuerySET NAMES 'utf8mb4'2021-08-18T02:54:47.941898Z10779 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.941921Z10775 QuerySET NAMES 'utf8mb4'2021-08-18T02:54:47.941979Z10782 QuerySET SESSION net_write_timeout = 18002021-08-18T02:54:47.942020Z10779 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.942090Z10776 QuerySET SESSION wait_timeout = 315360002021-08-18T02:54:47.942109Z10782 QuerySET SESSION wait_timeout = 315360002021-08-18T02:54:47.942150Z10779 QuerySET SQL_MODE = ''2021-08-18T02:54:47.942205Z10776 QuerySET TIME_ZONE = '+00:00'2021-08-18T02:54:47.942264Z10779 QuerySET NAMES 'utf8mb4'2021-08-18T02:54:47.942318Z10781 QuerySET SQL_MODE = ''2021-08-18T02:54:47.942407Z10779 QuerySET SESSION net_write_timeout = 18002021-08-18T02:54:47.942465Z10781 QuerySET NAMES 'utf8mb4'2021-08-18T02:54:47.942510Z10775 QuerySET SESSION net_write_timeout = 18002021-08-18T02:54:47.942524Z10779 QuerySET SESSION wait_timeout = 315360002021-08-18T02:54:47.942573Z10781 QuerySET SESSION net_write_timeout = 18002021-08-18T02:54:47.942635Z10782 QuerySET TIME_ZONE = '+00:00'2021-08-18T02:54:47.942657Z10779 QuerySET TIME_ZONE = '+00:00'2021-08-18T02:54:47.942580Z10777 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:47.942738Z10781 QuerySET SESSION wait_timeout = 315360002021-08-18T02:54:47.941543Z10778 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.942829Z10775 QuerySET SESSION wait_timeout = 315360002021-08-18T02:54:47.942857Z10781 QuerySET TIME_ZONE = '+00:00'2021-08-18T02:54:47.942950Z10777 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.943020Z10775 QuerySET TIME_ZONE = '+00:00'2021-08-18T02:54:47.943116Z10777 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.943239Z10777 QuerySET SQL_MODE = ''2021-08-18T02:54:47.943309Z10778 QuerySET SQL_MODE = ''2021-08-18T02:54:47.943408Z10774 QuerySELECT @@GLOBAL.HOSTNAME2021-08-18T02:54:47.943437Z10777 QuerySET NAMES 'utf8mb4'2021-08-18T02:54:47.943473Z10778 QuerySET NAMES 'utf8mb4'2021-08-18T02:54:47.943549Z10774 QuerySELECT @@GLOBAL.GTID_EXECUTED2021-08-18T02:54:47.943630Z10777 QuerySET SESSION net_write_timeout = 18002021-08-18T02:54:47.943637Z10778 QuerySET SESSION net_write_timeout = 18002021-08-18T02:54:47.943768Z10778 QuerySET SESSION wait_timeout = 315360002021-08-18T02:54:47.943804Z10777 QuerySET SESSION wait_timeout = 315360002021-08-18T02:54:47.943928Z10777 QuerySET TIME_ZONE = '+00:00'2021-08-18T02:54:47.943934Z10774 QuerySELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,ORDINAL_POSITION,IS_NULLABLE,COLUMN_TYPE,EXTRA FROM information_schema.columns WHERE ((STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'test')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'t1')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'lzm')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'sbtest1')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_HOUSE')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_HOUSEDEL')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_OWNER')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_PropertyRight')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'checkpoint')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'checkpoint_lox')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'crm_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_CM_CUST')=0))2021-08-18T02:54:47.943950Z10778 QuerySET TIME_ZONE = '+00:00'2021-08-18T02:54:47.947852Z10774 QuerySELECT TABLE_SCHEMA,TABLE_NAME,INDEX_NAME,COLUMN_NAME,SEQ_IN_INDEX FROM information_schema.statistics WHERE COLUMN_NAME IS NOT NULL AND NON_UNIQUE=0 AND ((STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'test')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'t1')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'lzm')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'sbtest1')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_HOUSE')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_HOUSEDEL')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_OWNER')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_PropertyRight')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'checkpoint')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'checkpoint_lox')=0)OR(STRCMP(TABLE_SCHEMA COLLATE utf8_bin,'crm_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_CM_CUST')=0))2021-08-18T02:54:47.950157Z10774 QuerySELECT SCHEMA_NAME,TABLE_NAME,COLUMN_NAME,JSON_EXTRACT(HISTOGRAM,'$."number-of-buckets-specified"') FROM information_schema.column_statistics WHERE ((STRCMP(SCHEMA_NAME COLLATE utf8_bin,'test')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'t1')=0)OR(STRCMP(SCHEMA_NAME COLLATE utf8_bin,'lzm')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'sbtest1')=0)OR(STRCMP(SCHEMA_NAME COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_HOUSE')=0)OR(STRCMP(SCHEMA_NAME COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_HOUSEDEL')=0)OR(STRCMP(SCHEMA_NAME COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_OWNER')=0)OR(STRCMP(SCHEMA_NAME COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_HM_PropertyRight')=0)OR(STRCMP(SCHEMA_NAME COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'checkpoint')=0)OR(STRCMP(SCHEMA_NAME COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'checkpoint_lox')=0)OR(STRCMP(SCHEMA_NAME COLLATE utf8_bin,'crm_prd')=0 AND STRCMP(TABLE_NAME COLLATE utf8_bin,'T_CM_CUST')=0))2021-08-18T02:54:47.950647Z10774 QuerySELECT DISTINCT user, host from mysql.user WHERE NOT(user.user='mysql.infoschema')AND NOT(user.user='mysql.session')AND NOT(user.user='mysql.sys')2021-08-18T02:54:47.951329Z10774 QuerySELECT DISTINCT user, host FROM mysql.user WHERE authentication_string='' AND account_locked='Y' AND password_expired='Y' AND NOT(user.user='mysql.infoschema')AND NOT(user.user='mysql.session')AND NOT(user.user='mysql.sys')2021-08-18T02:54:47.951598Z10774 QuerySELECT EVENT_SCHEMA,EVENT_NAME FROM information_schema.events WHERE (STRCMP(EVENT_SCHEMA COLLATE utf8_bin,'test')&STRCMP(EVENT_SCHEMA COLLATE utf8_bin,'lzm')&STRCMP(EVENT_SCHEMA COLLATE utf8_bin,'scsales_prd')&STRCMP(EVENT_SCHEMA COLLATE utf8_bin,'crm_prd'))=02021-08-18T02:54:47.952499Z10774 QuerySELECT ROUTINE_SCHEMA,ROUTINE_TYPE,ROUTINE_NAME FROM information_schema.routines WHERE (STRCMP(ROUTINE_SCHEMA COLLATE utf8_bin,'test')&STRCMP(ROUTINE_SCHEMA COLLATE utf8_bin,'lzm')&STRCMP(ROUTINE_SCHEMA COLLATE utf8_bin,'scsales_prd')&STRCMP(ROUTINE_SCHEMA COLLATE utf8_bin,'crm_prd'))=02021-08-18T02:54:47.953913Z10774 QuerySELECT TRIGGER_SCHEMA,EVENT_OBJECT_TABLE,TRIGGER_NAME,ACTION_ORDER FROM information_schema.triggers WHERE ((STRCMP(TRIGGER_SCHEMA COLLATE utf8_bin,'test')=0 AND STRCMP(EVENT_OBJECT_TABLE COLLATE utf8_bin,'t1')=0)OR(STRCMP(TRIGGER_SCHEMA COLLATE utf8_bin,'lzm')=0 AND STRCMP(EVENT_OBJECT_TABLE COLLATE utf8_bin,'sbtest1')=0)OR(STRCMP(TRIGGER_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(EVENT_OBJECT_TABLE COLLATE utf8_bin,'T_HM_HOUSE')=0)OR(STRCMP(TRIGGER_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(EVENT_OBJECT_TABLE COLLATE utf8_bin,'T_HM_HOUSEDEL')=0)OR(STRCMP(TRIGGER_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(EVENT_OBJECT_TABLE COLLATE utf8_bin,'T_HM_OWNER')=0)OR(STRCMP(TRIGGER_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(EVENT_OBJECT_TABLE COLLATE utf8_bin,'T_HM_PropertyRight')=0)OR(STRCMP(TRIGGER_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(EVENT_OBJECT_TABLE COLLATE utf8_bin,'checkpoint')=0)OR(STRCMP(TRIGGER_SCHEMA COLLATE utf8_bin,'scsales_prd')=0 AND STRCMP(EVENT_OBJECT_TABLE COLLATE utf8_bin,'checkpoint_lox')=0)OR(STRCMP(TRIGGER_SCHEMA COLLATE utf8_bin,'crm_prd')=0 AND STRCMP(EVENT_OBJECT_TABLE COLLATE utf8_bin,'T_CM_CUST')=0))2021-08-18T02:54:47.954901Z10774 QuerySHOW MASTER STATUS2021-08-18T02:54:47.955153Z10774 QueryLOCK INSTANCE FOR BACKUP2021-08-18T02:54:47.955271Z10774 QueryUNLOCK TABLES2021-08-18T02:54:47.955493Z10774 QuerySHOW CREATE USER 'donor'@'%'2021-08-18T02:54:47.955724Z10774 QuerySHOW CREATE USER 'lzm'@'%'2021-08-18T02:54:47.955908Z10774 QuerySHOW CREATE USER 'proxyjiankong'@'%'2021-08-18T02:54:47.956078Z10774 QuerySHOW CREATE USER 'repl_mgr'@'%'2021-08-18T02:54:47.956247Z10774 QuerySHOW CREATE USER 'root'@'127.0.0.1'2021-08-18T02:54:47.956436Z10774 QuerySHOW CREATE USER 'root'@'localhost'2021-08-18T02:54:47.956624Z10774 QuerySHOW GRANTS FOR 'donor'@'%'2021-08-18T02:54:47.956780Z10774 QuerySHOW GRANTS FOR 'lzm'@'%'2021-08-18T02:54:47.957020Z10774 QuerySHOW GRANTS FOR 'proxyjiankong'@'%'2021-08-18T02:54:47.957142Z10774 QuerySHOW GRANTS FOR 'repl_mgr'@'%'2021-08-18T02:54:47.957267Z10774 QuerySHOW GRANTS FOR 'root'@'127.0.0.1'2021-08-18T02:54:47.957490Z10774 QuerySHOW GRANTS FOR 'root'@'localhost'2021-08-18T02:54:47.957836Z10774 QuerySHOW CREATE DATABASE IF NOT EXISTS crm_prd2021-08-18T02:54:47.958018Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.958140Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.958279Z10774 QuerySHOW CREATE DATABASE IF NOT EXISTS scsales_prd2021-08-18T02:54:47.958422Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.958532Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.958656Z10774 QuerySHOW CREATE DATABASE IF NOT EXISTS test2021-08-18T02:54:47.958801Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.958906Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.959027Z10774 QuerySHOW CREATE DATABASE IF NOT EXISTS lzm2021-08-18T02:54:47.959175Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.959277Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.959394Z10774 QueryUSE `crm_prd`2021-08-18T02:54:47.959518Z10774 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.959620Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.959722Z10774 Queryshow create table `T_CM_CUST`2021-08-18T02:54:47.960924Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.961496Z10774 Queryshow fields from `T_CM_CUST`2021-08-18T02:54:47.962590Z10774 QueryUSE `scsales_prd`2021-08-18T02:54:47.962747Z10774 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.962863Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.962972Z10774 Queryshow create table `checkpoint_lox`2021-08-18T02:54:47.963509Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.963714Z10774 Queryshow fields from `checkpoint_lox`2021-08-18T02:54:47.964505Z10774 QueryUSE `scsales_prd`2021-08-18T02:54:47.964649Z10774 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.964765Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.964870Z10774 Queryshow create table `checkpoint`2021-08-18T02:54:47.965515Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.965784Z10774 Queryshow fields from `checkpoint`2021-08-18T02:54:47.966688Z10774 QueryUSE `scsales_prd`2021-08-18T02:54:47.966834Z10774 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.966946Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.967056Z10774 Queryshow create table `T_HM_PropertyRight`2021-08-18T02:54:47.968003Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.968392Z10774 Queryshow fields from `T_HM_PropertyRight`2021-08-18T02:54:47.969391Z10774 QueryUSE `scsales_prd`2021-08-18T02:54:47.969545Z10774 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.969654Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.969768Z10774 Queryshow create table `T_HM_OWNER`2021-08-18T02:54:47.970455Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.970746Z10774 Queryshow fields from `T_HM_OWNER`2021-08-18T02:54:47.971629Z10774 QueryUSE `scsales_prd`2021-08-18T02:54:47.971773Z10774 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.971879Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.971988Z10774 Queryshow create table `T_HM_HOUSE`2021-08-18T02:54:47.974079Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.974989Z10774 Queryshow fields from `T_HM_HOUSE`2021-08-18T02:54:47.976496Z10774 QueryUSE `scsales_prd`2021-08-18T02:54:47.976642Z10774 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.976758Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.976863Z10774 Queryshow create table `T_HM_HOUSEDEL`2021-08-18T02:54:47.978141Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.978664Z10774 Queryshow fields from `T_HM_HOUSEDEL`2021-08-18T02:54:47.979805Z10774 QueryUSE `test`2021-08-18T02:54:47.979945Z10774 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.980055Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.980176Z10774 Queryshow create table `t1`2021-08-18T02:54:47.980557Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.980725Z10774 Queryshow fields from `t1`2021-08-18T02:54:47.981470Z10774 QueryUSE `lzm`2021-08-18T02:54:47.981618Z10774 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.981735Z10774 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.981846Z10774 Queryshow create table `sbtest1`2021-08-18T02:54:47.982288Z10774 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.982477Z10774 Queryshow fields from `sbtest1`2021-08-18T02:54:47.983926Z10774 QuerySHOW CREATE USER 'donor'@'%'2021-08-18T02:54:47.984156Z10774 QuerySHOW CREATE USER 'lzm'@'%'2021-08-18T02:54:47.984331Z10774 QuerySHOW CREATE USER 'proxyjiankong'@'%'2021-08-18T02:54:47.984497Z10774 QuerySHOW CREATE USER 'repl_mgr'@'%'2021-08-18T02:54:47.984657Z10774 QuerySHOW CREATE USER 'root'@'127.0.0.1'2021-08-18T02:54:47.984820Z10774 QuerySHOW CREATE USER 'root'@'localhost'2021-08-18T02:54:47.984979Z10774 QuerySHOW GRANTS FOR 'donor'@'%'2021-08-18T02:54:47.985114Z10774 QuerySHOW GRANTS FOR 'lzm'@'%'2021-08-18T02:54:47.985340Z10774 QuerySHOW GRANTS FOR 'proxyjiankong'@'%'2021-08-18T02:54:47.985466Z10774 QuerySHOW GRANTS FOR 'repl_mgr'@'%'2021-08-18T02:54:47.985593Z10774 QuerySHOW GRANTS FOR 'root'@'127.0.0.1'2021-08-18T02:54:47.985816Z10774 QuerySHOW GRANTS FOR 'root'@'localhost'2021-08-18T02:54:47.986271Z10780 QuerySHOW CREATE DATABASE IF NOT EXISTS crm_prd2021-08-18T02:54:47.986286Z10778 QueryUSE `scsales_prd`2021-08-18T02:54:47.986313Z10782 QuerySHOW CREATE DATABASE IF NOT EXISTS scsales_prd2021-08-18T02:54:47.986440Z10776 QueryUSE `crm_prd`2021-08-18T02:54:47.986459Z10775 QueryUSE `scsales_prd`2021-08-18T02:54:47.986526Z10780 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.986536Z10778 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.986567Z10782 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.986634Z10776 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.986686Z10780 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.986720Z10775 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.986761Z10776 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.986815Z10782 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.986749Z10779 QueryUSE `scsales_prd`2021-08-18T02:54:47.986724Z10778 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.987039Z10776 Queryshow create table `T_CM_CUST`2021-08-18T02:54:47.987160Z10782 QuerySHOW CREATE DATABASE IF NOT EXISTS test2021-08-18T02:54:47.987290Z10778 Queryshow create table `T_HM_PropertyRight`2021-08-18T02:54:47.987337Z10782 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.986742Z10777 QueryUSE `scsales_prd`2021-08-18T02:54:47.986955Z10775 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.987046Z10780 QueryUSE `scsales_prd`2021-08-18T02:54:47.987510Z10776 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.987526Z10782 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.987493Z10779 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.987660Z10778 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.987680Z10780 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.987666Z10777 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.987744Z10779 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.987687Z10775 Queryshow create table `checkpoint`2021-08-18T02:54:47.986782Z10781 QueryUSE `scsales_prd`2021-08-18T02:54:47.987818Z10780 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.987869Z10779 Queryshow create table `checkpoint_lox`2021-08-18T02:54:47.987950Z10780 Queryshow create table `T_HM_HOUSEDEL`2021-08-18T02:54:47.988012Z10782 QueryUSE `test`2021-08-18T02:54:47.988124Z10777 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.988152Z10781 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.988130Z10778 Queryshow fields from `T_HM_PropertyRight`2021-08-18T02:54:47.988238Z10775 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.988323Z10777 Queryshow create table `T_HM_HOUSE`2021-08-18T02:54:47.988369Z10780 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.988653Z10782 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.988759Z10782 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.988862Z10782 Queryshow create table `t1`2021-08-18T02:54:47.988997Z10775 Queryshow fields from `checkpoint`2021-08-18T02:54:47.989071Z10782 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.989168Z10780 Queryshow fields from `T_HM_HOUSEDEL`2021-08-18T02:54:47.989670Z10781 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.989782Z10776 Queryshow fields from `T_CM_CUST`2021-08-18T02:54:47.990394Z10777 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.990492Z10782 Queryshow fields from `t1`2021-08-18T02:54:47.991172Z10778 QuerySHOW CREATE DATABASE IF NOT EXISTS lzm2021-08-18T02:54:47.991252Z10781 Queryshow create table `T_HM_OWNER`2021-08-18T02:54:47.991400Z10777 Queryshow fields from `T_HM_HOUSE`2021-08-18T02:54:47.991427Z10778 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.991506Z10779 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.991559Z10781 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.991615Z10775 QueryUSE `lzm`2021-08-18T02:54:47.991774Z10780 QuerySELECT SQL_NO_CACHE `PKID` FROM `crm_prd`.`T_CM_CUST` ORDER BY `PKID` LIMIT 12021-08-18T02:54:47.991827Z10775 QuerySET SQL_QUOTE_SHOW_CREATE=12021-08-18T02:54:47.991931Z10779 Queryshow fields from `checkpoint_lox`2021-08-18T02:54:47.992013Z10775 QuerySET SESSION character_set_results = 'binary'2021-08-18T02:54:47.992112Z10780 QuerySELECT SQL_NO_CACHE `PKID` FROM `crm_prd`.`T_CM_CUST` ORDER BY `PKID` DESC LIMIT 12021-08-18T02:54:47.992176Z10776 QuerySELECT SQL_NO_CACHE `group_name`, `group_key`, `log_cmplt_csn`, `log_cmplt_xids_seq` FROM `scsales_prd`.`checkpoint_lox` ORDER BY `group_name`, `group_key`, `log_cmplt_csn`, `log_cmplt_xids_seq` LIMIT 12021-08-18T02:54:47.992423Z10775 Queryshow create table `sbtest1`2021-08-18T02:54:47.992542Z10780 QuerySELECT SQL_NO_CACHE `pkid` FROM `scsales_prd`.`T_HM_PropertyRight` ORDER BY `pkid` LIMIT 12021-08-18T02:54:47.992640Z10776 QuerySELECT SQL_NO_CACHE `pkid` FROM `scsales_prd`.`T_HM_OWNER` ORDER BY `pkid` LIMIT 12021-08-18T02:54:47.992863Z10780 QuerySELECT SQL_NO_CACHE `pkid` FROM `scsales_prd`.`T_HM_PropertyRight` ORDER BY `pkid` DESC LIMIT 12021-08-18T02:54:47.992882Z10775 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.992963Z10776 QuerySELECT SQL_NO_CACHE `pkid` FROM `scsales_prd`.`T_HM_OWNER` ORDER BY `pkid` DESC LIMIT 12021-08-18T02:54:47.993163Z10780 QuerySELECT SQL_NO_CACHE `pkid` FROM `scsales_prd`.`T_HM_HOUSE` ORDER BY `pkid` LIMIT 12021-08-18T02:54:47.993178Z10782 QuerySELECT SQL_NO_CACHE `group_name`, `group_key` FROM `scsales_prd`.`checkpoint` ORDER BY `group_name`, `group_key` LIMIT 12021-08-18T02:54:47.993300Z10778 QuerySET SESSION character_set_results = 'utf8mb4'2021-08-18T02:54:47.993303Z10781 Queryshow fields from `T_HM_OWNER`2021-08-18T02:54:47.993401Z10776 QuerySELECT SQL_NO_CACHE `pkid` FROM `scsales_prd`.`T_HM_HOUSEDEL` ORDER BY `pkid` LIMIT 12021-08-18T02:54:47.993528Z10780 QuerySELECT SQL_NO_CACHE `pkid` FROM `scsales_prd`.`T_HM_HOUSE` ORDER BY `pkid` DESC LIMIT 12021-08-18T02:54:47.993569Z10777 QuerySELECT SQL_NO_CACHE `id` FROM `lzm`.`sbtest1` ORDER BY `id` LIMIT 12021-08-18T02:54:47.993739Z10775 Queryshow fields from `sbtest1`2021-08-18T02:54:47.993774Z10778 QuerySELECT SQL_NO_CACHE `PKID`,`CUST_CODE`,`CUST_CATEGORY`,`CUST_STATUS`,`INVALID`,`INVALID_TIME`,`ORIGIN`,`CREATE_REASON_TYPE`,`BROKERAGECONTRACT_NO`,`IS_VIP`,`IS_INPOOL`,`IS_IMPORT`,`IMPORT_SRC`,`ORI_CUST_CODE`,`ORI_AGENT_ID`,`ORI_GRP_ID`,`REFER_USERID`,`CREATED_BY`,`CREATED_TIME`,`ACTIVE_TIME`,`INPOOL_TIME`,`BATCH_IMPORT`,`OLD_AGENCY_CODE`,`INVALID_USER`,`UPDATE_BY`,`UPDATE_TIME`,`BUSINESS_TYPE`,`APP_SOURCE`,`COMPANY_ID`,`ORIGIN_SECOND` FROM `crm_prd`.`T_CM_CUST` WHERE (`PKID` BETWEEN 58434474 AND 58438395) ORDER BY `PKID` /* mysqlsh dumpInstance, dumping table `crm_prd`.`T_CM_CUST`, chunk ID: 0 */2021-08-18T02:54:47.993904Z10780 QuerySELECT SQL_NO_CACHE `PKID`,`CUST_CODE`,`CUST_CATEGORY`,`CUST_STATUS`,`INVALID`,`INVALID_TIME`,`ORIGIN`,`CREATE_REASON_TYPE`,`BROKERAGECONTRACT_NO`,`IS_VIP`,`IS_INPOOL`,`IS_IMPORT`,`IMPORT_SRC`,`ORI_CUST_CODE`,`ORI_AGENT_ID`,`ORI_GRP_ID`,`REFER_USERID`,`CREATED_BY`,`CREATED_TIME`,`ACTIVE_TIME`,`INPOOL_TIME`,`BATCH_IMPORT`,`OLD_AGENCY_CODE`,`INVALID_USER`,`UPDATE_BY`,`UPDATE_TIME`,`BUSINESS_TYPE`,`APP_SOURCE`,`COMPANY_ID`,`ORIGIN_SECOND` FROM `crm_prd`.`T_CM_CUST` WHERE (`PKID` BETWEEN 58438396 AND 58442317) ORDER BY `PKID` /* mysqlsh dumpInstance, dumping table `crm_prd`.`T_CM_CUST`, chunk ID: 1 */2021-08-18T02:54:47.994686Z10782 QuerySELECT SQL_NO_CACHE `group_name`, `group_key` FROM `scsales_prd`.`checkpoint` ORDER BY `group_name` DESC, `group_key` DESC LIMIT 12021-08-18T02:54:47.994763Z10779 QuerySELECT SQL_NO_CACHE `c1` FROM `test`.`t1` ORDER BY `c1` LIMIT 12021-08-18T02:54:47.994977Z10775 QuerySELECT SQL_NO_CACHE `PKID`,`CUST_CODE`,`CUST_CATEGORY`,`CUST_STATUS`,`INVALID`,`INVALID_TIME`,`ORIGIN`,`CREATE_REASON_TYPE`,`BROKERAGECONTRACT_NO`,`IS_VIP`,`IS_INPOOL`,`IS_IMPORT`,`IMPORT_SRC`,`ORI_CUST_CODE`,`ORI_AGENT_ID`,`ORI_GRP_ID`,`REFER_USERID`,`CREATED_BY`,`CREATED_TIME`,`ACTIVE_TIME`,`INPOOL_TIME`,`BATCH_IMPORT`,`OLD_AGENCY_CODE`,`INVALID_USER`,`UPDATE_BY`,`UPDATE_TIME`,`BUSINESS_TYPE`,`APP_SOURCE`,`COMPANY_ID`,`ORIGIN_SECOND` FROM `crm_prd`.`T_CM_CUST` WHERE (`PKID` BETWEEN 58442318 AND 58446239) ORDER BY `PKID` /* mysqlsh dumpInstance, dumping table `crm_prd`.`T_CM_CUST`, chunk ID: 2 */2021-08-18T02:54:47.995042Z10779 QuerySELECT SQL_NO_CACHE `c1` FROM `test`.`t1` ORDER BY `c1` DESC LIMIT 12021-08-18T02:54:47.994981Z10776 QuerySELECT SQL_NO_CACHE `pkid` FROM `scsales_prd`.`T_HM_HOUSEDEL` ORDER BY `pkid` DESC LIMIT 12021-08-18T02:54:47.995344Z10781 QuerySELECT SQL_NO_CACHE `PKID`,`CUST_CODE`,`CUST_CATEGORY`,`CUST_STATUS`,`INVALID`,`INVALID_TIME`,`ORIGIN`,`CREATE_REASON_TYPE`,`BROKERAGECONTRACT_NO`,`IS_VIP`,`IS_INPOOL`,`IS_IMPORT`,`IMPORT_SRC`,`ORI_CUST_CODE`,`ORI_AGENT_ID`,`ORI_GRP_ID`,`REFER_USERID`,`CREATED_BY`,`CREATED_TIME`,`ACTIVE_TIME`,`INPOOL_TIME`,`BATCH_IMPORT`,`OLD_AGENCY_CODE`,`INVALID_USER`,`UPDATE_BY`,`UPDATE_TIME`,`BUSINESS_TYPE`,`APP_SOURCE`,`COMPANY_ID`,`ORIGIN_SECOND` FROM `crm_prd`.`T_CM_CUST` WHERE (`PKID` BETWEEN 58446240 AND 58446241) ORDER BY `PKID` /* mysqlsh dumpInstance, dumping table `crm_prd`.`T_CM_CUST`, chunk ID: 3 */2021-08-18T02:54:47.995642Z10779 QuerySELECT SQL_NO_CACHE `group_name`,`group_key`,`log_cmplt_csn`,`log_cmplt_xids_seq`,`log_cmplt_xids` FROM `scsales_prd`.`checkpoint_lox` ORDER BY `group_name`, `group_key`, `log_cmplt_csn`, `log_cmplt_xids_seq` /* mysqlsh dumpInstance, dumping table `scsales_prd`.`checkpoint_lox`, chunk ID: 1 */2021-08-18T02:54:47.995825Z10776 QuerySELECT SQL_NO_CACHE `pkid`,`HOUSE_ID`,`PR_TYPE`,`PR_CODE`,`PR_DATE`,`PR_ADDRESS`,`PR_OWNER`,`PR_OWNER_NAME`,`LAND_CERT_CODE`,`PARTI_OWNER`,`PARTI_TYPE`,`CREATE_BY`,`CREATE_TIME`,`IS_LATEST`,`PRICE_ORIGINAL`,`IS_LOAN`,`IS_LOCK`,`IS_FIRST_LOAN`,`SURPLUS_LOAN`,`flag`,`PR_MORTGAGE_TYPE`,`PR_PEOPLE_TYPE`,`PR_TOTAL`,`PR_SCHOOL`,`PR_LOAN_PRICE` FROM `scsales_prd`.`T_HM_PropertyRight` WHERE (`pkid` BETWEEN 3451171 AND 3453451) ORDER BY `pkid` /* mysqlsh dumpInstance, dumping table `scsales_prd`.`T_HM_PropertyRight`, chunk ID: 0 */2021-08-18T02:54:48.003541Z10781 QuerySELECT SQL_NO_CACHE `pkid`,`STANDARD_ID`,`CITY_CODE`,`DISTRICT_CODE`,`RESBLOCK_ID`,`BUILDING_ID`,`BUILDING_NAME`,`ESTATE_ID`,`ESTATE_NAME`,`TOTAL_FLOOR`,`FLOOR_ALIAS`,`FLOOR`,`HOU_ADDR`,`ROOM_NO`,`MAILBOX_NO`,`IS_EXCHANGE`,`BEDROOM_AMOUNT`,`PARLOR_AMOUNT`,`COOKROOM_AMOUNT`,`TOILET_AMOUNT`,`BALCONY_AMOUNT`,`WAREHOUSE_AMOUNT`,`GARDEN_AMOUNT`,`TERRACE_AMOUNT`,`PROPERTY_FEE`,`BUILD_SIZE`,`USE_SIZE`,`NET_REG_SIZE`,`BUILD_END_YEAR`,`BUILDING_TYPE`,`PROPERTY_TYPE`,`ORIENTATION`,`USAGE_TYPE`,`SCENE`,`IS_PIVOT_FRAME`,`FRAME_CODE`,`FRAME_CODE_TYPE`,`PARLOR_SIZE`,`BEDROOM_SIZE`,`SANCTUM_SIZE`,`COOKROOM_SIZE`,`TOILET_SIZE`,`BALCONY_SIZE`,`WAREHOUSE_SIZE`,`GARDEN_SIZE`,`TERRACE_SIZE`,`IS_ANEAR_SUBWAY`,`IS_SCHOOL_DISTRICT`,`SCHOOL_QUOTA`,`IS_ECESIS`,`FITMENT_TYPE`,`FITMENT_AGE`,`IS_REBUILD`,`CREATED_BY`,`CREATED_TIME`,`UPDATED_BY`,`UPDATED_TIME`,`AGENCY_ID`,`OWENER_TIME`,`AGENCY_MARK`,`IS_HIDDEN_HOUSEROOM`,`IS_HIDDEN`,`IS_HIDDEN_USER`,`IS_HIDDEN_TIME`,`IS_HIDDEN_ORGID`,`isSold`,`isRent`,`IS_LOCK_AREA`,`isSoldOrRent`,`SUBBUILDINGSIZETYPE`,`SUBBUILDINGSIZE`,`is_deleted`,`flag`,`HAS_HOUDEL`,`UNIT_ID`,`UNIT_NAME`,`UNLUCKY` FROM `scsales_prd`.`T_HM_HOUSE` WHERE (`pkid` BETWEEN 700272664 AND 700273833) ORDER BY `pkid` /* mysqlsh dumpInstance, dumping table `scsales_prd`.`T_HM_HOUSE`, chunk ID: 0 */2021-08-18T02:54:48.004694Z10777 QuerySELECT SQL_NO_CACHE `id` FROM `lzm`.`sbtest1` ORDER BY `id` DESC LIMIT 12021-08-18T02:54:48.005040Z10779 QuerySELECT SQL_NO_CACHE `pkid`,`PR_ID`,`PARTI_ID`,`CONTRACT_TYPE`,`CREATE_BY`,`CREATE_TIME`,`STATUS`,`UPDATE_BY`,`UPDATE_TIME`,`GROUP_ID`,`PARTI_ID_TEL`,`NAME`,`COMPANYID`,`FIRST_TAG`,`SECOND_TAG` FROM `scsales_prd`.`T_HM_OWNER` WHERE (`pkid` BETWEEN 13893535 AND 13899359) ORDER BY `pkid` /* mysqlsh dumpInstance, dumping table `scsales_prd`.`T_HM_OWNER`, chunk ID: 0 */2021-08-18T02:54:48.008704Z10776 QuerySELECT SQL_NO_CACHE `pkid`,`HOUSE_ID`,`PR_ID`,`HOUDEL_CODE`,`DELEGATION_CLIENT_ID`,`DELEGATION_TYPE`,`DELEGATION_SOURCE`,`DEL_DATE`,`RANK`,`SALE_REASON`,`STATE`,`CREAT_TIME`,`DESCR`,`NO_DISTURB`,`UPDATE_BY`,`UPDATE_TIME`,`ACTIVE_TIME`,`GRP_ID`,`CREATE_BY`,`price`,`UNIT_PRICE`,`CHANGE_ORIENT`,`refer_id`,`NO_DISTURB_USER`,`NO_DISTURB_MGRLINE`,`NO_DISTURB_DATE`,`LOOK_HOUSE_TIME`,`TRANSFER_HOUSE_TIME`,`MORTGAGE`,`PAY`,`RENT_TYPE`,`companyid`,`SELL_DESCR`,`DELEGATION_SOURCE_SECOND`,`REMARK_GRADE`,`REMARK_CONTENT`,`TRADE_YEAR`,`ONLY_HOUSE` FROM `scsales_prd`.`T_HM_HOUSEDEL` WHERE (`pkid` BETWEEN 45391988 AND 45394607) ORDER BY `pkid` /* mysqlsh dumpInstance, dumping table `scsales_prd`.`T_HM_HOUSEDEL`, chunk ID: 0 */2021-08-18T02:54:48.009505Z10777 QuerySELECT SQL_NO_CACHE `c1`,`c2` FROM `test`.`t1` WHERE (`c1` BETWEEN 1 AND 1) ORDER BY `c1` /* mysqlsh dumpInstance, dumping table `test`.`t1`, chunk ID: 0 */2021-08-18T02:54:48.009698Z10782 QuerySELECT SQL_NO_CACHE `group_name`,`group_key` FROM `scsales_prd`.`checkpoint` WHERE (`group_name`>'REPA' OR(`group_name`='REPA' AND(`group_key`>='1699064716'))) ORDER BY `group_name`, `group_key` LIMIT 3905,2 /* mysqlsh dumpInstance, chunking table `scsales_prd`.`checkpoint`, chunk ID: 0 */2021-08-18T02:54:48.011500Z10782 QuerySELECT SQL_NO_CACHE `pkid`,`HOUSE_ID`,`PR_ID`,`HOUDEL_CODE`,`DELEGATION_CLIENT_ID`,`DELEGATION_TYPE`,`DELEGATION_SOURCE`,`DEL_DATE`,`RANK`,`SALE_REASON`,`STATE`,`CREAT_TIME`,`DESCR`,`NO_DISTURB`,`UPDATE_BY`,`UPDATE_TIME`,`ACTIVE_TIME`,`GRP_ID`,`CREATE_BY`,`price`,`UNIT_PRICE`,`CHANGE_ORIENT`,`refer_id`,`NO_DISTURB_USER`,`NO_DISTURB_MGRLINE`,`NO_DISTURB_DATE`,`LOOK_HOUSE_TIME`,`TRANSFER_HOUSE_TIME`,`MORTGAGE`,`PAY`,`RENT_TYPE`,`companyid`,`SELL_DESCR`,`DELEGATION_SOURCE_SECOND`,`REMARK_GRADE`,`REMARK_CONTENT`,`TRADE_YEAR`,`ONLY_HOUSE` FROM `scsales_prd`.`T_HM_HOUSEDEL` WHERE (`pkid` BETWEEN 45394608 AND 45397227) ORDER BY `pkid` /* mysqlsh dumpInstance, dumping table `scsales_prd`.`T_HM_HOUSEDEL`, chunk ID: 1 */2021-08-18T02:54:48.013940Z10777 QuerySELECT SQL_NO_CACHE `pkid`,`HOUSE_ID`,`PR_ID`,`HOUDEL_CODE`,`DELEGATION_CLIENT_ID`,`DELEGATION_TYPE`,`DELEGATION_SOURCE`,`DEL_DATE`,`RANK`,`SALE_REASON`,`STATE`,`CREAT_TIME`,`DESCR`,`NO_DISTURB`,`UPDATE_BY`,`UPDATE_TIME`,`ACTIVE_TIME`,`GRP_ID`,`CREATE_BY`,`price`,`UNIT_PRICE`,`CHANGE_ORIENT`,`refer_id`,`NO_DISTURB_USER`,`NO_DISTURB_MGRLINE`,`NO_DISTURB_DATE`,`LOOK_HOUSE_TIME`,`TRANSFER_HOUSE_TIME`,`MORTGAGE`,`PAY`,`RENT_TYPE`,`companyid`,`SELL_DESCR`,`DELEGATION_SOURCE_SECOND`,`REMARK_GRADE`,`REMARK_CONTENT`,`TRADE_YEAR`,`ONLY_HOUSE` FROM `scsales_prd`.`T_HM_HOUSEDEL` WHERE (`pkid` BETWEEN 45397228 AND 45399847) ORDER BY `pkid` /* mysqlsh dumpInstance, dumping table `scsales_prd`.`T_HM_HOUSEDEL`, chunk ID: 2 */2021-08-18T02:54:48.019504Z10778 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 1 AND 4545) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 0 */2021-08-18T02:54:48.019755Z10781 QuerySELECT SQL_NO_CACHE `pkid`,`HOUSE_ID`,`PR_ID`,`HOUDEL_CODE`,`DELEGATION_CLIENT_ID`,`DELEGATION_TYPE`,`DELEGATION_SOURCE`,`DEL_DATE`,`RANK`,`SALE_REASON`,`STATE`,`CREAT_TIME`,`DESCR`,`NO_DISTURB`,`UPDATE_BY`,`UPDATE_TIME`,`ACTIVE_TIME`,`GRP_ID`,`CREATE_BY`,`price`,`UNIT_PRICE`,`CHANGE_ORIENT`,`refer_id`,`NO_DISTURB_USER`,`NO_DISTURB_MGRLINE`,`NO_DISTURB_DATE`,`LOOK_HOUSE_TIME`,`TRANSFER_HOUSE_TIME`,`MORTGAGE`,`PAY`,`RENT_TYPE`,`companyid`,`SELL_DESCR`,`DELEGATION_SOURCE_SECOND`,`REMARK_GRADE`,`REMARK_CONTENT`,`TRADE_YEAR`,`ONLY_HOUSE` FROM `scsales_prd`.`T_HM_HOUSEDEL` WHERE (`pkid` BETWEEN 45399848 AND 45399850) ORDER BY `pkid` /* mysqlsh dumpInstance, dumping table `scsales_prd`.`T_HM_HOUSEDEL`, chunk ID: 3 */2021-08-18T02:54:48.024131Z10781 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 4546 AND 9090) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 1 */2021-08-18T02:54:48.028736Z10775 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 9091 AND 13635) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 2 */2021-08-18T02:54:48.029177Z10780 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 13636 AND 18180) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 3 */2021-08-18T02:54:48.029739Z10779 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 18181 AND 22725) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 4 */2021-08-18T02:54:48.034423Z10776 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 22726 AND 27270) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 5 */2021-08-18T02:54:48.038865Z10777 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 27271 AND 31815) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 6 */2021-08-18T02:54:48.044310Z10778 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 31816 AND 36360) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 7 */2021-08-18T02:54:48.044400Z10782 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 36361 AND 40905) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 8 */2021-08-18T02:54:48.058642Z10781 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 40906 AND 45450) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 9 */2021-08-18T02:54:48.058713Z10775 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 54541 AND 59085) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 12 */2021-08-18T02:54:48.058713Z10779 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 49996 AND 54540) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 11 */2021-08-18T02:54:48.059698Z10776 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 59086 AND 63630) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 13 */2021-08-18T02:54:48.060463Z10780 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 45451 AND 49995) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 10 */2021-08-18T02:54:48.062447Z10777 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 63631 AND 68175) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 14 */2021-08-18T02:54:48.072659Z10782 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 68176 AND 72720) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 15 */2021-08-18T02:54:48.080263Z10778 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 72721 AND 77265) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 16 */2021-08-18T02:54:48.083572Z10775 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 81811 AND 86355) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 18 */2021-08-18T02:54:48.084676Z10779 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 77266 AND 81810) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 17 */2021-08-18T02:54:48.088715Z10781 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 86356 AND 90900) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 19 */2021-08-18T02:54:48.088763Z10776 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 90901 AND 95445) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 20 */2021-08-18T02:54:48.089072Z10777 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 95446 AND 99990) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 21 */2021-08-18T02:54:48.091615Z10780 QuerySELECT SQL_NO_CACHE `id`,`k`,`c`,`pad` FROM `lzm`.`sbtest1` WHERE (`id` BETWEEN 99991 AND 100000) ORDER BY `id` /* mysqlsh dumpInstance, dumping table `lzm`.`sbtest1`, chunk ID: 22 */2021-08-18T02:54:48.094077Z10780 QuerySELECT SQL_NO_CACHE `group_name`,`group_key`,`seqno`,`rba`,`audit_ts`,`create_ts`,`last_update_ts`,`current_dir`,`log_bsn`,`log_csn`,`log_xid`,`log_cmplt_csn`,`log_cmplt_xids`,`version` FROM `scsales_prd`.`checkpoint` WHERE ((`group_name`>'REPA' OR(`group_name`='REPA' AND(`group_key`>='1699064716')))AND(`group_name`<'REPA' OR(`group_name`='REPA' AND(`group_key`<='1699064716')))) ORDER BY `group_name`, `group_key` /* mysqlsh dumpInstance, dumping table `scsales_prd`.`checkpoint`, chunk ID: 0 */2021-08-18T02:54:48.096581Z10780 Quit2021-08-18T02:54:48.098476Z10782 Quit2021-08-18T02:54:48.104479Z10778 Quit2021-08-18T02:54:48.105438Z10775 Quit2021-08-18T02:54:48.109171Z10779 Quit2021-08-18T02:54:48.114663Z10781 Quit2021-08-18T02:54:48.114686Z10777 Quit2021-08-18T02:54:48.114693Z10776 Quit2021-08-18T02:54:48.115061Z10774 Quit2021-08-18T02:54:52.123209Z10783 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:52.123534Z10783 QuerySET NAMES utf82021-08-18T02:54:52.123743Z10783 Queryset autocommit=02021-08-18T02:54:52.123915Z10783 Init DBinformation_schema2021-08-18T02:54:52.124073Z10783 Queryshow global variables2021-08-18T02:54:52.129188Z10783 Queryshow global status2021-08-18T02:54:53.133325Z10783 Queryshow global status2021-08-18T02:54:53.136369Z10783 Queryselect count(1) from processlist where state <> '' and user <> 'repl' and time > 22021-08-18T02:54:53.137221Z10783 Queryshow slave status2021-08-18T02:54:53.154499Z10783 Queryselect * from information_schema.processlist where DB !='information_schema' and command !='Sleep'2021-08-18T02:54:53.154990Z10783 Queryselect SUBSTRING_INDEX(host,':',1) as connect_server, user connect_user,db connect_db, count(SUBSTRING_INDEX(host,':',1)) as connect_count from information_schema.processlist where db is not null and db!='information_schema' and db !='performance_schema' group by connect_server2021-08-18T02:54:56.164583Z10784 Connectlzm@10.10.119.101 on using SSL/TLS2021-08-18T02:54:56.164965Z10784 QuerySET NAMES utf82021-08-18T02:54:56.165182Z10784 Queryset autocommit=02021-08-18T02:54:56.165341Z10784 Init DBinformation_schema2021-08-18T02:54:56.173207Z10783 Quit2021-08-18T02:54:56.173216Z10784 Quit

原理:

结合两个日志可以看到mysqlshell的备份分为以下几步:1. 连接目标数据库.目标数据库会检查连接用户的权限.如果连接用户权限不足会报错.比如没有backup_admin权限2. 执行FLUSH TABLES WITH READ LOCK,获取一致性快照.利用MVCC.3. 获取各种系统信息,包括但不限于用户信息及schema以及二进制日志位点信息4. 执行LOCK INSTANCE FOR BACKUP 开始备份,释放全局只读锁5. 先备份用户信息及权限6. 开始备份schema.先获取schema的DDL语句.再获取表的DDL语句7. 如果开启并行.则开始并行备份表数据.如果开启了analyze table则在备份完毕.并行执行analyze8. 在最后备份完毕时通过show slave status将binlog位点信息写入对应文件

mysqlshell备份的注意项

1. 必须是mysql的GA版本2. mysqlshell8026之前不能备份5.6的用户信息.从8026开始支持备份5.6的用户3. 只支持innodb热备.一致性备份4. 备份用户最小权限:backup_admin event reload select show view trigger5. 从mysqlshell8024版本开始备份用户需要有replication client权限.用于获取binlog位点等信息6. 一定要开始兼容性检查,兼容性检查必须都是innodb的7. 尽量让每个表都有主键.

mysqlshell备份导入注意项

1. 必须开启local_infile 在配置文件中设置