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;

Options: ReplyQuote




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.