===MySQL query cache===
The MySQL query cache is disabled by default

Once you have enabled it in /etc/my.cnf
%%
query_cache_size=8M
%%

and restarted mysqld you can check its settings using

%%(sql)
mysql> show status like 'qcache%';
+-------------------------+----------+
| Variable_name | Value |
+-------------------------+----------+
| Qcache_free_blocks | 505 |
| Qcache_free_memory | 1379664 |
| Qcache_hits | 14512295 |
| Qcache_inserts | 2372908 |
| Qcache_lowmem_prunes | 367026 |
| Qcache_not_cached | 4759779 |
| Qcache_queries_in_cache | 4784 |
| Qcache_total_blocks | 10301 |
+-------------------------+----------+
8 rows in set (0.02 sec)
%%
and
%%(sql)
mysql> show variables like 'query_cache%';
+------------------------------+----------+
| Variable_name | Value |
+------------------------------+----------+
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 16777216 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
+------------------------------+----------+
5 rows in set (0.00 sec)
%%

MySqlQueryCacheGrowing

----
REFERRERS
{{backlinks}}