MySQL Forums
Forum List  »  Performance

Re: Tuning headaches and questions
Posted by: Rick James
Date: June 19, 2012 08:27AM

If users are using MyISAM, then this is much too small:
> key_buffer_size 8388608

This says that they would have to be explicitly asking for MyISAM:
> default_storage_engine InnoDB

Perhaps too low:
> innodb_open_files 300

Is there anything useful in the slowlog?
> long_query_time 2.000000

Because of the way the QC does its work, this is too large:
> query_cache_size 536870912
See http://mysql.rjweb.org/doc.php/memory for further discussion.

The only thing that (in my opinion) really addresses your question is
> Opened_files 8995586
But I don't have any advice on how to shrink it. Sorry.

One more thing... You did SHOW STATUS, which showed the "SESSION" values. Please provide SHOW GLOBAL STATUS. Could it be that something is doing FLUSH TABLES much too often?

Options: ReplyQuote


Subject
Views
Written By
Posted
2826
June 17, 2012 06:47AM
1079
June 18, 2012 07:59AM
1457
June 18, 2012 08:45AM
Re: Tuning headaches and questions
979
June 19, 2012 08:27AM
1516
June 19, 2012 08:38AM


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.