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
A little confused as to why MySql is swapping when there is more than
enough real memory still available on the server. I'm having a
serious problem with a production server running out of swap space
and in turn causing mysql to crash with the following error message.
According to the TOP repor
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
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?
Thanx!
_
Get you
