Public bug reported: Mysql gradually consumes memory . The memory is never released back to OS . The easiest way to reproduce the issue is run few mysqldumps and observe memory usage. I used : mysqldump DB1 > /dev/null &
About 5-6 times. After dumps are completed mysql do not release memory and continue to consume even more memory. Mysqld process uses all system memory, then starts to use swap memory up to the point where the database is killed by OOM errors. here is memory usage after few mysqldumps commands : ps -aux | grep mysql mysql 607 0.7 49.0 1769788 1005184 ? Ssl Aug10 10:50 /usr/sbin/mysqld 1GB on a system with 128MB innodb buffer pool. Performance schema does not report any issues and states that myslq is taking only around 400MB . The issue seems to be related to the default memory allocation library malloc. Installing jemmalloc and forcing jemmalloc in mysql conf seems to resolve this issue . I used the same method as described before and memory usage looks stable : ps uax | grep mysql mysql 1540 5.9 23.4 957244 481036 ? Ssl 12:59 4:38 /usr/sbin/mysqld Same issue and workaround was reported on mysql bug forum by Machiel Richards . lsb_release -rd Description: Ubuntu 16.04.2 LTS Release: 16.04 mysql-server: Installed: 5.7.19-0ubuntu0.16.04.1 Candidate: 5.7.19-0ubuntu0.16.04.1 Version table: *** 5.7.19-0ubuntu0.16.04.1 500 500 http://de.archive.ubuntu.com/ubuntu xenial-updates/main amd64 Packages 500 http://de.archive.ubuntu.com/ubuntu xenial-security/main amd64 Packages 100 /var/lib/dpkg/status 5.7.11-0ubuntu6 500 500 http://de.archive.ubuntu.com/ubuntu xenial/main amd64 Packages ** Affects: mysql-5.7 (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1710146 Title: mysql never realase memory To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1710146/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs