pt-archiver hangs on last rows

Reported by Moody Youssef on 2013-06-21
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Toolkit
Undecided
Unassigned

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
TIME ELAPSED COUNT
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
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers