sage -
From: <[EMAIL PROTECTED]>
Sent: Wednesday, November 19, 2003 4:12 AM
Subject: very slow delete queries - never ending
> I have a problem with a bigger table on mysql 4.0.16-log / debian
linux
>
> I played around with indexes, delete quick and such, but I just can't
get
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
I have a problem with a bigger table on mysql 4.0.16-log / debian linux
I played around with indexes, delete quick and such, but I just can't get it
to work.
The following table holds >35mio rows and has >5mio inserts/replaces per
day. to clean it up I want to delete all rows older than X days.
