Out of memory: kill process (mysqld)

[xarly87]

Hi,

I have a linux 10.10 with Percona 5.5.17-55-log.

I have used Percona Online Tools for create a config optimized for dedicated server with 10gb ram.

This is the result: http://pastebin.com/yeKs4AvN

I have 10 databases, 5 innodb 5 myisam. (Are game servers)

After 24/48 hours, it starts to eats ram and it kill a mysql process. And DB gets unstable

It generates a syslog http://pastebin.com/YDuDxXBq

The thing is also that, after that event, if I stop mysql remains a memory consumption of 5GB that doesn’t dissapear until i reboot server.

Screenshoots:

Just started: http://img259.imageshack.us/img259/2548/started.jpg
Out of Memory: http://img831.imageshack.us/img831/589/ofmy.jpg
Stopped: http://img827.imageshack.us/img827/3017/stopped.png

Could you help me?

Thank you very much

[przemek]

Hi,

Can you privide output of these commands during the memory high usage:
ps aux --sort:rss|tail -40
show processlist;
show status like ‘Threads%’;

Also how many tables do you have?