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.