pt-table-checksum doesn't list which slave the diffs were found on

We often have 2 or more slaves that are checked by pt-table-checksum, but the report that is generated doesn’t tell us which slave the “diff” is found on. For example:

In the output above the first to diffs were found on the first slave, and the last one was found on the second slave. This would be a real problem if someone had dozens of slaves. Seems like there should be an additional column that listed the slave that the diff was found on?

Hi,

Try to run pt-table-checksum with --replicate-check-only option. Check this link. http://www.percona.com/doc/percona-t…-checksum.html

If –replicate-check-only is specified, only checksum differences on detected replicas are printed. The output is different: one paragraph per replica, one checksum difference per line, and values are separated by spaces:

Differences on [COLOR=#BB60D5]h=127.0.0.1,P=12346
TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
db1.tbl1 1 0 1 PRIMARY 1 100 db1.tbl1 6 0 1 PRIMARY 501 600

Differences on [COLOR=#BB60D5]h=127.0.0.1,P=12347
TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
db1.tbl1 1 0 1 PRIMARY 1 100 db2.tbl2 9 5 0 PRIMARY 101 200