[clug] Out of Memory: Kill process 2689 (mysqld) score 33827 and children.

[Carlo Hamalainen]

Hi,

I have a 512Mb Linode server running Ubuntu 8.10 which has been slowly
apt-get upgraded towards 9.04. The server runs a few Wordpress blogs
and a satchmo/django shop. Every week or so cpu usage goes to 100%,
everything becomes unresponsive, and the console shows this:

Out of Memory: Kill process 2961 (apache2) score 44591 andchildren.
Out of memory: Killed process 3019 (apache2).
Out of Memory: Kill process 2689 (mysqld) score 33827 and children.
Out of memory: Killed process 2689 (mysqld).
Out of Memory: Kill process 2699 (mysqld) score 33827 and children.
Out of memory: Killed process 2699 (mysqld).
Out of Memory: Kill process 2703 (mysqld) score 33827 and children.
Out of memory: Killed process 2703 (mysqld).
Out of Memory: Kill process 2961 (apache2) score 21690 and children.
Out of memory: Killed process 3022 (apache2).
Out of Memory: Kill process 15914 (mysqld) score 34048 and children.
Out of memory: Killed process 15914 (mysqld).

I have to hard reset the server as ssh is completely unresponsive.

So, is this really a memory leak in mysqld? Other people [1] had a
similar issue but the fix suggested was to change apache2's maxclients
from 150 to 20. Does that sound ok? I'd rather collect some debug info
and make an evidence-based decision to change the maxclients option.

[1] http://forum.slicehost.com/comments.php?DiscussionID=1087

-- 
Carlo Hamalainen
http://carlo-hamalainen.net