Tuning recommendations from mysqltuner.pl: query_cache_limit

Posted by knorv on Stack Overflow See other posts from Stack Overflow or by knorv
Published on 2010-04-11T12:55:01Z Indexed on 2010/04/11 13:03 UTC
Read the original article Hit count: 559

Filed under:

The mysqltuner.pl script gives me the following recommendation:

query_cache_limit (> 1M, or use smaller result sets)

And MySQL status output shows:

mysql> SHOW STATUS LIKE 'Qcache%';
+-------------------------+------------+
| Variable_name           | Value      |
+-------------------------+------------+
| Qcache_free_blocks      | 12264      | 
| Qcache_free_memory      | 1001213144 | 
| Qcache_hits             | 3763384    | 
| Qcache_inserts          | 54632419   | 
| Qcache_lowmem_prunes    | 0          | 
| Qcache_not_cached       | 6656246    | 
| Qcache_queries_in_cache | 55280      | 
| Qcache_total_blocks     | 122848     | 
+-------------------------+------------+
8 rows in set (0.00 sec)

From the status output above, how can I judge whether or nor the suggested increase in query_cache_limit is needed?

© Stack Overflow or respective owner

Related posts about mysql