Re: very slow delete queries - never ending

[gerald_clark]

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 20 hours...

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]