My comment #2 is wrong. The tool should --sleep between SELECT --limit rows, not between each delete. So the sleep code simply needs to be moved back to where it used to be: just before SELECT --limit rows. The tool is supposed to delete rows one by one as fast as it can, or bulk delete rows; --sleep doesn't apply to the archiving of rows, only to the selecting of them.
Customer was using http:// code.google. com/p/maatkit/ source/ browse/ trunk/mk- archiver/ mk-archiver? r=3701
My comment #2 is wrong. The tool should --sleep between SELECT --limit rows, not between each delete. So the sleep code simply needs to be moved back to where it used to be: just before SELECT --limit rows. The tool is supposed to delete rows one by one as fast as it can, or bulk delete rows; --sleep doesn't apply to the archiving of rows, only to the selecting of them.