master
mysql> show global status like 'qcache%'; +-------------------------+------------+ | Variable_name | Value | +-------------------------+------------+ | Qcache_free_blocks | 15 | | Qcache_free_memory | 63965064 | | Qcache_hits | 1103410716 | | Qcache_inserts | 261936089 | | Qcache_lowmem_prunes | 35153891 | | Qcache_not_cached | 273479539 | | Qcache_queries_in_cache | 235 | | Qcache_total_blocks | 540 | +-------------------------+------------+ 8 rows in set (0.00 sec)
mysql> show global variables like "query%"; +--------------------------------+----------+ | Variable_name | Value | +--------------------------------+----------+ | query_alloc_block_size | 8192 | | query_cache_limit | 4194304 | | query_cache_min_res_unit | 4096 | | query_cache_size | 67108864 | | query_cache_strip_comments | OFF | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | | query_prealloc_size | 8192 | | query_response_time_range_base | 10 | +--------------------------------+----------+ 9 rows in set (0.00 sec)
master
mysql> show global status like 'qcache%'; ------- ------- -----+- ------- ----+ ------- ------- -----+- ------- ----+ lowmem_ prunes | 35153891 | queries_ in_cache | 235 | ------- ------- -----+- ------- ----+
+------
| Variable_name | Value |
+------
| Qcache_free_blocks | 15 |
| Qcache_free_memory | 63965064 |
| Qcache_hits | 1103410716 |
| Qcache_inserts | 261936089 |
| Qcache_
| Qcache_not_cached | 273479539 |
| Qcache_
| Qcache_total_blocks | 540 |
+------
8 rows in set (0.00 sec)
mysql> show global variables like "query%"; ------- ------- ------- -----+- ------- --+ ------- ------- ------- -----+- ------- --+ block_size | 8192 | min_res_ unit | 4096 | strip_comments | OFF | wlock_invalidat e | OFF | time_range_ base | 10 | ------- ------- ------- -----+- ------- --+
+------
| Variable_name | Value |
+------
| query_alloc_
| query_cache_limit | 4194304 |
| query_cache_
| query_cache_size | 67108864 |
| query_cache_
| query_cache_type | ON |
| query_cache_
| query_prealloc_size | 8192 |
| query_response_
+------
9 rows in set (0.00 sec)