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@lists.mysql.com
Subject: Re: qcache settings and block meaning
On Tue
to be the topic of
my next mail to the list, but you anticipated correctly :-)
Raph
-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: qcache settings and block
: 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 rja...@yahoo-inc.com
wrote:
| Qcache_hits | 56418967 |
| Qcache_inserts
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 |
|
- Original Message -
From: Raphael Bauduin rbli...@gmail.com
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
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: qcache settings and block meaning
Hi,
I have