Bug #79102 add max/min rows to performance schema
Submitted: 3 Nov 2015 22:46 Modified: 20 Nov 2015 9:38
Reporter: Trey Raymond Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Performance Schema Severity:S4 (Feature request)
Version:5.6.26 OS:Any
Assigned to: CPU Architecture:Any

[3 Nov 2015 22:46] Trey Raymond
currently performance schema statement aggregation (_digest table example used here) will give you the sum of rows affected or read, and the count to get an average, but it doesn't track min/max.  max would be very useful to find queries that impact replication, perform a lot of IO, or [approximately] correlate to the min/max _timer_wait values.

How to repeat:
n/a, feature request

Suggested fix:
add these values to the aggregation logic, shouldn't be significant additional overhead as the values are already being used.