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
• Status: Verified
• Category: MySQL Enterprise Monitor: Web
• Severity: S4 (Feature request)
• Version: 2.2.0.1709
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[18 Mar 2009 15:53] Roger David Nay

Description:
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:
N/A

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.