Bug #71456 Please expose query and result sizes in P_S, and then expose in MEM 3.X
Submitted: 23 Jan 2014 10:12 Modified: 23 Jan 2014 11:08
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S4 (Feature request)
Version:5.6.15/5.7 OS:Any
Assigned to: Marc ALFF CPU Architecture:Any
Tags: events_statements_summary_by_digest, P_S, performance_schema

[23 Jan 2014 10:12] Simon Mudd
Description:
MySQL Enterprise Monitor (2.3) exposes via the QUAN functionality (amongst other things) information on the queries' return result set size. This can be very useful.

MEM 3.0 does not expose this information as it pulls the data from the server itself using P_S.
events_statements_summary_by_digest shows SUM_ROWS_SENT.

I would like to see a SUM_BYTES_SENT, and also SUM_QUERY_SIZE_IN_BYTES as this helps identify large queries, or large result sets which may return a small number of rows (due to sending blogs) which currently are not very visible.

This information could then be exposed in MEM 3.X and would be very useful, and would return the functionality that's now currently missing.

How to repeat:
see above.

Suggested fix:
see above.
[23 Jan 2014 10:13] Simon Mudd
Correction: "due to sending blobs"
[23 Jan 2014 11:08] MySQL Verification Team
Hello Simon,

Thank you for the feature request!

Thanks,
Umesh