Memory usage remains high after large delete
I just did a large delete - deleted 27 million rows and took 80 minutes. Memory usage remained at 34.3% during the delete (which is consistent with innodb_buffer_pool_size setting), but memory usage on the mysqld process hasn't dropped even after the delete has completed (it's been over 12 hours).
Any ideas why the memory usage would not drop back to normal after the delete is finished? Is there something else I should run after a large delete like this?
Server is running Fedora Core 6 with MySQL 5.0.27.
Thanks.
Subject
Views
Written By
Posted
Memory usage remains high after large delete
2892
September 07, 2008 05:37PM
1745
September 07, 2008 07:47PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.