Bug #76305 Com_stmt_reprepare missing in Performance Schema implementation of SHOW STATUS
Submitted: 13 Mar 2015 0:13 Modified: 8 Apr 2015 13:26
Reporter: Jesper wisborg Krogh Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.7.6 OS:Any
Assigned to: CPU Architecture:Any

[13 Mar 2015 0:13] Jesper wisborg Krogh
In MySQL 5.7.6 it is possible to get the SHOW STATUS output through the Performance Schema. For the Com_% status variables, these can generally be found from performance_schema.statement_summary_global_by_event_name (for the global values) and performance_schema.statement_summary_by_thread_by_event_name (for the session values).

However one is missing - Com_stmt_reprepare - as it's not a statement, so it is not included int the statement_summary_% tables and it is not included in global_status/session_status either.

How to repeat:
SET GLOBAL show_compatibility_56 = OFF;

Check the content of the Performance Schema tables global_status and statement_summary_global_by_event_name.
[8 Apr 2015 13:26] Paul Dubois
Noted in 5.7.8, 5.8.0 changelogs.

The Com_stmt_reprepare status variable was missing from the
Performance Schema global_status and session_status tables.