MySQL Forums
Forum List  »  Optimizer & Parser

how to analyze this query_cache status
Posted by: d h
Date: March 30, 2007 12:46AM

Com_select 76892940
Qcache free blocks 10077
Qcache free memory 33854024
Qcache hits 47546504
Qcache inserts 75418490
Qcache lowmem prunes 13159447
Qcache not cached 1636734
Qcache queries in cache 25150
Qcache total blocks 60682

And
query_cache_size=64M
query_cache_type=1

first question: I want to know why "Qcache free memory" is so large and "Qcache free blocks" is large but "Qcache lowmem prunes" is also large?why does it use free memory?

second question: why "Qcache hits" is small compare to "Com_select",does this mean the "query_cache_size" is small?

thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
how to analyze this query_cache status
3384
d h
March 30, 2007 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.