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.
Last edited by indy; 06/07/2003 7:10 AM.