MySQL Forums
Forum List  »  Performance

Re: How to figure out memory left
Posted by: Rick James
Date: September 01, 2013 11:36AM

I don't know of an answer to the exact question you ask.

If there is any swapping, decrease some tunable. Otherwise, don't worry about memory. You are not likely to 'trend' into disaster. MySQL is quite stable in its memory usage. I have watched some production machines for years -- there may be an occasional 'spike', but no 'trend'.

innodb_buffer_pool_size (currently at 80% of RAM) is the prime candidate for what to decrease.

How big is max_connections? Rarely does that need to be more than a few hundred. A large value for it could be eating into the 7G you mention.

sort buffers, read buffers, etc, could (but rarely do) cause swapping.

Do you have control over settings in my.cnf? Have you changed any of them? If so, please provide SHOW VARIABLES; and SHOW GLOBAL STATUS; -- I will glance through them for other issues.

Options: ReplyQuote


Subject
Views
Written By
Posted
6395
August 29, 2013 06:25PM
Re: How to figure out memory left
1698
September 01, 2013 11:36AM


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.