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)
• Status: Verified
• 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