Am experimenting with pt-table-checksum for checking integrity on prod servers am getting ambiguous results,
this is from one of the tables checksum result on stdout
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
05-30T17:08:11 0 1 0 1 0 0.013 xxx.xxx_test
the result in the percona.checksums table says there is no diff for table on master as well on the slave, but there is difference in the number of rows of data in the table.
±----±---------±------±-----------±------------±---------------±---------------±---------±---------±-----------±-----------±--------------------+
| db | tbl | chunk | chunk_time | chunk_index | lower_boundary | upper_boundary | this_crc | this_cnt | master_crc | master_cnt | ts |
±----±---------±------±-----------±------------±---------------±---------------±---------±---------±-----------±-----------±--------------------+
| xxx | xxx_test | 1 | 0.001505 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 2014-05-30 17:08:11 |
±----±---------±------±-----------±------------±---------------±---------------±---------±---------±-----------±-----------±--------------------+
I tried different combinations and all the time the result showed as if there is no difference in the number of rows
master_cnt this_cnt actual master_cnt actual this_cnt
0 0 0 2
2 2 2 3
3 3 3 2
something like that how ever i try the result in the table for both master_cnt and this_cnt remained the same value as that of master_cnt, how ever the row count in the slave is. But in the STDOUT result set the Diff to ‘1’ indicating the data is different in that table.
Need help urgently, some one help.
Thanks
DL