This tab provides information about memory caches that affect the performance of the MySQL server. For each cache, there is a display that shows the current hit rate or usage of the cache, and a display that shows the hit rate or usage for the last few minutes.
Query Cache Hitrate: When in use, the
query cache of the MySQL server stores the text of a
SELECT
query together with the
corresponding result that was sent to the client. If an
identical query is later received, the server will retrieve
the results from the query cache rather than parsing and
executing the same query again. The hit rate indicates the
ratio of queries that were cached and queries that were not
cached. The higher the hit rate, the better the performance of
the server regarding SELECT
queries. See
The MySQL Query Cache.
Key Efficiency: The horizontal bar graph
indicates how much of the allocated key buffer is in use. If a
fairly large percentage of the key buffer is in use you may
wish to increase the key_cache_size
setting
in the
Startup
Variables section. The line graph is an indication of
the number of key_read_requests
that
resulted in actual key_reads
. The higher
the hit rate the more effective your key buffer is. A low hit
rate can indicate that you need to increase the size of your
keycache.