Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

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

 
discard

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.