pt-archiver 归档表无主键的问题探索

问题描述

一张没有主键的表,归档时发现归档后的数据行数不准确,少了很多。

场景模拟

表结构和数据

准备两张表 table_demo 和 table_demo1

主键 归档表
table_demo Yes table_demo_history
table_demo1 NO table_demo1_history
CREATE TABLE table_demo(  
id int auto_increment primary key,
uname varchar(20) ,
ucreatetime datetime ,
age int(11)) DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE table_demo1(
id int,
uname varchar(20) ,
ucreatetime datetime ,
age int(11)) DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci;


alter table table_demo add index idx_ucreatetime (ucreatetime);
alter table table_demo1 add index idx_ucreatetime (ucreatetime);

delimiter $$
create procedure test1()
begin
declare v_cnt decimal (10) default 0 ;
start transaction;
dd:loop

insert into table_demo values
(null,'用户1',sysdate(),20),
(null,'用户2',sysdate(),20),
(null,'用户3',sysdate(),20),
(null,'用户4',sysdate(),20),
(null,'用户5',sysdate(),20),
(null,'用户6',sysdate(),20),
(null,'用户7',sysdate(),20),
(null,'用户8',sysdate(),20),
(null,'用户9',sysdate(),20),
(null,'用户0',sysdate(),20)
;
set v_cnt = v_cnt+10 ;
if v_cnt = 1000 then leave dd;
end if;
end loop dd ;
commit;
end $$


delimiter ;
call test1();

insert into table_demo1 select * from table_demo;
select count(*) from table_demo1;
update table_demo1 set ucreatetime="2020-09-02 11:51:27" where id between 200 and 300;
update table_demo1 set ucreatetime="2020-09-03 11:51:27" where id between 300 and 400;
update table_demo1 set ucreatetime="2020-09-04 11:51:27" where id between 400 and 500;
update table_demo1 set ucreatetime="2020-09-05 11:51:27" where id between 500 and 600;
update table_demo1 set ucreatetime="2020-09-06 11:51:27" where id between 600 and 700;
update table_demo1 set ucreatetime="2020-09-07 11:51:27" where id between 700 and 800;
update table_demo1 set ucreatetime="2020-09-08 11:51:27" where id between 800 and 900;
update table_demo1 set ucreatetime="2020-09-09 11:51:27" where id between 900 and 1000;

update table_demo set ucreatetime="2020-09-02 11:51:27" where id between 200 and 300;
update table_demo set ucreatetime="2020-09-03 11:51:27" where id between 300 and 400;
update table_demo set ucreatetime="2020-09-04 11:51:27" where id between 400 and 500;
update table_demo set ucreatetime="2020-09-05 11:51:27" where id between 500 and 600;
update table_demo set ucreatetime="2020-09-06 11:51:27" where id between 600 and 700;
update table_demo set ucreatetime="2020-09-07 11:51:27" where id between 700 and 800;
update table_demo set ucreatetime="2020-09-08 11:51:27" where id between 800 and 900;
update table_demo set ucreatetime="2020-09-09 11:51:27" where id between 900 and 1000;


select count(*), ucreatetime from table_demo group by ucreatetime;
select count(*), ucreatetime from table_demo1 group by ucreatetime;

create table table_demo1_history like table_demo1;
create table table_demo_history like table_demo;
create table table_demo1_history1 like table_demo1;

truncate table table_demo_history;
truncate table table_demo1_history;
truncate table table_demo1_history1;

开启general_log

# 开启general_log,具体操作如下:
show variables like '%general_log%';
SET GLOBAL general_log = 'OFF';
SET GLOBAL general_log = 'ON';
show variables like '%general_log%';

归档命令

#  table_demo 有主键
pt-archiver --source h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo --dest h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo_history --no-check-charset --where "ucreatetime >= '2020-09-01 11:51:26'" --progress 5000 --limit=10 --txn-size=10 --statistics --bulk-insert --no-delete --charset 'utf8' --noversion-check
# table_demo1 无主键 --limit 10
pt-archiver --source h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo1 --dest h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo1_history --no-check-charset --where "ucreatetime >= '2020-09-01 11:51:26'" --progress 5000 --limit=10 --txn-size=10 --statistics --bulk-insert --no-delete --charset 'utf8' --noversion-check
# table_demo1 无主键 --limit 500
pt-archiver --source h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo1 --dest h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo1_history1 --no-check-charset --where "ucreatetime >= '2020-09-01 11:51:26'" --progress 5000 --limit=500 --txn-size=10 --statistics --bulk-insert --no-delete --charset 'utf8' --noversion-check

验证数据

select count(*), ucreatetime from table_demo_history group by ucreatetime;
select count(*), ucreatetime from table_demo1_history1 group by ucreatetime;
select count(*), ucreatetime from table_demo1_history group by ucreatetime;

操作记录

[root@NB-flexgw1:/root]# pt-archiver --version
pt-archiver 3.0.4
[root@NB-flexgw1:/root]# mysql --version
mysql Ver 14.14 Distrib 5.7.20-19, for Linux (x86_64) using EditLine wrapper

root@MySQL-01 12:09: [qixin]> select count(*), ucreatetime from table_demo1 group by ucreatetime;
+----------+---------------------+
| count(*) | ucreatetime |
+----------+---------------------+
| 199 | 2020-09-01 11:51:26 |
| 100 | 2020-09-02 11:51:27 |
| 100 | 2020-09-03 11:51:27 |
| 100 | 2020-09-04 11:51:27 |
| 100 | 2020-09-05 11:51:27 |
| 100 | 2020-09-06 11:51:27 |
| 100 | 2020-09-07 11:51:27 |
| 100 | 2020-09-08 11:51:27 |
| 101 | 2020-09-09 11:51:27 |
+----------+---------------------+
9 rows in set (0.00 sec)

root@MySQL-01 12:09: [qixin]> select count(*), ucreatetime from table_demo group by ucreatetime;
+----------+---------------------+
| count(*) | ucreatetime |
+----------+---------------------+
| 199 | 2020-09-01 11:51:26 |
| 100 | 2020-09-02 11:51:27 |
| 100 | 2020-09-03 11:51:27 |
| 100 | 2020-09-04 11:51:27 |
| 100 | 2020-09-05 11:51:27 |
| 100 | 2020-09-06 11:51:27 |
| 100 | 2020-09-07 11:51:27 |
| 100 | 2020-09-08 11:51:27 |
| 101 | 2020-09-09 11:51:27 |
+----------+---------------------+
9 rows in set (0.00 sec)



root@MySQL-01 12:41: [qixin]> show variables like '%general_log%';
+------------------+------------------------------------+
| Variable_name | Value |
+------------------+------------------------------------+
| general_log | ON |
| general_log_file | /alidata/mysql/data/NB-flexgw1.log |
+------------------+------------------------------------+
2 rows in set (0.00 sec)

--无索引的表
[root@NB-flexgw1:/root]# pt-archiver --source h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo1 --dest h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo1_history --no-check-charset --where "ucreatetime >= '2020-09-01 11:51:26'" --progress 5000 --limit=10 --txn-size=10 --statistics --bulk-insert --no-delete --charset 'utf8' --noversion-check
TIME ELAPSED COUNT
2020-09-01T12:06:04 0 0
2020-09-01T12:06:05 0 90
Started at 2020-09-01T12:06:04, ended at 2020-09-01T12:06:05
Source: A=utf8,D=qixin,P=3306,h=localhost,p=...,t=table_demo1,u=root
Dest: A=utf8,D=qixin,P=3306,h=localhost,p=...,t=table_demo1_history,u=root
SELECT 90
INSERT 90
DELETE 0
Action Count Time Pct
commit 20 0.7429 90.38
select 10 0.0261 3.18
bulk_inserting 9 0.0030 0.36
print_bulkfile 90 -0.0003 -0.03
other 0 0.0502 6.11


