Query Cache,看上去很美
查看了线上的query_cache,利用率非常低下:
mysql> show status like '%QCache%';+-------------------------+------------+| Variable_name | Value |+-------------------------+------------+| Qcache_free_blocks | 17638 || Qcache_free_memory | 78529224 || Qcache_hits | 777550194 || Qcache_inserts | 1801925951 || Qcache_lowmem_prunes | 25952293 || Qcache_not_cached | 667738421 || Qcache_queries_in_cache | 35621 || Qcache_total_blocks | 88908 |+-------------------------+------------+8 rows in set (0.00 sec)