Bug #80569 max_latency is not correct for sys.host_summary_by_statement_latency view

• Submitted: 1 Mar 2016 5:03
• Modified: 30 Jun 2016 16:32
• Reporter: Mikiya Okuno
• Status: Closed
• Category: MySQL Server: SYS Schema
• Severity: S3 (Non-critical)
• Version: 5.7.11
• OS: Any
• CPU Architecture: Any

[1 Mar 2016 5:03] Mikiya Okuno

Description:
`sys`.`format_time`(SUM(`performance_schema`.`events_statements_summary_by_host_by_event_name`.`MAX_TIMER_WAIT`)) AS `max_latency`

What does sum of max latency really mean?

How to repeat:
show create table sys.host_summary_by_statement_latency.

Suggested fix:
s/SUM/MAX/

[30 Jun 2016 16:32] Paul DuBois

Posted by developer:
 
Noted in 5.7.14 changelog.

In the host_summary_by_statement_latency and 
x$host_summary_by_statement_latency sys schema views, the max_latency
column was incorrect.