mysql数据库备份方法 mysql备份数据库命令( 二 )

2021-08-18T02:54:47.923098Z10758 QuerySELECT @@GLOBAL.port2021-08-18T02:54:47.926847Z10774 Connectlzm@10.10.119.101 onusing 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 onusing 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 onusing SSL/TLS2021-08-18T02:54:47.940945Z10778 Connectlzm@10.10.119.101 onusing SSL/TLS2021-08-18T02:54:47.940985Z10776 QuerySET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ2021-08-18T02:54:47.941056Z10782 Connectlzm@10.10.119.101 onusing SSL/TLS2021-08-18T02:54:47.941133Z10776 QuerySTART TRANSACTION WITH CONSISTENT SNAPSHOT2021-08-18T02:54:47.941180Z10775 Connectlzm@10.10.119.101 onusing 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 onusing 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 onusing 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 onusing 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 onusing 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_countfrom 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 onusing 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原理:

以上关于本文的内容，仅作参考！温馨提示：如遇健康、疾病相关的问题，请您及时就医或请专业人士给予相关指导!

「四川龙网」www.sichuanlong.com小编还为您精选了以下内容，希望对您有所帮助：