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.