I have a mysql server running with the query cache size being 128M
Here are the qcache variables values:
| Qcache_free_blocks | 13758 |
| Qcache_free_memory | 46945512 |
| Qcache_hits | 56418967 |
| Qcache_inserts | 48601636 |
| Qcache_lowmem_prunes | 21948806 |
| Qcache_not_cached | 39066097 |
| Qcache_queries_in_cache | 44858 |
| Qcache_total_blocks | 104668
And the query_cache_min_res_unit is 4096 .
I'm not sure what the meaning of a block is. For the query cache size
and the number of total blocks, I have a block size of
134217728/104668 = 1282.3186 , which is a strange number for a block
size. Am I wrong somewhere?