How to fix my key efficiency?
Posted on 2007-11-28
In the mysql administrator, under the health section, under the 'memory health' tab I see that the hit rate in my 'key efficiency' spends alot of time at 100% (on the same page, key buffer usage sits around 22,650,000 and key buffer reads 314,000,000). On the web it said that I should increase my 'key_cache_size' in startup variables (in the administrator) but I cannot find anything that says explicitly 'key_cache_size'. Does it have another name? If so where is it?
I also looked in 'my.ini', searched for 'key_cache_size' and found nothing. Should I put in an entry into that file that looks like this:
If so, how large should I set it?
MySQL 5.0.45-community-nt via TCP/IP
MySQL Client Version 5.1.11