I am using Pt-table-checksum to verify replication integrity. I have intentionally changed a column in a row in one of my replicas. Here is what I did-
pt-table-checksum “h=192.168.1.86,u=replication,p=replication,P=3320” --function=MD5 --databases=test
and the output I get is
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE09-04T18:21:46 0 0 3 1 0 0.112 test.xyz
My question is, should not the DIFFS column in the output say 1 instead of 0? What am I missing here?
Can Pt-table-checksum also tell the diffs in the replicas by pin pointing to that row?