--有索引的表
[root@NB-flexgw1:/root]# pt-archiver --source h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo --dest h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo_history --no-check-charset --where "ucreatetime >= '2020-09-01 11:51:26'" --progress 5000 --limit=10 --txn-size=10 --statistics --bulk-insert --no-delete --charset 'utf8' --noversion-check
TIME ELAPSED COUNT
2020-09-01T12:11:10 0 0
2020-09-01T12:11:18 8 999
Started at 2020-09-01T12:11:10, ended at 2020-09-01T12:11:18
Source: A=utf8,D=qixin,P=3306,h=localhost,p=...,t=table_demo,u=root
Dest: A=utf8,D=qixin,P=3306,h=localhost,p=...,t=table_demo_history,u=root
SELECT 999
INSERT 999
DELETE 0
Action Count Time Pct
commit 200 8.1391 97.00
bulk_inserting 100 0.1428 1.70
select 101 0.0461 0.55
print_bulkfile 999 -0.0018 -0.02
other 0 0.0642 0.76

[root@NB-flexgw1:/root]# pt-archiver --source h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo1 --dest h=localhost,P=3306,u=root,p=root,D=qixin,t=table_demo1_history1 --no-check-charset --where "ucreatetime >= '2020-09-01 11:51:26'" --progress 5000 --limit=500 --txn-size=10 --statistics --bulk-insert --no-delete --charset 'utf8' --noversion-check
TIME ELAPSED COUNT
2020-09-01T15:24:52 0 0
2020-09-01T15:24:52 0 901
Started at 2020-09-01T15:24:52, ended at 2020-09-01T15:24:52
Source: A=utf8,D=qixin,P=3306,h=localhost,p=...,t=table_demo1,u=root
Dest: A=utf8,D=qixin,P=3306,h=localhost,p=...,t=table_demo1_history1,u=root
SELECT 901
INSERT 901
DELETE 0
Action Count Time Pct
bulk_inserting 2 0.2076 51.39
commit 182 0.1521 37.64
select 3 0.0189 4.68
print_bulkfile 901 -0.0021 -0.51
other 0 0.0275 6.80

root@MySQL-01 15:24: [qixin]> select count(*), ucreatetime from table_demo_history group by ucreatetime;
+----------+---------------------+
| count(*) | ucreatetime |
+----------+---------------------+
| 199 | 2020-09-01 11:51:26 |
| 100 | 2020-09-02 11:51:27 |
| 100 | 2020-09-03 11:51:27 |
| 100 | 2020-09-04 11:51:27 |
| 100 | 2020-09-05 11:51:27 |
| 100 | 2020-09-06 11:51:27 |
| 100 | 2020-09-07 11:51:27 |
| 100 | 2020-09-08 11:51:27 |
| 100 | 2020-09-09 11:51:27 |
+----------+---------------------+
9 rows in set (0.00 sec)

root@MySQL-01 15:25: [qixin]> select count(*), ucreatetime from table_demo1_history group by ucreatetime;
+----------+---------------------+
| count(*) | ucreatetime |
+----------+---------------------+
| 10 | 2020-09-01 11:51:26 |
| 10 | 2020-09-02 11:51:27 |
| 10 | 2020-09-03 11:51:27 |
| 10 | 2020-09-04 11:51:27 |
| 10 | 2020-09-05 11:51:27 |
| 10 | 2020-09-06 11:51:27 |
| 10 | 2020-09-07 11:51:27 |
| 10 | 2020-09-08 11:51:27 |
| 10 | 2020-09-09 11:51:27 |
+----------+---------------------+
9 rows in set (0.00 sec)

root@MySQL-01 15:25: [qixin]> select count(*), ucreatetime from table_demo1_history1 group by ucreatetime;
+----------+---------------------+
| count(*) | ucreatetime |
+----------+---------------------+
| 199 | 2020-09-01 11:51:26 |
| 100 | 2020-09-02 11:51:27 |
| 100 | 2020-09-03 11:51:27 |
| 100 | 2020-09-04 11:51:27 |
| 1 | 2020-09-05 11:51:27 |
| 100 | 2020-09-06 11:51:27 |
| 100 | 2020-09-07 11:51:27 |
| 100 | 2020-09-08 11:51:27 |
| 101 | 2020-09-09 11:51:27 |
+----------+---------------------+
9 rows in set (0.00 sec)

分析PT原理

有主键

