Announcement

Announcement Module
Collapse
No announcement yet.

Out of memory: kill process (mysqld)

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Out of memory: kill process (mysqld)

    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

  • #2
    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?

    Comment

    Working...
    X