Skip navigation links

MySQL Forums :: Performance :: Performance impact of "flush tables"


Advanced Search

Performance impact of "flush tables"
Posted by: Kristian Sørensen ()
Date: October 29, 2009 05:51AM

I have a MySQL Community server 5.0.51a and I suspect that i am experiencing this bug: http://bugs.mysql.com/bug.php?id=27732. The server is eating approximately 40 MB of memory every day, until the kernel runs an OOM-killer and kills mysqld.
My idea is to run "flush tables" on the server in question an see if the memory consumption drops, but I would like to know what performance impact that. There is currently ~275 open tables which is almost all tables on the server.
Is "flush tables" considered an expensive command or would it be safe to run this command once in a while (e.g. once per day)?



Edited 1 time(s). Last edit at 10/31/2009 02:53PM by Kristian Sørensen.

Options: ReplyQuote


Subject Views Written By Posted
Performance impact of "flush tables" 288 Kristian Sørensen 10/29/2009 05:51AM
Re: Performance impact of "flush tables" 198 Rick James 10/30/2009 10:41AM
Re: Performance impact of "flush tables" 192 Kristian Sørensen 10/31/2009 11:10AM
Re: Performance impact of "flush tables" 176 Rick James 10/31/2009 02:03PM
Re: Performance impact of "flush tables" 167 Kristian Sørensen 10/31/2009 03:01PM


Sorry, only registered users may post in this forum.