# Out of memory: kill process (mysqld)

**URL:** <https://forums.percona.com/t/out-of-memory-kill-process-mysqld/1853>\
**Category:** Other MySQL® Questions\
**Created:** [July 31, 2012, 6:12am UTC](https://forums.percona.com/t/out-of-memory-kill-process-mysqld/1853 "2012-07-31T06:12:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![xarly87](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/xarly87/32/885_2.png) [@xarly87](https://forums.percona.com/u/xarly87)\
**Post date:** [July 31, 2012, 6:12am UTC](https://forums.percona.com/t/out-of-memory-kill-process-mysqld/1853/1 "2012-07-31T06:12:22Z")

</div>

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: [URL=“http&#58;&#47;&#47;[# Generated by Percona Configuration Wizard (http://tools.percona.com/) version - Pastebin.com](http://pastebin.com/yeKs4AvN)”][http://pastebin.com/yeKs4AvN[/URL]](http://pastebin.com/yeKs4AvN%5B/URL%5D)

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 [URL=“http&#58;&#47;&#47;[Jul 30 07:08:08 dbserver kernel: 0kB isolated(file):0kB present:7514400kB mlocke - Pastebin.com](http://pastebin.com/YDuDxXBq)”][http://pastebin.com/YDuDxXBq[/URL]](http://pastebin.com/YDuDxXBq%5B/URL%5D)

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: [URL=“http&#58;&#47;&#47;[img259.imageshack.us/img259/2548/started.jpg](http://img259.imageshack.us/img259/2548/started.jpg)”][http://img259.imageshack.us/img259/2548/started.jpg[/URL]](http://img259.imageshack.us/img259/2548/started.jpg%5B/URL%5D)  
Out of Memory: [URL=“http&#58;&#47;&#47;[img831.imageshack.us/img831/589/ofmy.jpg](http://img831.imageshack.us/img831/589/ofmy.jpg)”][http://img831.imageshack.us/img831/589/ofmy.jpg[/URL]](http://img831.imageshack.us/img831/589/ofmy.jpg%5B/URL%5D)  
Stopped: [URL=“http&#58;&#47;&#47;[img827.imageshack.us/img827/3017/stopped.png](http://img827.imageshack.us/img827/3017/stopped.png)”][http://img827.imageshack.us/img827/3017/stopped.png[/URL]](http://img827.imageshack.us/img827/3017/stopped.png%5B/URL%5D)

Could you help me?

Thank you very much

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [August 10, 2012, 1:26pm UTC](https://forums.percona.com/t/out-of-memory-kill-process-mysqld/1853/2 "2012-08-10T13:26:01Z")

</div>

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?