tly. I'll try disabling the query
cache and report back.
>
>> -Original Message-
>> From: raphi...@gmail.com [mailto:raphi...@gmail.com] On Behalf Of
>> Raphael Bauduin
>> Sent: Wednesday, August 29, 2012 2:16 AM
>> To: Rick James
>> Cc: mysql@lis
alf Of
> Raphael Bauduin
> Sent: Wednesday, August 29, 2012 2:16 AM
> To: Rick James
> Cc: mysql@lists.mysql.com
> Subject: Re: qcache settings and block meaning
>
> On Tue, Aug 28, 2012 at 6:40 PM, Rick James
> wrote:
> >> | Qcache_hits | 56418967
On Tue, Aug 28, 2012 at 6:40 PM, Rick James wrote:
>> | Qcache_hits | 56418967 |
>> | Qcache_inserts| 48601636 |
> That's a low hit rate. Perhaps you should simply turn off the Query cache?
>
>> | Qcache_free_memory| 46945512 |
> | Qcache_hits | 56418967 |
> | Qcache_inserts| 48601636 |
That's a low hit rate. Perhaps you should simply turn off the Query cache?
> | Qcache_free_memory| 46945512 |
That's a big fraction of the total. Either the QC is unn
- Original Message -
> From: "Raphael Bauduin"
>
> 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
What you calculated is the *average* block size, which is fairly useless :-)
The query cache is not formatted into f
