GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

5.5.30-rel30.2-log and trouble with SWAP and memory leak

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

  • 5.5.30-rel30.2-log and trouble with SWAP and memory leak

    Hello,

    i do have some issue with the Percona MySQL server. I am running a Master-Slave setup with INNODB-file-per-Table and the Master-system is always eating up my swap memory, which will eventually lead to OOM killer invocation. The MySQL server is overcommitting the virtual memory:

    ps output
    27387 mysql 20 0 70.7g 53g 6120 S 18.9 84.3 17350:51 mysqld

    vmstat
    procs -----------memory---------- ---swap-- -----io---- -system-- -----cpu------
    r b swpd free buff cache si so bi bo in cs us sy id wa st
    2 0 8846712 247916 27792 9339132 0 0 0 25 0 0 1 0 99 0 0


    top
    KiB Mem: 66100444 total, 65777416 used, 323028 free, 28472 buffers

    open files
    1984


    Please help or advise me. I am stucked ;-(




  • #2
    Hi,

    Looks like you might be hitting this bug where there is a memory leak while using InnoDB temp tables.
    http://bugs.mysql.com/bug.php?id=67259
    https://bugs.launchpad.net/percona-server/+bug/1124242

    Above bug is fixed in PS 5.5.32 so you can upgrade it and check. In the mean time, can you provide some more details like my.cnf of both the servers, output of "SHOW GLOBAL VARIABLES" and "free -m"?

    Thanks.

    Comment


    • #3
      Thank you. I upgraded to the latest version and the issue is gone! :-)

      Comment

      Working...
      X