Hi Richard,
As I think Gerald Clark said, you could run DELETEs with LIMITs (like
1000-1, etc. at a time) in a loop until rows all rows are deleted.
This won't make the deletes any faster (probably slightly slower total,
actually), but will allow other clients to use the table in between.
Hav
Perhaps you could add a limit to the delete, pause, and re-run until done.
[EMAIL PROTECTED] wrote:
snip
mysql> delete quick from datatable where acttime < '2003-11-14 09:39:49';
or
mysql> delete from datatable where acttime < '2003-11-14 09:39:49';
...takes forever. I killed it after 2
