MySQL Forums
Forum List  »  InnoDB

Memory usage remains high after large delete
Posted by: Ben Tischler
Date: September 07, 2008 05:37PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Memory usage remains high after large delete
2891
September 07, 2008 05:37PM


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.