Bug #57538 Aggregator reports avg query time in query summary for total exec time
Submitted: 18 Oct 2010 19:52 Modified: 11 Jan 2011 17:55
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Aggregator Severity:S3 (Non-critical)
Version:2.3.0 OS:Any
Assigned to: Jan Kneschke CPU Architecture:Any

[18 Oct 2010 19:52] Mark Leith 
Description:
The aggregator currently reports the average execution time for the summary period, rather than the total execution time. 

How to repeat:
N/A - Code inspection. 

Suggested fix:
Report total execution time
[19 Oct 2010 14:16] Jan Kneschke 
revno: 491
fixes bug(s): http://bugs.mysql.com/57538
committer: jan@mysql.com
branch nick: rel-2.3
timestamp: Tue 2010-10-19 16:11:36 +0200
message:
  use the sum_value instead of the avg-value (fixes #57538/EM-4972)
  
    * the MEM-server expects the sum of the exec-time's to calculate the 
      average based on the sum() and the execution-count
[17 Nov 2010 20:56] Enterprise Tools JIRA Robot 
Diego Medina writes: 
verified fixed on 2.3.1.2038
[11 Jan 2011 17:55] John Russell 
Added to 2.3.1 change log:

The aggregator incorrectly reported the average execution time for the summary period,
rather than the total execution time.