Bug #43732 Totals/Sums in the Query Analyzer Browse Queries tab
Submitted: 18 Mar 2009 15:53 Modified: 19 Mar 2009 6:54
Reporter: Roger David Nay Email Updates:
Status: Verified Impact on me:
Category:MySQL Enterprise Monitor: Web Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[18 Mar 2009 15:53] Roger David Nay
Would like to have a row with totals of each column in the table of the Browse Queries tab. This will allow us to evaluate easier how much of an impact a change to a query or group of queries will make.

How to repeat:

Suggested fix:
At the bottom of the current table add an extra row Totals:

Query column would be blank, as would be the database and First seen columns.

The sums can be made for the following columns:
- Exec count
- Total

The Total "average" column could be the sum(x)/ Exec count. this works for Exec Time, Rows and Bytes

The max column would have the maximum of all the queries (exec time, rows or bytes)
[19 Mar 2009 6:54] Valeriy Kravchuk
Thank you for the feature request.