Re: Understanding Query-Cache math...

2006-09-04 Thread Visolve DB Team
Qcache_lowmem_prunes status variables. Thanks ViSolve DB Team - Original Message - From: "Christian Hammers" <[EMAIL PROTECTED]> To: Sent: Friday, September 01, 2006 1:52 PM Subject: Understanding Query-Cache math... Hello I don't understand why query_cache_size / que

Understanding Query-Cache math...

2006-09-01 Thread Christian Hammers
Hello I don't understand why query_cache_size / query_cache_min_res_unit != Qcache_total_blocks and Qcache_free_memory / query_cache_min_res_unit != Qcache_free_blocks Can anybody enlight me so that I know if I have to increase the Query-Cache or not? mysql> SHOW status LIKE "Qcache_%"; +-