"MV" == Michael Villalba [EMAIL PROTECTED] writes:
MV Thanks, Fred. The delete job has been running for 21 hours
MV at this point, and now rather simple queries on other tables hang
MV (e.g. SELECT COUNT(*) FROM other_table WHERE index=some_value).
MV I'll let it run overnight to see what
On Wed, Feb 28, 2001 at 02:38:40PM -0500, Michael Villalba wrote:
I have a rather large table (~130 million rows) running under MySQL
3.23.30 and have been very pleased with the performance of the
database. However, occasionally I have to delete millions of rows
from the table, and it
I have a rather large table (~130 million rows) running under MySQL
3.23.30 and have been very pleased with the performance of the
database. However, occasionally I have to delete millions of rows
from the table, and it appears that MySQL hangs on these jobs. To
be specific, I am running a
On Wed, Feb 28, 2001 at 02:38:40PM -0500, Michael Villalba wrote:
I have a rather large table (~130 million rows) running under MySQL
3.23.30 and have been very pleased with the performance of the
database. However, occasionally I have to delete millions of rows
from the table, and it
Thanks, Fred. The delete job has been running for 21 hours
at this point, and now rather simple queries on other tables hang
(e.g. SELECT COUNT(*) FROM other_table WHERE index=3Dsome_value).
I'll let it run overnight to see what happens, but I'm not hopeful.
Here's some addition