Web lists-archives.com

MySql Swapping issues




Hi Guys

    I am hoping this mail find everyone to be good.

    I am looking for some more info or perhaps some advice on an issue that
I am busy investigating.

    There are 4 databases that I am busy looking at that seems to be
building up memory usage over the course of 3 to 4 days and once physical
memory is used up it starts swapping to the point where even swap space is
used up and the server dies.



    I had a look at the settings and the innodb buffer pool on one server
is set to about 70% of the physical memory and the others to about 30% of
physical memory.

    All other buffer and memory relevant parameters are set to fairly low
values as they were recently decreased with no difference in the symptoms.

     In terms of server and queries, The smallest server have 64Gb of
physical memory and the biggest server have 128Gb of physical memory and
the biggest server database size is about 600Gb odd.

     I had a look at the processes running and there are at best 38
processes running including the replication processes.


    I do not see any other hardware related issues and swappiness settings
have been configured to 1.

    I have worked on so many larger and busier databases with less memory
without experiencing this issue and thus far I have not been able to find
the root cause for this issue.


   The current version is 5.7.13.


    Any ideas , links, advice, etc... will be appreciated.


Regards

-- 
I am a bomb technician...If you see me running, TRY TO KEEP UP!