UBB.Developers Forums Community Development Programming MySQL and Server Configuration Key Reads v's Key requests

You can find out the usage of you Key Buffer with the following:

Cache Miss Rate = Key_reads / Key_reads_requests

The Cache Miss Rate should be smaller than 0.01.
I think with your 0.006 you are good.

The usage of your Key Buffer is shown in the Key blocks used value in the output of SHOW STATUS

So long...

Indy

Edit: You can use the Cache Miss Rate for finding an optimal size for your Key Buffer. Decrement the size and let MySQL run for while. Then take a look again, if the CMR is not higher, then the smaller size will be ok.