MySQL Forums
Forum List  »  InnoDB

Re: MySQL 5.5.8 - Configuration Settings Suggestions
Posted by: Aftab Khan
Date: June 25, 2012 12:23PM

Thanks for providing requested data.

Your database server's uptime is 1 day! (so you restarted it recently)

Following are per thread/connection memory buffers and the values for them are high, default values would be fine

>read_buffer_size 117440512 # 112M
>read_rnd_buffer_size 318767104 # 304m


Sort buffer is large as well
>sort_buffer_size 8388608 #8m


>Slow_queries 4120
you have many slow queries (whereas threshold for it is long_query_time=5, I would prefer '2')

Provide us with EXPLAIN output of the top 5 SELECT queries here (I would also expect SHOW CREATE TABLE too)


-- innodb specific

>innodb_buffer_pool_size 12884901888 #12G


>innodb_log_file_size 5242880 # 5M

log file size is too small.

Recommended size is:

innodb_log_file_size=2047M

Steps to safely change innodb log file size documented here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-data-log-reconfiguration.html
http://www.mysqlperformanceblog.com/2011/07/09/how-to-change-innodb_log_file_size-safely/


And upgrade to MySQL 5.5.25 is recommended (as you are using the very first GA release of 5.5)



Edited 2 time(s). Last edit at 06/25/2012 12:52PM by Aftab Khan.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.5.8 - Configuration Settings Suggestions
1323
June 25, 2012 12:23PM


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.