> "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
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 a
> 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 info
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=some_value).
I'll let it run overnight to see what happens, but I'm not hopeful.
Here's some addition information for th
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 app
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 delet
