MySQL Forums
Forum List  »  MyISAM

Re: periodic out of memory errors
Posted by: Ingo Strüwing
Date: July 05, 2006 07:00AM

Hi.

This is a pretty graphic! How did you retrieve the numbers?

I heard of the same problem before. Growing memory print of the MySQL daemon. But the problem could not be brought to a solution.

There are several ways a MySQL server could eat memory. There could be memory leaks in the server or application misbehaviour.

Memory leaks could result from bugs in the server. But we use to run with valgrind and safemalloc to find and fix as many memory leaks as possible before releasing a new version. So I claim that there are no known memory leaks in the server. But there may still be some that our tests didn't find. An indication of memory leaks would be if the memory consumption persists after *all* clients have disconnected for a moment (at the same time).

But there is also the class of application problems. If your statements create temporary tables and don't release them, creating a new one every time, mysqld would eat memory. But the temporary tables should go away after a disconnect.

There are also memory tables. These persist even after a disconnect of all threads. But for them you see .frm files in the database directories of your datadirectory.

BTW, in the "General" forum there are more people around that might have ideas regarding this problem. It is (most probably) not bound to the MyISAM storage engine.

Regards
Ingo

Options: ReplyQuote


Subject
Views
Written By
Posted
2193
July 05, 2006 06:12AM
Re: periodic out of memory errors
1374
July 05, 2006 07:00AM


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.