MySQL Forums
Forum List  »  Performance

Re: Help With mysqltuner Output
Posted by: Rick James
Date: January 16, 2013 07:41PM

> innodb_buffer_pool_size (>= 66G)
> The RAM size on my server is 24GB.
> [!!] InnoDB data size / buffer pool: 66.1G/14.0G

Leave it at 14G (17G at the most). The buffer_pool must be memory resident, not paging to disk.

There are many ways that connections could persist. And, the 1001 may have happened only once; there is no history to say whether this is a recurring problem. Suggest you restart mysqld; that will reset Max_used_connections. Then keep an eye on it for a few days/weeks. If it gets close to 1000, dig deeper into how the connections are being made, and what can / cannot be done to close them, etc.

Much of mysqltuner's output is scarier than it needs to be. Do you have symptoms of problems? Slow response? Denied connections? Other? Let's start with the symptom(s), then see what, if anything, mysqltuner can suggest that relates to that.

> [OK] Key buffer size / total MyISAM indexes: 64.0M/39.3G
Hmmmm... I missed that one. It is backwards. It should not be "OK". Suggest you change key_buffer_size to 2G.

Options: ReplyQuote


Subject
Views
Written By
Posted
8246
January 14, 2013 05:33AM
5971
January 15, 2013 08:50AM
3030
January 15, 2013 09:03AM
Re: Help With mysqltuner Output
2548
January 16, 2013 07:41PM
1980
January 19, 2013 12:18AM


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.