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

MySQL & MariaDB Other MySQL® Questions
1

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.
[URL]MySQL Bugs: #67259: MySQL 5.5.x uses more memory than 5.1.x when temporary tables are used
[URL]https://bugs.launchpad.net/percona-server/+bug/1124242[/URL]

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.

3

Thank you. I upgraded to the latest version and the issue is gone! :slight_smile: