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 appears that MySQL hangs on these jobs. To
> be specific, I am running a delete job now that will remove about
> 4 million rows. It has been running for 11 hours on a 4-processor
> Sun E450 with 4Gb. The OS is Solaris 2.7. For about the last
> 10 hours the state displayed by 'show processlist' has been 'end'.
How big is your key_buffer? record_buffer?
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
