From: Dane M. <da...@gr...> - 2007-04-27 22:16:23
|
Hi again, How is QCacheHit calculated in innotop's Q output? Dane |
From: Baron S. <ba...@xa...> - 2007-04-28 19:00:53
|
Hi, Dane Miller wrote: > Hi again, > > How is QCacheHit calculated in innotop's Q output? > > Dane In 1.4.1, it is on line 956, in the expression q_cache_hit => { src => 'Qcache_hits/Com_select', trans => [qw(percent)] }, Do you see anomalies with it? Baron |
From: Dane M. <da...@gr...> - 2007-04-30 17:01:02
|
Baron Schwartz wrote: > Dane Miller wrote: > > How is QCacheHit calculated in innotop's Q output? > In 1.4.1, it is on line 956, in the expression > > q_cache_hit => { src => 'Qcache_hits/Com_select', > trans => [qw(percent)] }, > > Do you see anomalies with it? Maybe. Is it a percentage? It's often over 100 on my boxes. Dane |
From: Baron S. <ba...@xa...> - 2007-04-30 19:08:05
|
Hi, Dane Miller wrote: > Baron Schwartz wrote: >> Dane Miller wrote: >>> How is QCacheHit calculated in innotop's Q output? >> In 1.4.1, it is on line 956, in the expression >> >> q_cache_hit => { src => 'Qcache_hits/Com_select', >> trans => [qw(percent)] }, >> >> Do you see anomalies with it? > > Maybe. Is it a percentage? It's often over 100 on my boxes. It's supposed to be, but it doesn't look right now that I look at it. It must be wrong. I'm just looking at your next message and I think you've found the problem. |
From: Dane M. <da...@gr...> - 2007-04-30 17:28:51
|
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 |
From: Baron S. <ba...@xa...> - 2007-04-30 19:14:24
|
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 |