Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

alt text

My current settings:

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?

share|improve this question
up vote 1 down vote accepted

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.

share|improve this answer

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.