27. pt-table-checksum


在主库执行命令:


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

wechat: nick753159 qq: 417966852 email: nzq42@qq.com base: shanghai
原文地址:https://www.cnblogs.com/cyberbit/p/pt-table-checksum.html