Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

using the mysql workbench administrator - my key efficiency is at 99.97% i have read about adding 'key_cache_size=100M' to my.cnf and increasing it as needed

is this the correct fix for the problem? im runing server 5.5.11 on server 2008 r2 , 24gb ram

thanks!

share|improve this question
add comment

1 Answer

up vote 6 down vote accepted

That's actually remarkably good - the higher the better.

The MySQL performance is good if the value of Key Read Efficiency is 90 percent and above

http://www.webnms.com/mysql_agent/help/mysql_agent/performance.html

share|improve this answer
    
oh well that saves me a dramatic headache - i was reading this and wasn't sure dev.mysql.com/doc/administrator/en/… –  Jeff May 4 '11 at 18:36
    
here is another question for you, how high is the query cache hitrate supposed to be? mine is at 42.88% –  Jeff May 4 '11 at 18:38
1  
The cache hit rate depends highly on the application running against the DB. If you control the application, you should be able to get a very high hit rate. If you don't, (and it is poorly written), you can expect some really low values. –  Ryaner May 4 '11 at 18:44
1  
That's nothing to worry about if I remember correctly. You can read on about that on mysqlperformanceblog.com/2006/07/27/mysql-query-cache –  Eduardo Ivanec May 4 '11 at 18:47
1  
I'm not expert on this, but in my opinion a good although very basic methodology for cache sizing (specially when the problem is so relative to the app) seems to be: increase it, for example 2x, and see how much the metric you're analizing improves. –  Eduardo Ivanec May 4 '11 at 18:52
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.