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
gt; Sent: Tuesday, August 28, 2012 7:12 AM
>> To: mysql@lists.mysql.com
>> Subject: qcache settings and block meaning
>>
>> Hi,
>>
>> I have a mysql server running with the query cache size being 128M
>> (134217728 bytes).
>>
>> Here are the qca
off the QC for systems with constant write activity.
Otherwise, 50M is a reasonable max.
> -Original Message-
> From: raphi...@gmail.com [mailto:raphi...@gmail.com] On Behalf Of
> Raphael Bauduin
> Sent: Tuesday, August 28, 2012 7:12 AM
> To: mysql@lists.mysql.com
> Subject: q
- 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
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_
