MySQL Forums
Forum List  »  MySQL Administrator

Key Efficiency meaning in MySQL Administrator
Posted by: Dan Ostertag
Date: November 13, 2009 11:18AM

I'm trying to improve our db performance and am looking at the health parameters in the MySQL Administrator.

The Key Efficiency horizontal bar shows the Key Buffer Usage at 34,816 while the Key Buffer size is 26,214,400. This means that none of the bar is shaded, appearing to me that none of the Key buffer is being used. The Hitratio is 0%. How do I get this key cache to be used better? We have alot of keys, alot of 1-time queries on a small number of fairly large tables are made, does this mean none are every cached?

How do I get the key cache to work?

When I type "show status like '%key%';" I get 52205 key_read_requests but only key_reads. I assume this creates the 0% hitratio.

Thanks for your help.
Dan

Options: ReplyQuote


Subject
Written By
Posted
Key Efficiency meaning in MySQL Administrator
November 13, 2009 11:18AM


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.