MySQL Bugs: #79102: add max/min rows to performance schema

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:	None
Category:	MySQL Server: Performance Schema	Severity:	S4 (Feature request)
Version:	5.6.26	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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.