2020-09-01T04:42:03.705819Z    1056244 Connect    root@localhost on qixin using Socket
2020-09-01T04:42:03.705930Z 1056244 Query set autocommit=0
2020-09-01T04:42:03.706025Z 1056244 Query /*!40101 SET NAMES "utf8"*/
2020-09-01T04:42:03.706128Z 1056244 Query SHOW VARIABLES LIKE 'wait\_timeout'
2020-09-01T04:42:03.782137Z 1056244 Query SET SESSION wait_timeout=10000
2020-09-01T04:42:03.782285Z 1056244 Query SELECT @@SQL_MODE
2020-09-01T04:42:03.786019Z 1056244 Query SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY'*/
2020-09-01T04:42:03.786244Z 1056244 Query SHOW VARIABLES LIKE 'version%'
2020-09-01T04:42:03.787356Z 1056244 Query SHOW ENGINES
2020-09-01T04:42:03.787601Z 1056244 Query SHOW VARIABLES LIKE 'innodb_version'
2020-09-01T04:42:03.788640Z 1056244 Query show variables like 'innodb_rollback_on_timeout'
2020-09-01T04:42:03.789538Z 1056244 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */
2020-09-01T04:42:03.789604Z 1056244 Query USE `qixin`
2020-09-01T04:42:03.789675Z 1056244 Query SHOW CREATE TABLE `qixin`.`table_demo`
2020-09-01T04:42:03.789794Z 1056244 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */
2020-09-01T04:42:03.790234Z 1056245 Connect root@localhost on qixin using Socket
2020-09-01T04:42:03.790302Z 1056245 Query set autocommit=0
2020-09-01T04:42:03.790368Z 1056245 Query /*!40101 SET NAMES "utf8"*/
2020-09-01T04:42:03.790443Z 1056245 Query SHOW VARIABLES LIKE 'wait\_timeout'
2020-09-01T04:42:03.791279Z 1056245 Query SET SESSION wait_timeout=10000
2020-09-01T04:42:03.791363Z 1056245 Query SELECT @@SQL_MODE
2020-09-01T04:42:03.791422Z 1056245 Query SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY'*/
2020-09-01T04:42:03.791510Z 1056245 Query SHOW VARIABLES LIKE 'version%'
2020-09-01T04:42:03.792414Z 1056245 Query SHOW ENGINES
2020-09-01T04:42:03.792651Z 1056245 Query SHOW VARIABLES LIKE 'innodb_version'
2020-09-01T04:42:03.793621Z 1056245 Query show variables like 'innodb_rollback_on_timeout'
2020-09-01T04:42:03.794502Z 1056245 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */
2020-09-01T04:42:03.794564Z 1056245 Query USE `qixin`
2020-09-01T04:42:03.794632Z 1056245 Query SHOW CREATE TABLE `qixin`.`table_demo_history`
2020-09-01T04:42:03.794756Z 1056245 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */
2020-09-01T04:42:03.794975Z 1056244 Query SHOW VARIABLES LIKE 'wsrep_on'
2020-09-01T04:42:03.795812Z 1056244 Query SHOW VARIABLES LIKE 'wsrep_on'
2020-09-01T04:42:03.796814Z 1056244 Query SHOW VARIABLES LIKE 'version%'
2020-09-01T04:42:03.797717Z 1056244 Query SHOW ENGINES
2020-09-01T04:42:03.797960Z 1056244 Query SHOW VARIABLES LIKE 'innodb_version'
2020-09-01T04:42:03.798963Z 1056244 Query SELECT MAX(`id`) FROM `qixin`.`table_demo`
2020-09-01T04:42:03.799375Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') ORDER BY `id` LIMIT 10
2020-09-01T04:42:03.825820Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:03.826092Z 1056245 Query commit
2020-09-01T04:42:03.826128Z 1056244 Query commit
2020-09-01T04:42:03.826226Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/AU0TjwWDdcpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:03.826499Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:03.826596Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '10')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:03.827133Z 1056245 Query commit
2020-09-01T04:42:03.936840Z 1056244 Query commit
2020-09-01T04:42:03.937094Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/ZhhrnEoaX7pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:03.937437Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:03.937603Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '20')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:03.938282Z 1056245 Query commit
2020-09-01T04:42:04.037250Z 1056244 Query commit
2020-09-01T04:42:04.037427Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/fAB4l8yrJjpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.037703Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.037864Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '30')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.038516Z 1056245 Query commit
2020-09-01T04:42:04.104206Z 1056244 Query commit
2020-09-01T04:42:04.104382Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/FmX2lV3SQCpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.104634Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.104799Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '40')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.105450Z 1056245 Query commit
2020-09-01T04:42:04.171160Z 1056244 Query commit
2020-09-01T04:42:04.171345Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/YDsDpHpccApt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.171608Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.171761Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '50')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.172417Z 1056245 Query commit
2020-09-01T04:42:04.237976Z 1056244 Query commit
2020-09-01T04:42:04.238155Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/ObeEMvc2y0pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.238418Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.238569Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '60')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.239225Z 1056245 Query commit
2020-09-01T04:42:04.305109Z 1056244 Query commit
2020-09-01T04:42:04.305287Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/3j9tv4KIZlpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.305551Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.305708Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '70')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.306362Z 1056245 Query commit
2020-09-01T04:42:04.371976Z 1056244 Query commit
2020-09-01T04:42:04.372154Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/BpHvFj6Arvpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.372416Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.372569Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '80')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.373221Z 1056245 Query commit
2020-09-01T04:42:04.439022Z 1056244 Query commit
2020-09-01T04:42:04.439206Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/G7_VjlVW5upt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.439469Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.439625Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '90')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.440275Z 1056245 Query commit
2020-09-01T04:42:04.505950Z 1056244 Query commit
2020-09-01T04:42:04.506130Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/5QgeHRtTO0pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.506394Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.506550Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '100')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.507207Z 1056245 Query commit
2020-09-01T04:42:04.582188Z 1056244 Query commit
2020-09-01T04:42:04.582374Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/pt5T4WvMJ0pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.582630Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.582780Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '110')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.583286Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.583500Z 1056245 Query commit
2020-09-01T04:42:04.681590Z 1056244 Query commit
2020-09-01T04:42:04.681768Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/1ExiMC9SnJpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.682055Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.682216Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '120')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.682858Z 1056245 Query commit
2020-09-01T04:42:04.790047Z 1056244 Query commit
2020-09-01T04:42:04.790229Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/xPv5JsoQgept-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.790499Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.790675Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '130')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.791335Z 1056245 Query commit
2020-09-01T04:42:04.874013Z 1056244 Query commit
2020-09-01T04:42:04.874197Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/kWzhsIt5bCpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.874468Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.874618Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '140')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.875266Z 1056245 Query commit
2020-09-01T04:42:04.941001Z 1056244 Query commit
2020-09-01T04:42:04.941180Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/zHNSfbUpXEpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:04.941438Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:04.941586Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '150')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:04.942237Z 1056245 Query commit
2020-09-01T04:42:05.007953Z 1056244 Query commit
2020-09-01T04:42:05.008131Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/emFtHNbqFUpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.008390Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.008545Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '160')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.009205Z 1056245 Query commit
2020-09-01T04:42:05.074917Z 1056244 Query commit
2020-09-01T04:42:05.075097Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/IUmdwAJs7zpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.075360Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.075518Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '170')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.076169Z 1056245 Query commit
2020-09-01T04:42:05.141777Z 1056244 Query commit
2020-09-01T04:42:05.141960Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/wm8WMjgCckpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.142217Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.142373Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '180')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.143029Z 1056245 Query commit
2020-09-01T04:42:05.217089Z 1056244 Query commit
2020-09-01T04:42:05.217268Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/BJQW1ZsVZPpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.217528Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.217681Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '190')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.218335Z 1056245 Query commit
2020-09-01T04:42:05.293005Z 1056244 Query commit
2020-09-01T04:42:05.293183Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/Ir6XzHYjKspt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.293451Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.293603Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '200')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.294249Z 1056245 Query commit
2020-09-01T04:42:05.367842Z 1056244 Query commit
2020-09-01T04:42:05.368030Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/GE8wk9Qp4Rpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.368303Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.368458Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '210')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.369105Z 1056245 Query commit
2020-09-01T04:42:05.459813Z 1056244 Query commit
2020-09-01T04:42:05.459999Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/7ojkfVuqdApt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.460273Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.460427Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '220')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.460943Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.461139Z 1056245 Query commit
2020-09-01T04:42:05.560014Z 1056244 Query commit
2020-09-01T04:42:05.560199Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/PY2MkLXbPtpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.560461Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.560613Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '230')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.561259Z 1056245 Query commit
2020-09-01T04:42:05.635426Z 1056244 Query commit
2020-09-01T04:42:05.635604Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/I2x_apU4X7pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.635871Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.636036Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '240')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.636685Z 1056245 Query commit
2020-09-01T04:42:05.711280Z 1056244 Query commit
2020-09-01T04:42:05.711462Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/k0vRdVxwrWpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.711724Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.711872Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '250')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.712527Z 1056245 Query commit
2020-09-01T04:42:05.786594Z 1056244 Query commit
2020-09-01T04:42:05.786776Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/LbcnBI4mpMpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.787049Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.787212Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '260')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.787862Z 1056245 Query commit
2020-09-01T04:42:05.861873Z 1056244 Query commit
2020-09-01T04:42:05.862060Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/dysyx3467Cpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.862334Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.862486Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '270')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.863135Z 1056245 Query commit
2020-09-01T04:42:05.928890Z 1056244 Query commit
2020-09-01T04:42:05.929078Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/qJWjuN5nU_pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.929349Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.929501Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '280')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.930151Z 1056245 Query commit
2020-09-01T04:42:05.995860Z 1056244 Query commit
2020-09-01T04:42:05.996047Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/R9lGJ3sRvdpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:05.996322Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:05.996473Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '290')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:05.997126Z 1056245 Query commit
2020-09-01T04:42:06.079362Z 1056244 Query commit
2020-09-01T04:42:06.079541Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/C5L52MNPY7pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.079811Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.079973Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '300')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.080625Z 1056245 Query commit
2020-09-01T04:42:06.146471Z 1056244 Query commit
2020-09-01T04:42:06.146650Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/yi4ujjePb0pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.146913Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.147068Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '310')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.147725Z 1056245 Query commit
2020-09-01T04:42:06.238421Z 1056244 Query commit
2020-09-01T04:42:06.238598Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/_9MB7glHHmpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.238879Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.239044Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '320')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.239688Z 1056245 Query commit
2020-09-01T04:42:06.305315Z 1056244 Query commit
2020-09-01T04:42:06.305493Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/8EcSFIew_Dpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.305754Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.305914Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '330')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.306467Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.306643Z 1056245 Query commit
2020-09-01T04:42:06.372350Z 1056244 Query commit
2020-09-01T04:42:06.372529Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/oUP7_OmRTbpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.372783Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.372939Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '340')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.373593Z 1056245 Query commit
2020-09-01T04:42:06.464323Z 1056244 Query commit
2020-09-01T04:42:06.464502Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/40FBUR4r1Mpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.464756Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.464911Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '350')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.465561Z 1056245 Query commit
2020-09-01T04:42:06.532161Z 1056244 Query commit
2020-09-01T04:42:06.532347Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/yVOJPed0Hppt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.532604Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.532758Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '360')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.533413Z 1056245 Query commit
2020-09-01T04:42:06.640026Z 1056244 Query commit
2020-09-01T04:42:06.640211Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/OZdhG9j7GYpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.640466Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.640621Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '370')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.641276Z 1056245 Query commit
2020-09-01T04:42:06.756956Z 1056244 Query commit
2020-09-01T04:42:06.757133Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/ogUto5EA60pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.757520Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.757681Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '380')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.758313Z 1056245 Query commit
2020-09-01T04:42:06.874000Z 1056244 Query commit
2020-09-01T04:42:06.874181Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/0wwk_r6lcNpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.874440Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.874591Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '390')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.875247Z 1056245 Query commit
2020-09-01T04:42:06.949301Z 1056244 Query commit
2020-09-01T04:42:06.949484Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/Oo9Qhs3cbtpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:06.949743Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:06.949902Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '400')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:06.951145Z 1056245 Query commit
2020-09-01T04:42:07.075070Z 1056244 Query commit
2020-09-01T04:42:07.075251Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/BnooIBcTOYpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.075508Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.075660Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '410')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.076319Z 1056245 Query commit
2020-09-01T04:42:07.142030Z 1056244 Query commit
2020-09-01T04:42:07.142215Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/JmSMOQkEH7pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.142475Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.142631Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '420')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.143284Z 1056245 Query commit
2020-09-01T04:42:07.209002Z 1056244 Query commit
2020-09-01T04:42:07.209181Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/sDwp6tBePopt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.209441Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.209590Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '430')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.210242Z 1056245 Query commit
2020-09-01T04:42:07.300959Z 1056244 Query commit
2020-09-01T04:42:07.301139Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/EQWdJUDUhjpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.301397Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.301552Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '440')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.302124Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.302278Z 1056245 Query commit
2020-09-01T04:42:07.401308Z 1056244 Query commit
2020-09-01T04:42:07.401485Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/CpblUjRy8Jpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.401742Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.401897Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '450')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.402550Z 1056245 Query commit
2020-09-01T04:42:07.476646Z 1056244 Query commit
2020-09-01T04:42:07.476824Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/TsXnGSfKxUpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.477091Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.477248Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '460')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.477893Z 1056245 Query commit
2020-09-01T04:42:07.551923Z 1056244 Query commit
2020-09-01T04:42:07.552105Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/DwMKwp60eWpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.552367Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.552520Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '470')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.553177Z 1056245 Query commit
2020-09-01T04:42:07.627223Z 1056244 Query commit
2020-09-01T04:42:07.627404Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/Zz7ePetzB6pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.627660Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.627817Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '480')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.628466Z 1056245 Query commit
2020-09-01T04:42:07.702528Z 1056244 Query commit
2020-09-01T04:42:07.702705Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/7o_ObySYsFpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.702961Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.703116Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '490')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.703771Z 1056245 Query commit
2020-09-01T04:42:07.777837Z 1056244 Query commit
2020-09-01T04:42:07.778019Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/aj0EDs0sRnpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.778279Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.778436Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '500')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.779085Z 1056245 Query commit
2020-09-01T04:42:07.911330Z 1056244 Query commit
2020-09-01T04:42:07.911514Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/mkylWPgQ90pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.911768Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.911924Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '510')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.912577Z 1056245 Query commit
2020-09-01T04:42:07.986798Z 1056244 Query commit
2020-09-01T04:42:07.986978Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/tXFiirNV1ypt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:07.987237Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:07.987394Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '520')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:07.988051Z 1056245 Query commit
2020-09-01T04:42:08.062722Z 1056244 Query commit
2020-09-01T04:42:08.062900Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/mvt_t5DbPJpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.063160Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.063318Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '530')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.063960Z 1056245 Query commit
2020-09-01T04:42:08.138006Z 1056244 Query commit
2020-09-01T04:42:08.138185Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/wX99KfKYRPpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.138445Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.138594Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '540')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.139245Z 1056245 Query commit
2020-09-01T04:42:08.238157Z 1056244 Query commit
2020-09-01T04:42:08.238338Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/9reiwtZkidpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.238591Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.238748Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '550')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.239340Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.239475Z 1056245 Query commit
2020-09-01T04:42:08.313622Z 1056244 Query commit
2020-09-01T04:42:08.313800Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/kNigCSweHSpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.314060Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.314221Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '560')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.314872Z 1056245 Query commit
2020-09-01T04:42:08.380528Z 1056244 Query commit
2020-09-01T04:42:08.380698Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/gwf4vqkjbnpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.430849Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.431035Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '570')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.431751Z 1056245 Query commit
2020-09-01T04:42:08.497706Z 1056244 Query commit
2020-09-01T04:42:08.497885Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/kHb62JQi_Ypt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.498144Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.498295Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '580')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.498936Z 1056245 Query commit
2020-09-01T04:42:08.597961Z 1056244 Query commit
2020-09-01T04:42:08.598139Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/2bMCu9O93ipt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.598399Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.598563Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '590')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.599216Z 1056245 Query commit
2020-09-01T04:42:08.664987Z 1056244 Query commit
2020-09-01T04:42:08.665167Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/Jsysc1Yocipt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.665422Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.665573Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '600')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.681574Z 1056245 Query commit
2020-09-01T04:42:08.790277Z 1056244 Query commit
2020-09-01T04:42:08.790460Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/lXxwC378x0pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.790716Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.790871Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '610')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.791515Z 1056245 Query commit
2020-09-01T04:42:08.865401Z 1056244 Query commit
2020-09-01T04:42:08.865582Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/KHCg2d10RIpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.865837Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.865991Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '620')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.866627Z 1056245 Query commit
2020-09-01T04:42:08.940956Z 1056244 Query commit
2020-09-01T04:42:08.941135Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/_sZHGTYKGApt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:08.941394Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:08.941548Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '630')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:08.942206Z 1056245 Query commit
2020-09-01T04:42:09.016166Z 1056244 Query commit
2020-09-01T04:42:09.016353Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/vF45ZHOHcOpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.016612Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.016764Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '640')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.017413Z 1056245 Query commit
2020-09-01T04:42:09.091544Z 1056244 Query commit
2020-09-01T04:42:09.091726Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/noIFI_fi4ipt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.091988Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.092142Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '650')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.092790Z 1056245 Query commit
2020-09-01T04:42:09.166857Z 1056244 Query commit
2020-09-01T04:42:09.167044Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/il929ioHsRpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.167306Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.167459Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '660')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.168055Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.168175Z 1056245 Query commit
2020-09-01T04:42:09.250405Z 1056244 Query commit
2020-09-01T04:42:09.250584Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/tz3sh5Szz6pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.250843Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.251025Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '670')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.251703Z 1056245 Query commit
2020-09-01T04:42:09.317393Z 1056244 Query commit
2020-09-01T04:42:09.317571Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/bdQj8e4eEcpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.317825Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.317981Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '680')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.318630Z 1056245 Query commit
2020-09-01T04:42:09.426044Z 1056244 Query commit
2020-09-01T04:42:09.426232Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/Jp4ErJJjlcpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.426489Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.426645Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '690')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.427300Z 1056245 Query commit
2020-09-01T04:42:09.543139Z 1056244 Query commit
2020-09-01T04:42:09.543318Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/9QUMFfvhO5pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.543575Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.543729Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '700')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.544387Z 1056245 Query commit
2020-09-01T04:42:09.610051Z 1056244 Query commit
2020-09-01T04:42:09.610230Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/KyrzcurRQTpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.610487Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.610643Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '710')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.611298Z 1056245 Query commit
2020-09-01T04:42:09.710427Z 1056244 Query commit
2020-09-01T04:42:09.710605Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/opPBKqu5yRpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.710862Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.711036Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '720')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.711687Z 1056245 Query commit
2020-09-01T04:42:09.794033Z 1056244 Query commit
2020-09-01T04:42:09.794216Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/_EceM5rAy6pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.794477Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.794631Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '730')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.795286Z 1056245 Query commit
2020-09-01T04:42:09.869459Z 1056244 Query commit
2020-09-01T04:42:09.869638Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/GQMI9teU30pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.869897Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.870059Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '740')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.870712Z 1056245 Query commit
2020-09-01T04:42:09.945263Z 1056244 Query commit
2020-09-01T04:42:09.945446Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/YTVkZlpSjSpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:09.945702Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:09.945856Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '750')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:09.946508Z 1056245 Query commit
2020-09-01T04:42:10.020048Z 1056244 Query commit
2020-09-01T04:42:10.020231Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/t0EjLYsgkipt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.020488Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.020642Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '760')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.021297Z 1056245 Query commit
2020-09-01T04:42:10.112023Z 1056244 Query commit
2020-09-01T04:42:10.112210Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/2dNKB08SQ4pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.112471Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.112625Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '770')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.113247Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.113347Z 1056245 Query commit
2020-09-01T04:42:10.187396Z 1056244 Query commit
2020-09-01T04:42:10.187576Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/501ZKz1LDgpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.187830Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.187985Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '780')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.188645Z 1056245 Query commit
2020-09-01T04:42:10.263469Z 1056244 Query commit
2020-09-01T04:42:10.263652Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/D7Gsl1DuXwpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.263907Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.264069Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '790')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.264719Z 1056245 Query commit
2020-09-01T04:42:10.337982Z 1056244 Query commit
2020-09-01T04:42:10.338162Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/tsvJXeWH06pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.338420Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.338571Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '800')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.339222Z 1056245 Query commit
2020-09-01T04:42:10.455498Z 1056244 Query commit
2020-09-01T04:42:10.455678Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/jJgEZ7t9Uspt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.455932Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.456092Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '810')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.456745Z 1056245 Query commit
2020-09-01T04:42:10.522481Z 1056244 Query commit
2020-09-01T04:42:10.522659Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/KPgLsuzNl4pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.522916Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.523074Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '820')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.523726Z 1056245 Query commit
2020-09-01T04:42:10.614443Z 1056244 Query commit
2020-09-01T04:42:10.614626Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/4l8eq2DHfRpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.614879Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.615042Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '830')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.615691Z 1056245 Query commit
2020-09-01T04:42:10.723110Z 1056244 Query commit
2020-09-01T04:42:10.723299Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/zlNeNUynrNpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.723551Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.723701Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '840')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.724353Z 1056245 Query commit
2020-09-01T04:42:10.806952Z 1056244 Query commit
2020-09-01T04:42:10.807199Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/wiNAQSa6Ulpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.807456Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.807602Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '850')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.808242Z 1056245 Query commit
2020-09-01T04:42:10.907267Z 1056244 Query commit
2020-09-01T04:42:10.907447Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/msdcnapyUCpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.907705Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.907858Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '860')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.908503Z 1056245 Query commit
2020-09-01T04:42:10.990993Z 1056244 Query commit
2020-09-01T04:42:10.991171Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/QmLXXAAROJpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:10.991428Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:10.991576Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '870')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:10.992225Z 1056245 Query commit
2020-09-01T04:42:11.066298Z 1056244 Query commit
2020-09-01T04:42:11.066479Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/SKEO81cWXupt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.066732Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.066886Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '880')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.067527Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.067607Z 1056245 Query commit
2020-09-01T04:42:11.191397Z 1056244 Query commit
2020-09-01T04:42:11.191576Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/jbfU5MmZJtpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.191830Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.191988Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '890')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.192635Z 1056245 Query commit
2020-09-01T04:42:11.266913Z 1056244 Query commit
2020-09-01T04:42:11.267089Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/4cSSQtrZ3ipt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.267351Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.267501Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '900')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.268149Z 1056245 Query commit
2020-09-01T04:42:11.375568Z 1056244 Query commit
2020-09-01T04:42:11.375747Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/wohqNRU8nNpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.376007Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.376162Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '910')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.377030Z 1056245 Query commit
2020-09-01T04:42:11.484278Z 1056244 Query commit
2020-09-01T04:42:11.484460Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/bfLollGPQjpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.484719Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.484873Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '920')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.485526Z 1056245 Query commit
2020-09-01T04:42:11.551214Z 1056244 Query commit
2020-09-01T04:42:11.551393Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/Pb1red8_xKpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.551651Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.551805Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '930')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.552457Z 1056245 Query commit
2020-09-01T04:42:11.618267Z 1056244 Query commit
2020-09-01T04:42:11.618445Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/lfekW_Jg1_pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.618699Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.618853Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '940')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.619507Z 1056245 Query commit
2020-09-01T04:42:11.685238Z 1056244 Query commit
2020-09-01T04:42:11.685415Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/a4XHFOEmYZpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.727222Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.727397Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '950')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.728108Z 1056245 Query commit
2020-09-01T04:42:11.794098Z 1056244 Query commit
2020-09-01T04:42:11.794276Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/muB8hQnQLlpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.794532Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.794687Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '960')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.795340Z 1056245 Query commit
2020-09-01T04:42:11.860870Z 1056244 Query commit
2020-09-01T04:42:11.861051Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/PrRdopmrOQpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.861315Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.861467Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '970')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.862110Z 1056245 Query commit
2020-09-01T04:42:11.961280Z 1056244 Query commit
2020-09-01T04:42:11.961457Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/tzCNO3aFyipt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:11.961715Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:11.961866Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '980')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:11.962516Z 1056245 Query commit
2020-09-01T04:42:12.061641Z 1056244 Query commit
2020-09-01T04:42:12.061819Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/G3eClHNfQ_pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:12.062084Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:12.062240Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '990')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:12.062914Z 1056245 Query LOAD DATA LOCAL INFILE '/tmp/6cO0RoUE_9pt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:42:12.063086Z 1056244 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:42:12.063178Z 1056244 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '999')) ORDER BY `id` LIMIT 10
2020-09-01T04:42:12.063444Z 1056245 Query commit
2020-09-01T04:42:12.136943Z 1056244 Query commit

