pt-table-checksum: Continuing and Resuming

09-24-2012, 10:17 AM

We have several tables that have an auto-inc PK with data that never changes once inserted. We would only need to run pt-t-c once for the entire table and then subsequent runs would only need to check those rows that have been added since last run.

The '--resume' flag is only for those cases where pt-t-c aborted in the middle (due to mysql error or user-cancel).

How can I tell pt-t-c to "resume" or "continue" checking a table with new data? Would I have to script something to pull out the last boundary and run pt-t-c with --where and that chunk boundary?