在主库执行命令:
pt-table-checksum -h 192.168.100.101 -P 3306 -u admin -p admin
--nocheck-binlog-format --replicate=pt.checksum --recursion-method="processlist"
--databases=db01,sysbench --tables=t01,t02 --where='pkid>0'
Checking if all tables can be checksummed ...
Starting checksum ...
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
11-23T19:26:01 0 0 1 1 0 0.421 db01.heartbeat
11-23T19:26:02 0 0 2 1 0 0.406 db01.pt_deadlocks
11-23T19:26:02 0 1 1 1 0 0.276 db01.t01
11-23T19:26:02 0 0 8 1 0 0.018 db01.t02