> 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 information for those interested. The table
> in question has 3 indices. The data and index files for the table
> each occupy about 5Gb.
>
> I'm running the 3.23.30 binaries downloaded from MySQL.com
It may be useful .. I had a simple table (13 * unsigned int, 3
indexes) with 33 million rows, and I had to delete 19 million. It
took 12 hours to complete !!
Paul Wilson
iinet Ltd
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php