Comment 7 for bug 1252610

Revision history for this message
monty solomon (monty+launchpad) wrote :

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)