up vote 0 down vote favorite
share [g+] share [fb]

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!

link|improve this question
100% accept rate
feedback

1 Answer

up vote 4 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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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