Mysql Query Cache not showing hits/inserts

[GoogleCodeExporter]

Please see attached.

mysql> show global status like 'Q%';

| Qcache_free_blocks      | 18828      | 
| Qcache_free_memory      | 59262960   | 
| Qcache_hits             | 808793242  | 
| Qcache_inserts          | 640900348  | 
| Qcache_lowmem_prunes    | 413154479  | 
| Qcache_not_cached       | 239947560  | 
| Qcache_queries_in_cache | 56343      | 
| Qcache_total_blocks     | 146416     |

Thanks for looking into this.

Original issue reported on code.google.com by akach...@gmail.com on 30 Nov 2010 at 5:17

Attachments:

• mysql_query_cache.png

[GoogleCodeExporter]

It doesn't show absolute values, it shows changes over time.  Wait 5 minutes 
and take another sample.  Does the sample show increases in those counters?

Original comment by baron.schwartz on 30 Nov 2010 at 7:30

[GoogleCodeExporter]

The counters do increase. The problem is that the scale of "Queries in cache" 
is huge compared to everything else.
It happens in all our servers
Thanks

Original comment by akach...@gmail.com on 30 Nov 2010 at 7:55

[GoogleCodeExporter]

OK; there is no problem then, because the text on the graphs can show you what 
you're looking for.  Or, if you like, you can change the scale to logarithmic.  
(But the default non-log scale is still the right way to ship the templates 
IMO.)

Original comment by baron.schwartz on 15 Jan 2011 at 5:54

• Changed state: NotABug