Bug #81768 Expose a table for show engine P_S status

• Submitted: 8 Jun 2016 5:43
• Modified: 8 Jun 2016 9:19
• Reporter: Mikiya Okuno
• Status: Verified
• Category: MySQL Server: Performance Schema
• Severity: S4 (Feature request)
• Version: 5.7.13
• OS: Any
• CPU Architecture: Any

[8 Jun 2016 5:43] Mikiya Okuno

Description:
Currently, SHOW ENGINE P_S STATUS includes various useful information. However, it's less useful due to SHOW command syntax limitation. (No where, no join, no subquery, no views, no stored routines etc) I need to access same information via a table on P_S.

BTW, this should be useful for other storage engines as well.

How to repeat:
feature request

Suggested fix:
n/a

[8 Jun 2016 9:19] MySQL Verification Team

Hello Mikiya-San,

Thank you for the feature request!

Thanks,
Umesh