pt-table-checksum: Continuing and Resuming

  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-table-checksum: Continuing and Resuming

    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?

  • #2
    i don't know script for that. And with the --retry option ?