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
- 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
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.
>
- 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.
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