作者：askwan@流年飄飄『AskWan』-萬志華的網絡家園
地址：http://www.askwan.com/post/143/
保留文章版權。轉載時請勿必以鏈接形式注明作者和原始出處及本聲明！

本文接著我的上篇文章來
Mysql的查詢緩存區query cache   http://www.askwan.com/post/141/

查看查詢緩存區的相關變量：

mysql> SHOW VARIABLES LIKE '%query_cache%';
+------------------------------+----------+
| Variable_name                 | Value     |
+------------------------------+----------+
| have_query_cache              | YES       | 
| query_cache_limit             | 1048576   | 
| query_cache_min_res_unit      | 4096      | 
| query_cache_size              | 33554432 | 
| query_cache_type              | ON        | 
| query_cache_wlock_invalidate | OFF       | 
+------------------------------+----------+
6 rows in set (0.00 sec)

mysql> show status like 'qcache%';
+-------------------------+----------+
| Variable_name            | Value     |
+-------------------------+----------+
| Qcache_free_blocks       | 5096      | 
| Qcache_free_memory       | 18964096 | 
| Qcache_hits              | 12192192 | 
| Qcache_inserts           | 3560370   | 
| Qcache_lowmem_prunes     | 17326     | 
| Qcache_not_cached        | 303599    | 
| Qcache_queries_in_cache | 10201     | 
| Qcache_total_blocks      | 25937     | 
+-------------------------+----------+
8 rows in set (0.00 sec)

mysql> show status like 'qcache%';
+-------------------------+----------+
| Variable_name            | Value     |
+-------------------------+----------+
| Qcache_free_blocks       | 1         | 
| Qcache_free_memory       | 18539240 | 
| Qcache_hits              | 12192502 | 
| Qcache_inserts           | 3560515   | 
| Qcache_lowmem_prunes     | 17326     | 
| Qcache_not_cached        | 303607    | 
| Qcache_queries_in_cache | 10318     | 
| Qcache_total_blocks      | 21081     | 
+-------------------------+----------+
8 rows in set (0.00 sec)