Home / server / Questions / 213824
Accepted
Joshua Enfield
Asked: 2010-12-18 12:13:28 +0800 CST

MySQL Query Caching - Watching in MySQL administrator bounces between 0 and 97% hit rate?

  • 772

alt text

My current settings:
query_cache_size=20M
query_cache_type=1
query_cache_limit=1M

Most of the queries return the exact same set of results (about 15 rows) and occur every few seconds.

Can anyone tell me how to interpret this graph for cache tuning?

mysql cache

2 Answers

  1. You should know, that if table gets modification all queries derived from this table are invalidated at once. Your table probably gets modification, so your query cache is invalidated.

    More about query cache.

    • 2
  2. Best Answer

    Same result doesn't guarantee that the query will get cached. Example >DATE type query is not at all cache friendly because every query will be different even if the result is the same. Take a look at your queries to determine how to make them cachable.

    • 1