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
In terms of the amount of processes, that is the max amount ever seen. The
servers are monitored 24/7 so it is constantly under hawk eye from both
staff and monitoring systems.
The other memory values I was referring to are things like the open-table
cache, and other buffers as you assumed yes. Th
- 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.
Not unreasonable, especially given
