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

How can i stop pt-archiver after first statement ?

bogdanbrbogdanbr EntrantCurrent User Role Beginner
Hello,



Is there any way to stop pt-archiver after first statement (transaction) ?

I am trying to archive 100.000 lines, but i want to archive 10.000 per day using a cron.

My WHERE has a 10.000 limit, but pt-archiver archives all 100.000 lines in continues 10 transactions.

Is there any way to limit to 1 transaction (statement, batch) of 10.000 lines and stop until i run again the pt-archiver command ?



Thank you in advance!
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.