Re: Memory usage increasing constantly
Posted by:
Rick James
Date: April 29, 2014 09:35AM
> it begins using the swap
That's really bad for performance of MySQL.
> I have constantly around 150 alive connections
Why do they need long-lived connections? Web applications, for example, connect, build a page, then disconnect.
Are you using MyISAM? Or InnoDB?
These would be the main things to throttle to keep from swapping (in your case):
innodb_buffer_pool_size = 3000M
max_connections = 1650
If you provide these (after running for a day), I will provide a more in-depth analysis of your settings:
SHOW VARIABLES;
SHOW GLOBAL STATUS;
Subject
Written By
Posted
Re: Memory usage increasing constantly
April 29, 2014 09:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.