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'.
I've read in the archives that large deletes take a long time. But
should they take this long? Also, can anyone tell me what process
state 'end' (from 'show processlist') means?
Thanks,
Michael
