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

**URL:** https://forums.percona.com/t/how-can-i-stop-pt-archiver-after-first-statement/7297
**Category:** Percona Toolkit
**Created:** [November 14, 2019, 1:44am UTC](https://forums.percona.com/t/how-can-i-stop-pt-archiver-after-first-statement/7297 "2019-11-14T01:44:23Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![bogdanbr](https://avatars.discourse-cdn.com/v4/letter/b/7cd45c/32.png) [@bogdanbr](https://forums.percona.com/u/bogdanbr)
#### Post date: [November 14, 2019, 1:44am UTC](https://forums.percona.com/t/how-can-i-stop-pt-archiver-after-first-statement/7297/1 "2019-11-14T01:44:23Z")

</div>

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!