Hi,
I have two questions regarding the query cache:
1. What is the difference between query_cache_limit and query_cache_size?
mysql> show variables like '%query_cache%';
have_query_cache | YES |
query_cache_limit | 1048576 |
query_cache_min_res_unit | 4096 |
query_cache_size | 20971520 |
query_cache_type | ON |
query_cache_wlock_invalidate | OFF |
2. Would an increase of the query cache size bring a positive effect to
the performance?
mysql>show status like '%Qcache%';
Qcache_free_blocks | 414 |
Qcache_free_memory | 17000952 |
Qcache_hits | 228827 |
Qcache_inserts | 731980 |
Qcache_lowmem_prunes | 0 |
Qcache_not_cached | 70644 |
Qcache_queries_in_cache | 3042 |
Qcache_total_blocks | 6584 |
3. How can I calculate a query cache hit rate?
Thanks,
Uwe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