无主键

limit 10

2020-09-01T04:45:54.612856Z    1056246 Connect    root@localhost on qixin using Socket
2020-09-01T04:45:54.623925Z 1056246 Query set autocommit=0
2020-09-01T04:45:54.624208Z 1056246 Query /*!40101 SET NAMES "utf8"*/
2020-09-01T04:45:54.624500Z 1056246 Query SHOW VARIABLES LIKE 'wait\_timeout'
2020-09-01T04:45:54.656371Z 1056246 Query SET SESSION wait_timeout=10000
2020-09-01T04:45:54.661161Z 1056246 Query SELECT @@SQL_MODE
2020-09-01T04:45:54.668229Z 1056246 Query SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY'*/
2020-09-01T04:45:54.668560Z 1056246 Query SHOW VARIABLES LIKE 'version%'
2020-09-01T04:45:54.670183Z 1056246 Query SHOW ENGINES
2020-09-01T04:45:54.670572Z 1056246 Query SHOW VARIABLES LIKE 'innodb_version'
2020-09-01T04:45:54.672227Z 1056246 Query show variables like 'innodb_rollback_on_timeout'
2020-09-01T04:45:54.673738Z 1056246 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */
2020-09-01T04:45:54.673934Z 1056246 Query USE `qixin`
2020-09-01T04:45:54.674112Z 1056246 Query SHOW CREATE TABLE `qixin`.`table_demo1`
2020-09-01T04:45:54.678915Z 1056246 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */
2020-09-01T04:45:54.679534Z 1056247 Connect root@localhost on qixin using Socket
2020-09-01T04:45:54.679664Z 1056247 Query set autocommit=0
2020-09-01T04:45:54.679753Z 1056247 Query /*!40101 SET NAMES "utf8"*/
2020-09-01T04:45:54.679839Z 1056247 Query SHOW VARIABLES LIKE 'wait\_timeout'
2020-09-01T04:45:55.218189Z 1056247 Query SET SESSION wait_timeout=10000
2020-09-01T04:45:55.234263Z 1056247 Query SELECT @@SQL_MODE
2020-09-01T04:45:55.234411Z 1056247 Query SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY'*/
2020-09-01T04:45:55.234560Z 1056247 Query SHOW VARIABLES LIKE 'version%'
2020-09-01T04:45:55.235579Z 1056247 Query SHOW ENGINES
2020-09-01T04:45:55.235830Z 1056247 Query SHOW VARIABLES LIKE 'innodb_version'
2020-09-01T04:45:55.236820Z 1056247 Query show variables like 'innodb_rollback_on_timeout'
2020-09-01T04:45:55.237728Z 1056247 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */
2020-09-01T04:45:55.237792Z 1056247 Query USE `qixin`
2020-09-01T04:45:55.237863Z 1056247 Query SHOW CREATE TABLE `qixin`.`table_demo1_history`
2020-09-01T04:45:55.241535Z 1056247 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */
2020-09-01T04:45:55.241737Z 1056246 Query SHOW VARIABLES LIKE 'wsrep_on'
2020-09-01T04:45:55.243097Z 1056246 Query SHOW VARIABLES LIKE 'wsrep_on'
2020-09-01T04:45:55.244589Z 1056246 Query SHOW VARIABLES LIKE 'version%'
2020-09-01T04:45:55.245981Z 1056246 Query SHOW ENGINES
2020-09-01T04:45:55.246232Z 1056246 Query SHOW VARIABLES LIKE 'innodb_version'
2020-09-01T04:45:55.247947Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.268841Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.269115Z 1056247 Query commit
2020-09-01T04:45:55.269152Z 1056246 Query commit
2020-09-01T04:45:55.276755Z 1056247 Query LOAD DATA LOCAL INFILE '/tmp/0mSKYe9H_1pt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:45:55.391896Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.392042Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-01 11:51:26' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-01 11:51:26')))) ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.392634Z 1056247 Query commit
2020-09-01T04:45:55.467403Z 1056246 Query commit
2020-09-01T04:45:55.467582Z 1056247 Query LOAD DATA LOCAL INFILE '/tmp/3d4ZQAAhXmpt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:45:55.467841Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.468008Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-02 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-02 11:51:27')))) ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.468659Z 1056247 Query commit
2020-09-01T04:45:55.534448Z 1056246 Query commit
2020-09-01T04:45:55.534626Z 1056247 Query LOAD DATA LOCAL INFILE '/tmp/OM6TBYirhppt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:45:55.534880Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.535045Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-03 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-03 11:51:27')))) ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.535692Z 1056247 Query commit
2020-09-01T04:45:55.601410Z 1056246 Query commit
2020-09-01T04:45:55.601589Z 1056247 Query LOAD DATA LOCAL INFILE '/tmp/ugFgLdzN5Vpt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:45:55.601842Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.602005Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-04 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-04 11:51:27')))) ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.602658Z 1056247 Query commit
2020-09-01T04:45:55.668336Z 1056246 Query commit
2020-09-01T04:45:55.668513Z 1056247 Query LOAD DATA LOCAL INFILE '/tmp/eS64zSsg81pt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:45:55.668784Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.668945Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-05 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-05 11:51:27')))) ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.669588Z 1056247 Query commit
2020-09-01T04:45:55.735344Z 1056246 Query commit
2020-09-01T04:45:55.735525Z 1056247 Query LOAD DATA LOCAL INFILE '/tmp/pm9PxNBm_Mpt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:45:55.735781Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.735946Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-06 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-06 11:51:27')))) ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.736597Z 1056247 Query commit
2020-09-01T04:45:55.802210Z 1056246 Query commit
2020-09-01T04:45:55.802392Z 1056247 Query LOAD DATA LOCAL INFILE '/tmp/ZgF1CTnJbEpt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:45:55.802647Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.802805Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-07 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-07 11:51:27')))) ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.803459Z 1056247 Query commit
2020-09-01T04:45:55.869209Z 1056246 Query commit
2020-09-01T04:45:55.869388Z 1056247 Query LOAD DATA LOCAL INFILE '/tmp/KdLG2B7LqRpt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:45:55.869636Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.869790Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-08 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-08 11:51:27')))) ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.870438Z 1056247 Query commit
2020-09-01T04:45:55.936160Z 1056246 Query commit
2020-09-01T04:45:55.936345Z 1056247 Query LOAD DATA LOCAL INFILE '/tmp/DIf1nNHCG2pt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T04:45:55.936601Z 1056246 Query SELECT 'pt-archiver keepalive'
2020-09-01T04:45:55.936763Z 1056246 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-09 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-09 11:51:27')))) ORDER BY `ucreatetime` LIMIT 10
2020-09-01T04:45:55.937182Z 1056247 Query commit
2020-09-01T04:45:56.011530Z 1056246 Query commit

