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

pt-table-checksum: Continuing and Resuming

utdrmacutdrmac EntrantInactive User Role Beginner
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?

Comments

  • KoHeadKoHead Contributor Inactive User Role Beginner
    i don't know script for that. And with the --retry option ?
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.