pt-table-checksum: Recheck fixed chunk

  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum: Recheck fixed chunk

    So I ran pt-table-checksum on one of our massive tables last night. (4,000 chunks of approx 94,000 rows each).

    When I ran the report this morning, there was 1 chunk whose checksum didn't match that on master.

    So I ran pt-table-sync with the --replicate option and it synced the values from 5 rows within that bad chunk. Excellent!

    Now, how do I tell pt-t-c to go back and re-checksum just that one chunk and update the replicate table in all slaves?

    Seems to me this should be a series of flags where I specify the table and chunk # and pt-t-c goes and re-checksums it.

  • #2
    There is no option to do that, the only think that you can use "as a workaround" is to use the "--where" option and put the range or rows of the chunks there (you can check the range of the chunks in your report).