pt-archiver hangs on last rows

Bug #1193474 reported by Moody Youssef on 2013-06-21
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit

Bug Description

Percona-Toolkit 2.2.2
Percona-Server 5.5.31

When running pt-archiver, I am filtering by created_date on a large table. Anything older than 4 days I am archiving. This is the command I am running within a bash script.

ptarchiver -u $MyUSER -p$MyPASS --source h=$MyHOST,D=$DEST_DB,t=$DEST_TABLE --file $DEST_FILE --why-quit --progress 50000 --charset utf8 --retries 3 --commit-each --limit 2000 --where "CREATED_DATE <= DATE_SUB(NOW(), INTERVAL 4 DAY)"

These are the results :

Starting PT-Archiver NOW
2013-06-21T15:10:58 0 0
2013-06-21T15:11:44 46 50000
2013-06-21T15:12:06 67 100000
2013-06-21T15:12:27 89 150000
2013-06-21T15:12:52 113 200000
2013-06-21T15:13:15 137 250000
2013-06-21T15:13:36 158 300000
2013-06-21T15:13:55 176 350000
2013-06-21T15:14:15 196 400000
2013-06-21T15:14:33 215 450000
2013-06-21T15:14:51 233 500000
2013-06-21T15:16:42 344 502034

For the last ~2k rows, it took 111 seconds to archive. It took 500k rows 233 seconds.

Amol (ajkedar) on 2013-06-21
tags: added: pt-archiver
Daniel Nichter (daniel-nichter) wrote :

Interesting, I've not heard of or seen this before, but we'll try to reproduce it.

summary: - Pt-Archiver hangs on last rows
+ pt-archiver hangs on last rows
Changed in percona-toolkit:
status: New → Confirmed
Amol (ajkedar) wrote :

This is still a problem in
$ dpkg --list | grep percona
ii percona-toolkit 2.2.5-2 Advanced MySQL and system command-line tools
 on ubuntu 12.04 LTS

can i help you in anyway?

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers