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!