Bug #1746 QCache variables displaying null values even if there is some caching effect
Submitted: 4 Nov 2003 6:27 Modified: 4 Nov 2003 10:20
Reporter: Vincent Bouret Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.15-nt OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[4 Nov 2003 6:27] Vincent Bouret 
Description:
QCache variables displaying null values even if there is some caching effect.

 Qcache_queries_in_cache   0  
 Qcache_inserts   0  
 Qcache_hits   0  
 Qcache_lowmem_prunes   0  
 Qcache_not_cached   0  
 Qcache_free_memory   0  
 Qcache_free_blocks   0  
 Qcache_total_blocks   0  

When I do a request using full-text index the cache is surely being used since the same request again takes 2-3 times less time to execute.

There is no reference to cache size or limitation in my.ini

It does the same thing with 4.0.14-nt on Windows 2000.

One thing to note: the server we are using has been compiled with VC++.NET in Windows with a minor change to the full-text weighting scheme being used (as a recommendation of Sergei Golubchik).

How to repeat:
See description
[4 Nov 2003 10:20] Dean Ellis 
You must set your query_cache_size.