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
• Status: Closed
• Category: MySQL Server: Performance Schema
• Severity: S3 (Non-critical)
• Version: 5.7.6
• OS: Any
• CPU Architecture: Any

[13 Mar 2015 0:13] Jesper wisborg Krogh

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