Buy Percona ServicesBuy Now!

How can i stop pt-archiver after first statement ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How can i stop pt-archiver after first statement ?

    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!
Working...
X