pt-archiver hangs on last rows
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
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,
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.
Interesting, I've not heard of or seen this before, but we'll try to reproduce it.