Issue 88 in innotop: "Slow" query number (or my interpretation) is wrong

[inn...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 88 by jgoatc...@sparefoot.com: "Slow" query number (or my
interpretation) is wrong
http://code.google.com/p/innotop/issues/detail?id=88

I ran innotop against a particular host (-h) and with "-d 20"
innotop version: 1.9.1
MySQL version: 5.5.27-log on Amazon RDS

My interpretation of the "Slow" column is that it is a subset of the QPS
column. In other words, if QPS is 1000 and Slow is 100, then I can deduce
that 10% of the queries run within the interval were slow.

What I expected was a report showing about 5% of queries being slow for
every interval, instead I got:

When Load Cxns QPS Slow ......
Now 0.00 17 1.69k 4.73k ......

This made me think....is "Slow" the total number of slow queries for the
interval? If yes, is it based on the status variable "Slow_queries"?

Thank you.


--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings

[inn...@googlecode.com]

Updates:
Status: NotABug

Comment #1 on issue 88 by lefred.d...@gmail.com: "Slow" query number (or my

interpretation) is wrong
http://code.google.com/p/innotop/issues/detail?id=88

Hello,

Indeed Slow is the value of the queries that reached the interval during
the previous interval.

And yes it uses Slow_queries status counter to get the value.

Regards,