Re: MySql Swapping issues

2016-09-08 Thread Jesper Wisborg Krogh
Hi Machiel, On 8/09/2016 05:24, Machiel Richards wrote: ... Biggest issue at the moment is mysql taking all physical memory until nothing left, the starts swapping as well until that is completely used up. Since you are using MySQL 5.7, you can consider enabling memory instrumentation in the

Re: MySql Swapping issues

2016-09-08 Thread Johan De Meersman
- Original Message - > From: "Machiel Richards" > Subject: Re: MySql Swapping issues > > When I monitor the MySQL processlists, there is constantly about 30-35 > processes > and half of them never change simply showing as : > > Connect | 124678 | Wai

Re: MySql Swapping issues

2016-09-07 Thread Machiel Richards
chards" > Subject: MySql Swapping issues > >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. Not unreasonable, especially given the memory sizes you give. >

Re: MySql Swapping issues

2016-09-07 Thread Johan De Meersman
- Original Message - > From: "Machiel Richards" > Subject: MySql Swapping issues > >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.

MySql Swapping issues

2016-09-07 Thread Machiel Richards
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 p