Imaster - 8:25 am on May 28, 2007 (gmt 0)

Thanks a ton. Query Cache works perfect and is super fast. I am impressed!

My concern is that I have around millions of different queries and I have set query-cache-size = 64M, but when I issue the command SHOW STATUS LIKE '%qcache%'; [Its almost down to 49 mb [Qcache_free_memory ] after just 11812 queries. What happens when it goes down to 0 mb

mysql> SHOW STATUS LIKE '%qcache%';
+-------------------------+----------+
¦ Variable_name ¦ Value ¦
+-------------------------+----------+
¦ Qcache_queries_in_cache ¦ 11812 ¦
¦ Qcache_inserts ¦ 11812 ¦
¦ Qcache_hits ¦ 6783 ¦
¦ Qcache_lowmem_prunes ¦ 0 ¦
¦ Qcache_not_cached ¦ 18 ¦
¦ Qcache_free_memory ¦ 49025296 ¦
¦ Qcache_free_blocks ¦ 1 ¦
¦ Qcache_total_blocks ¦ 27048 ¦
+-------------------------+----------+

Or since I have so many queries, should I increase query-cache-size to more? I have 2GB Ram.