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
Here is my info...
I am running slackware 8 (linux 2.2.19)
Mysql Ver. 3.23.40 (install via source)
System AMD T-Bird 1Gig / 1 512MB Ram
Here is my cnf
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_pa
On Wed, Sep 19, 2001 at 04:37:03PM -0400, Phillip Spademan wrote:
> Hello All.
>
> I am working with a rather large MySQL DB, it seems that it likes to
> swap ALOT, even after the operations are done, i have bumped up my
> cache sizes, i have tones of .bin files in my var dir, any ideas?
What OS
