From: MAS!
Date: January 25 2009 4:34pm
Subject: mysql administrator and different cache hit graphs
List-Archive: http://lists.mysql.com/mysql/216022
Message-Id: <226A0714-9FCA-4AF6-B756-A87367B981DA@gmail.com>
MIME-Version: 1.0 (Apple Message framework v753.1)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Content-Transfer-Encoding: 7bit

I wonder why with tre different MySQL administrator istances I have 3  
different QueryCache Hitrate on the same database, in the same time :(

I'm trying with:

- MySQL administrator v.1.2.12 (Ubuntu 8.10): the query hitcache is  
always at 100% (average 100)

- MySQL administrator v.1.2.5rc (Debian etc): average 86%

- MySQL administrator v.1.2.12 (Max OS X 10.4.11): average 40%

NB: the graph formula is always the same (the default one), then:

(^[Qcache_hits]/(^[Qcache_hits]+^[QCache_inserts]+^ 
[Qcache_not_cached]))*100

which one is correct?
and why I have so different results?!
thank you in advance
bye
MAS!