limit 500

2020-09-01T07:24:52.407145Z    1056259 Query    USE `qixin`
2020-09-01T07:24:52.407216Z 1056259 Query SHOW CREATE TABLE `qixin`.`table_demo1`
2020-09-01T07:24:52.407338Z 1056259 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */
2020-09-01T07:24:52.407779Z 1056260 Connect root@localhost on qixin using Socket
2020-09-01T07:24:52.407847Z 1056260 Query set autocommit=0
2020-09-01T07:24:52.407912Z 1056260 Query /*!40101 SET NAMES "utf8"*/
2020-09-01T07:24:52.407989Z 1056260 Query SHOW VARIABLES LIKE 'wait\_timeout'
2020-09-01T07:24:52.408816Z 1056260 Query SET SESSION wait_timeout=10000
2020-09-01T07:24:52.417696Z 1056260 Query SELECT @@SQL_MODE
2020-09-01T07:24:52.424302Z 1056260 Query SET @@SQL_QUOTE_SHOW_CREATE = 1/*!40101, @@SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BY'*/
2020-09-01T07:24:52.424482Z 1056260 Query SHOW VARIABLES LIKE 'version%'
2020-09-01T07:24:52.425539Z 1056260 Query SHOW ENGINES
2020-09-01T07:24:52.425778Z 1056260 Query SHOW VARIABLES LIKE 'innodb_version'
2020-09-01T07:24:52.426745Z 1056260 Query show variables like 'innodb_rollback_on_timeout'
2020-09-01T07:24:52.427632Z 1056260 Query /*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := '', @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */
2020-09-01T07:24:52.427694Z 1056260 Query USE `qixin`
2020-09-01T07:24:52.427761Z 1056260 Query SHOW CREATE TABLE `qixin`.`table_demo1_history1`
2020-09-01T07:24:52.427882Z 1056260 Query /*!40101 SET @@SQL_MODE := @OLD_SQL_MODE, @@SQL_QUOTE_SHOW_CREATE := @OLD_QUOTE */
2020-09-01T07:24:52.428089Z 1056259 Query SHOW VARIABLES LIKE 'wsrep_on'
2020-09-01T07:24:52.429419Z 1056259 Query SHOW VARIABLES LIKE 'wsrep_on'
2020-09-01T07:24:52.430896Z 1056259 Query SHOW VARIABLES LIKE 'version%'
2020-09-01T07:24:52.432260Z 1056259 Query SHOW ENGINES
2020-09-01T07:24:52.432508Z 1056259 Query SHOW VARIABLES LIKE 'innodb_version'
2020-09-01T07:24:52.434235Z 1056259 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') ORDER BY `ucreatetime` LIMIT 500
2020-09-01T07:24:52.457603Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.457874Z 1056260 Query commit
2020-09-01T07:24:52.457909Z 1056259 Query commit
2020-09-01T07:24:52.458142Z 1056260 Query commit
2020-09-01T07:24:52.458169Z 1056259 Query commit
2020-09-01T07:24:52.458394Z 1056260 Query commit
2020-09-01T07:24:52.458420Z 1056259 Query commit
2020-09-01T07:24:52.458640Z 1056260 Query commit
2020-09-01T07:24:52.458665Z 1056259 Query commit
2020-09-01T07:24:52.458881Z 1056260 Query commit
2020-09-01T07:24:52.458906Z 1056259 Query commit
2020-09-01T07:24:52.459122Z 1056260 Query commit
2020-09-01T07:24:52.459148Z 1056259 Query commit
2020-09-01T07:24:52.459372Z 1056260 Query commit
2020-09-01T07:24:52.459400Z 1056259 Query commit
2020-09-01T07:24:52.459617Z 1056260 Query commit
2020-09-01T07:24:52.459642Z 1056259 Query commit
2020-09-01T07:24:52.459856Z 1056260 Query commit
2020-09-01T07:24:52.459881Z 1056259 Query commit
2020-09-01T07:24:52.460096Z 1056260 Query commit
2020-09-01T07:24:52.460122Z 1056259 Query commit
2020-09-01T07:24:52.460182Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.460392Z 1056260 Query commit
2020-09-01T07:24:52.460420Z 1056259 Query commit
2020-09-01T07:24:52.460637Z 1056260 Query commit
2020-09-01T07:24:52.460664Z 1056259 Query commit
2020-09-01T07:24:52.460890Z 1056260 Query commit
2020-09-01T07:24:52.460917Z 1056259 Query commit
2020-09-01T07:24:52.461134Z 1056260 Query commit
2020-09-01T07:24:52.461160Z 1056259 Query commit
2020-09-01T07:24:52.461379Z 1056260 Query commit
2020-09-01T07:24:52.461404Z 1056259 Query commit
2020-09-01T07:24:52.461617Z 1056260 Query commit
2020-09-01T07:24:52.461642Z 1056259 Query commit
2020-09-01T07:24:52.461856Z 1056260 Query commit
2020-09-01T07:24:52.461881Z 1056259 Query commit
2020-09-01T07:24:52.462094Z 1056260 Query commit
2020-09-01T07:24:52.462120Z 1056259 Query commit
2020-09-01T07:24:52.462339Z 1056260 Query commit
2020-09-01T07:24:52.462365Z 1056259 Query commit
2020-09-01T07:24:52.462580Z 1056260 Query commit
2020-09-01T07:24:52.462606Z 1056259 Query commit
2020-09-01T07:24:52.462664Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.462866Z 1056260 Query commit
2020-09-01T07:24:52.462893Z 1056259 Query commit
2020-09-01T07:24:52.463108Z 1056260 Query commit
2020-09-01T07:24:52.463134Z 1056259 Query commit
2020-09-01T07:24:52.463351Z 1056260 Query commit
2020-09-01T07:24:52.463377Z 1056259 Query commit
2020-09-01T07:24:52.463600Z 1056260 Query commit
2020-09-01T07:24:52.463624Z 1056259 Query commit
2020-09-01T07:24:52.463834Z 1056260 Query commit
2020-09-01T07:24:52.463858Z 1056259 Query commit
2020-09-01T07:24:52.464068Z 1056260 Query commit
2020-09-01T07:24:52.464091Z 1056259 Query commit
2020-09-01T07:24:52.464309Z 1056260 Query commit
2020-09-01T07:24:52.464336Z 1056259 Query commit
2020-09-01T07:24:52.464552Z 1056260 Query commit
2020-09-01T07:24:52.464577Z 1056259 Query commit
2020-09-01T07:24:52.464791Z 1056260 Query commit
2020-09-01T07:24:52.464816Z 1056259 Query commit
2020-09-01T07:24:52.465032Z 1056260 Query commit
2020-09-01T07:24:52.465058Z 1056259 Query commit
2020-09-01T07:24:52.465116Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.465324Z 1056260 Query commit
2020-09-01T07:24:52.465352Z 1056259 Query commit
2020-09-01T07:24:52.465569Z 1056260 Query commit
2020-09-01T07:24:52.465596Z 1056259 Query commit
2020-09-01T07:24:52.465814Z 1056260 Query commit
2020-09-01T07:24:52.465841Z 1056259 Query commit
2020-09-01T07:24:52.466059Z 1056260 Query commit
2020-09-01T07:24:52.466086Z 1056259 Query commit
2020-09-01T07:24:52.466308Z 1056260 Query commit
2020-09-01T07:24:52.466333Z 1056259 Query commit
2020-09-01T07:24:52.466559Z 1056260 Query commit
2020-09-01T07:24:52.466585Z 1056259 Query commit
2020-09-01T07:24:52.466800Z 1056260 Query commit
2020-09-01T07:24:52.466825Z 1056259 Query commit
2020-09-01T07:24:52.467048Z 1056260 Query commit
2020-09-01T07:24:52.467076Z 1056259 Query commit
2020-09-01T07:24:52.467296Z 1056260 Query commit
2020-09-01T07:24:52.467323Z 1056259 Query commit
2020-09-01T07:24:52.467540Z 1056260 Query commit
2020-09-01T07:24:52.467567Z 1056259 Query commit
2020-09-01T07:24:52.467628Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.467833Z 1056260 Query commit
2020-09-01T07:24:52.467861Z 1056259 Query commit
2020-09-01T07:24:52.468079Z 1056260 Query commit
2020-09-01T07:24:52.468107Z 1056259 Query commit
2020-09-01T07:24:52.468327Z 1056260 Query commit
2020-09-01T07:24:52.468354Z 1056259 Query commit
2020-09-01T07:24:52.468571Z 1056260 Query commit
2020-09-01T07:24:52.468598Z 1056259 Query commit
2020-09-01T07:24:52.468815Z 1056260 Query commit
2020-09-01T07:24:52.468842Z 1056259 Query commit
2020-09-01T07:24:52.469061Z 1056260 Query commit
2020-09-01T07:24:52.469089Z 1056259 Query commit
2020-09-01T07:24:52.469311Z 1056260 Query commit
2020-09-01T07:24:52.469338Z 1056259 Query commit
2020-09-01T07:24:52.469563Z 1056260 Query commit
2020-09-01T07:24:52.469590Z 1056259 Query commit
2020-09-01T07:24:52.469808Z 1056260 Query commit
2020-09-01T07:24:52.469835Z 1056259 Query commit
2020-09-01T07:24:52.470053Z 1056260 Query commit
2020-09-01T07:24:52.470081Z 1056259 Query commit
2020-09-01T07:24:52.470169Z 1056260 Query LOAD DATA LOCAL INFILE '/tmp/ilApsDuNwxpt-archiver' INTO TABLE `qixin`.`table_demo1_history1`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T07:24:52.637221Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.637405Z 1056259 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-05 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-05 11:51:27')))) ORDER BY `ucreatetime` LIMIT 500
2020-09-01T07:24:52.638412Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.638626Z 1056260 Query commit
2020-09-01T07:24:52.712539Z 1056259 Query commit
2020-09-01T07:24:52.712892Z 1056260 Query commit
2020-09-01T07:24:52.712952Z 1056259 Query commit
2020-09-01T07:24:52.713237Z 1056260 Query commit
2020-09-01T07:24:52.713286Z 1056259 Query commit
2020-09-01T07:24:52.713543Z 1056260 Query commit
2020-09-01T07:24:52.713577Z 1056259 Query commit
2020-09-01T07:24:52.713795Z 1056260 Query commit
2020-09-01T07:24:52.713823Z 1056259 Query commit
2020-09-01T07:24:52.714046Z 1056260 Query commit
2020-09-01T07:24:52.714074Z 1056259 Query commit
2020-09-01T07:24:52.714292Z 1056260 Query commit
2020-09-01T07:24:52.714319Z 1056259 Query commit
2020-09-01T07:24:52.714536Z 1056260 Query commit
2020-09-01T07:24:52.714563Z 1056259 Query commit
2020-09-01T07:24:52.714780Z 1056260 Query commit
2020-09-01T07:24:52.714807Z 1056259 Query commit
2020-09-01T07:24:52.715027Z 1056260 Query commit
2020-09-01T07:24:52.715055Z 1056259 Query commit
2020-09-01T07:24:52.715142Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.715343Z 1056260 Query commit
2020-09-01T07:24:52.715371Z 1056259 Query commit
2020-09-01T07:24:52.715602Z 1056260 Query commit
2020-09-01T07:24:52.715628Z 1056259 Query commit
2020-09-01T07:24:52.715842Z 1056260 Query commit
2020-09-01T07:24:52.715867Z 1056259 Query commit
2020-09-01T07:24:52.716085Z 1056260 Query commit
2020-09-01T07:24:52.716111Z 1056259 Query commit
2020-09-01T07:24:52.716360Z 1056260 Query commit
2020-09-01T07:24:52.716386Z 1056259 Query commit
2020-09-01T07:24:52.716608Z 1056260 Query commit
2020-09-01T07:24:52.716634Z 1056259 Query commit
2020-09-01T07:24:52.716849Z 1056260 Query commit
2020-09-01T07:24:52.716875Z 1056259 Query commit
2020-09-01T07:24:52.717092Z 1056260 Query commit
2020-09-01T07:24:52.717118Z 1056259 Query commit
2020-09-01T07:24:52.717345Z 1056260 Query commit
2020-09-01T07:24:52.717373Z 1056259 Query commit
2020-09-01T07:24:52.717591Z 1056260 Query commit
2020-09-01T07:24:52.717618Z 1056259 Query commit
2020-09-01T07:24:52.717699Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.717887Z 1056260 Query commit
2020-09-01T07:24:52.717915Z 1056259 Query commit
2020-09-01T07:24:52.718137Z 1056260 Query commit
2020-09-01T07:24:52.718165Z 1056259 Query commit
2020-09-01T07:24:52.718382Z 1056260 Query commit
2020-09-01T07:24:52.718409Z 1056259 Query commit
2020-09-01T07:24:52.718634Z 1056260 Query commit
2020-09-01T07:24:52.718662Z 1056259 Query commit
2020-09-01T07:24:52.718878Z 1056260 Query commit
2020-09-01T07:24:52.718905Z 1056259 Query commit
2020-09-01T07:24:52.719127Z 1056260 Query commit
2020-09-01T07:24:52.719155Z 1056259 Query commit
2020-09-01T07:24:52.719372Z 1056260 Query commit
2020-09-01T07:24:52.719399Z 1056259 Query commit
2020-09-01T07:24:52.719614Z 1056260 Query commit
2020-09-01T07:24:52.719641Z 1056259 Query commit
2020-09-01T07:24:52.719862Z 1056260 Query commit
2020-09-01T07:24:52.719890Z 1056259 Query commit
2020-09-01T07:24:52.720111Z 1056260 Query commit
2020-09-01T07:24:52.720139Z 1056259 Query commit
2020-09-01T07:24:52.720219Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.720406Z 1056260 Query commit
2020-09-01T07:24:52.720433Z 1056259 Query commit
2020-09-01T07:24:52.720652Z 1056260 Query commit
2020-09-01T07:24:52.720679Z 1056259 Query commit
2020-09-01T07:24:52.720896Z 1056260 Query commit
2020-09-01T07:24:52.720923Z 1056259 Query commit
2020-09-01T07:24:52.721144Z 1056260 Query commit
2020-09-01T07:24:52.721172Z 1056259 Query commit
2020-09-01T07:24:52.721391Z 1056260 Query commit
2020-09-01T07:24:52.721418Z 1056259 Query commit
2020-09-01T07:24:52.721643Z 1056260 Query commit
2020-09-01T07:24:52.721671Z 1056259 Query commit
2020-09-01T07:24:52.721888Z 1056260 Query commit
2020-09-01T07:24:52.721915Z 1056259 Query commit
2020-09-01T07:24:52.722135Z 1056260 Query commit
2020-09-01T07:24:52.722163Z 1056259 Query commit
2020-09-01T07:24:52.722382Z 1056260 Query commit
2020-09-01T07:24:52.722409Z 1056259 Query commit
2020-09-01T07:24:52.722627Z 1056260 Query commit
2020-09-01T07:24:52.722654Z 1056259 Query commit
2020-09-01T07:24:52.722758Z 1056260 Query LOAD DATA LOCAL INFILE '/tmp/pEtJXKqDTxpt-archiver' INTO TABLE `qixin`.`table_demo1_history1`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)
2020-09-01T07:24:52.763110Z 1056259 Query SELECT 'pt-archiver keepalive'
2020-09-01T07:24:52.763289Z 1056259 Query SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`) WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (((('2020-09-09 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR (`ucreatetime` > '2020-09-09 11:51:27')))) ORDER BY `ucreatetime` LIMIT 500
2020-09-01T07:24:52.763708Z 1056260 Query commit
2020-09-01T07:24:52.838064Z 1056259 Query commit
2020-09-01T07:24:52.838341Z 1056259 Quit
2020-09-01T07:24:52.838978Z 1056260 Quit
2020-09-01T07:24:57.837254Z 1056256 Query SET GLOBAL general_log = 'OFF'

总结

为什么表无主键时获取不到正确的行数呢?

--limit=10 代表一次取出10行数据:

有主键的表

第一步:PT工具第一步获取 source 表的主键id的最大值,命令如下:

SELECT MAX(`id`) FROM `qixin`.`table_demo`
```

