# Mysql 5.7 memory usage problem OOM

**URL:** <https://forums.percona.com/t/mysql-5-7-memory-usage-problem-oom/6657>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [October 30, 2018, 8:05am UTC](https://forums.percona.com/t/mysql-5-7-memory-usage-problem-oom/6657 "2018-10-30T08:05:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![zsebacsi](https://avatars.discourse-cdn.com/v4/letter/z/a5b964/32.png) [@zsebacsi](https://forums.percona.com/u/zsebacsi)\
**Post date:** [October 30, 2018, 8:05am UTC](https://forums.percona.com/t/mysql-5-7-memory-usage-problem-oom/6657/1 "2018-10-30T08:05:16Z")

</div>

Hi  
We are using a 3 node galera cluster with Mysql 5.7 5.7.23-23-57-log on ubuntu 16.04 x64, 64G ram + 64g swap

my problem is that mysql memory usage is constantly growing and after a few days it runs to an OOM and got killed.

I’ve collected the following graphs from munin.

in the configuration I do not see any extrem value, we have already lowered them, no success.  
Tried: update mysql, update OS, update kernel, reboot, half all the parameters, no luck

concurrent running user number is about 6, sleep is about 130 (connection pooling is in effect on the application)

I ran out of ideas, dunno how to troubleshoot this issue. thanks if you can point me to the right direction.

details from config:  
key-buffer-size = 4M # 32M  
max-allowed-packet = 12M  
max-connect-errors = 1000000  
tmp-table-size = 16M  
max-heap-table-size = 16M  
query-cache-type = 0  
query-cache-size = 0  
max-connections = 1000  
thread-cache-size = 100  
open-files-limit = 65535  
table-definition-cache = 2048  
table-open-cache = 10120  
innodb-flush-method = O\_DIRECT  
innodb-log-files-in-group = 2  
#zcs - half the orignal  
innodb-log-file-size = 24M  
innodb-flush-log-at-trx-commit = 1  
innodb-file-per-table = 1  
innodb-buffer-pool-size = 8G #16G

![photoid=52756](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/5/5a1d715fe478de6ffb142a5cd9d8d85656f2df28.png)

![photoid=52757](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/a11836f2cc615a7c61905984dcf636d73a05c922.png)

![photoid=52758](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/4/43864347e7526db927d3fe644de79f9495080c4c.png)
