Good day, we have a few server running percona / mysql server 5.7.
All the servers have quite a lot of memory installed and one specific server have 128Gb of memory.
However, on all the servers we are experiencing issues whereby the MySQL server keep son using memory at an increasing rate, at some point starting to use swap as well up to the point where the whole server fails due to lack of memory.
The server with the 128Gb of memory have Innodb_buffer_pool_size set to 90Gb, and one of the other servers have 64Gb memory and a 14Gb innodb_buffer_pool , however both have the exact same symptoms.
We have been trying to research this issue for some time now and have also enabled the memory instruments to try and figure out where the memory is going to, however even from those stats it does not show anything specifically using up a lot of memory.
Swapiness on the servers are set to 1 , and yet this did not make a lot of difference.
From OS level we tried several methods to detect memory usage, however all memory usage points to the mysqld process.
Can anyone perhaps give me some pointers on where else to look or how to find out what is eating up all the memory as this is getting quite urgent.
I would really appreciate any help.