Not the answer you need?
Register and ask your own question!

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

SQLGuySQLGuy ContributorCurrent User Role Beginner
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?

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    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
    
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.