第二步:按照PT命令中指定的`where过滤条件` AND `对主键ID的过滤`,按照ID排序,取前10行,保存到临时文件中,命令如下:

```sql
SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age`
FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`)
WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000')
ORDER BY `id` LIMIT 10

第三步:通过LOAD DATA LOCAL INFILE 快速加载文件到归档表table_demo_history。

LOAD DATA LOCAL INFILE '/tmp/AU0TjwWDdcpt-archiver' INTO TABLE `qixin`.`table_demo_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)

接下来就是循环第二步和第三步,直到取完所有的数据, 并加载到归档表table_demo_history。

SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` 
FROM `qixin`.`table_demo` FORCE INDEX(`PRIMARY`)
WHERE (ucreatetime >= '2020-09-01 11:51:26') AND (`id` < '1000') AND ((`id` > '10'))
ORDER BY `id` LIMIT 10

无主键的表

第一步:由于没有主键,因此没有办法获取主键ID的最大值,跳过该步骤。

第二步:按照PT命令中指定的where过滤条件 AND 对主键ID的过滤,按照ID排序,取前10行,保存到临时文件中,命令如下:

SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` 
FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`)
WHERE (ucreatetime >= '2020-09-01 11:51:26')
ORDER BY `ucreatetime` LIMIT 10

第三步:通过LOAD DATA LOCAL INFILE 快速加载文件到归档表table_demo_history。

LOAD DATA LOCAL INFILE '/tmp/0mSKYe9H_1pt-archiver' INTO TABLE `qixin`.`table_demo1_history`CHARACTER SET utf8(`id`,`uname`,`ucreatetime`,`age`)

接下来就是循环第二步和第三步,直到取完所有的数据, 并加载到归档表table_demo_history。

SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` 
FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`)
WHERE (ucreatetime >= '2020-09-01 11:51:26') AND
(
((
('2020-09-01 11:51:26' IS NULL AND `ucreatetime` IS NOT NULL) OR
(`ucreatetime` > '2020-09-01 11:51:26')
))
)
ORDER BY `ucreatetime` LIMIT 10

无主键时的过滤

第 1 次查询条件取了 ucreatetime >= '2020-09-01 11:51:26' 的 10行数据,且排序规则使用的是ucreatetime
第 2 次查询条件取了 ucreatetime > '2020-09-01 11:51:26' 的 10行数据,且排序规则使用的是ucreatetime
第 3 次查询条件取了 ucreatetime > '2020-09-02 11:51:26' 的 10行数据,且排序规则使用的是ucreatetime
第 4 次查询条件取了 ucreatetime > '2020-09-04 11:51:26' 的 10行数据,且排序规则使用的是ucreatetime
第 n 次查询条件取了 ucreatetime > '2020-09-xx 11:51:26' 的 10行数据,且排序规则使用的是ucreatetime

个人理解:索引idx_ucreatetime 为辅助索引,内部为B+树,叶子节点存放着ucreatetime的所有数据

无主键的过滤条件中PT会使用叶子节点的值进行过滤(具体值为上一次查询的最后一个值),并取limit 10;

从而导致了 --limit 10 只能归档90条数据。

root@MySQL-01 14:59:  [qixin]> select distinct ucreatetime from table_demo1;
+---------------------+
| ucreatetime |
+---------------------+
| 2020-09-01 11:51:26 |
| 2020-09-02 11:51:27 |
| 2020-09-03 11:51:27 |
| 2020-09-04 11:51:27 |
| 2020-09-05 11:51:27 |
| 2020-09-06 11:51:27 |
| 2020-09-07 11:51:27 |
| 2020-09-08 11:51:27 |
| 2020-09-09 11:51:27 |
+---------------------+
9 rows in set (0.02 sec)

当调整limit参数为 500时,PT的查询如下:

SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age` 
FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`)
WHERE (ucreatetime >= '2020-09-01 11:51:26') ORDER BY `ucreatetime` LIMIT 500;

# 执行结果
| 497 | 用户7 | 2020-09-04 11:51:27 | 20 |
| 498 | 用户8 | 2020-09-04 11:51:27 | 20 |
| 499 | 用户9 | 2020-09-04 11:51:27 | 20 |
| 500 | 用户0 | 2020-09-05 11:51:27 | 20 |
+------+---------+---------------------+------+
500 rows in set (0.03 sec)


SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age`
FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`)
WHERE (ucreatetime >= '2020-09-01 11:51:26') AND
(
((
('2020-09-05 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR
(`ucreatetime` > '2020-09-05 11:51:27')
))
)
ORDER BY `ucreatetime` LIMIT 500;

# 执行结果
| 998 | 用户8 | 2020-09-09 11:51:27 | 20 |
| 999 | 用户9 | 2020-09-09 11:51:27 | 20 |
| 1000 | 用户0 | 2020-09-09 11:51:27 | 20 |
+------+---------+---------------------+------+
401 rows in set (0.00 sec)


SELECT /*!40001 SQL_NO_CACHE */ `id`,`uname`,`ucreatetime`,`age`
FROM `qixin`.`table_demo1` FORCE INDEX(`idx_ucreatetime`)
WHERE (ucreatetime >= '2020-09-01 11:51:26') AND
(
((
('2020-09-09 11:51:27' IS NULL AND `ucreatetime` IS NOT NULL) OR
(`ucreatetime` > '2020-09-09 11:51:27')
))
)
ORDER BY `ucreatetime` LIMIT 500

由此可以得出,PT在无主键的归档时,是无法保证数据正确的。建议生产中的表应规范主键。

思考

是否可以调整PT源码,使其支持无主键的表呢?

没有必要,让工具去支持不规范的操作是没有意义的。

pt-archiver操作的表必须有主键