List:General Discussion« Previous MessageNext Message »
From:Raphael Bauduin Date:August 28 2012 2:11pm
Subject:qcache settings and block meaning
View as plain text  
Hi,

I have a mysql server running with the query cache size being 128M
(134217728 bytes).

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?

Thanks

Raph
Thread
qcache settings and block meaningRaphael Bauduin28 Aug
  • Re: qcache settings and block meaningJohan De Meersman28 Aug
  • RE: qcache settings and block meaningRick James28 Aug
    • Re: qcache settings and block meaningRaphael Bauduin29 Aug
      • RE: qcache settings and block meaningRick James29 Aug
        • Re: qcache settings and block meaningRaphael Bauduin30 Aug