Comment 3 for bug 979092

Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

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.