Re: [Innotop-discuss] QCacheHit calculation

[Baron S. <ba...@xa...>]

Dane Miller wrote:
> Baron Schwartz wrote:
>>           q_cache_hit    => { src => 'Qcache_hits/Com_select', 
>>               trans => [qw(percent)] },
>>
>> Do you see anomalies with it?
> 
> I'm far from an expert, but my notes from Kristian Kohntopp's
> presentation "Monitoring MySQL" show a different calculation:
>   Hit-Ratio:
> qcache_hits*100 / ( qcache_hits + com_select )
> 
> (page 18 of slides):
> http://mysqldump.azundris.com/uploads/monitoring_mysql_slides_en.pdf
> 
> Dane
> 

Yes, I think that's the right formula.

By the way, you can edit these formulas through this admittedly 
circuitous route:

^ to open the table editor
? to see what the key bindings are
j/k to select the desired column
e to edit the column

... and so on.  FYI, you have to specify the variable names in the right 
lettercase (Qcache_hits, not qcache_hits) because Perl's hashes are 
case-sensitive.

I'll make this fix to the innotop code now.

Thanks,
Baron