pt-table-checksum

# pt-table-checksum --nocheck-replication-filters --databases=ua --replicate=ua.checksums --create-replicate-table --host=172.16.11.170 --port 3306 -uroot
            TS ERRORS DIFFS     ROWS CHUNKS SKIPPED    TIME TABLE
04-12T09:52:56      0      0        0       1       0   1.105 ua.bak
04-12T09:52:57      0      0        0       1       0   0.365 ua.heartbeat
04-12T09:52:57      0      1       26       1       0   0.426 ua.te
# pt-table-checksum --nocheck-replication-filters --databases=ua --replicate=ua.checksums --create-replicate-table --host=172.16.11.164 --port 3306 -uroot
            TS ERRORS DIFFS     ROWS CHUNKS SKIPPED    TIME TABLE
04-12T09:54:48      0      0        0       1       0   0.056 ua.bak
04-12T09:54:48      0      0        0       1       0   0.036 ua.heartbeat
04-12T09:54:48      0      0       10       1       0   0.009 ua.te

posted on 2013-04-12 10:29 语辰阅读(186) 评论(0) 编辑收藏举报