| Bug #70383 | SELECT FROM performance_schema STATUS | ||
|---|---|---|---|
| Submitted: | 20 Sep 2013 8:04 | Modified: | 30 Sep 2013 4:38 |
| Reporter: | Peter Laursen (Basic Quality Contributor) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S4 (Feature request) |
| Version: | 5.5+ | OS: | Any |
| Assigned to: | Marc ALFF | CPU Architecture: | Any |
[20 Sep 2013 8:27]
Peter Laursen
Another solution could be to 'mirror' "performance_schema STATUS" to an information_schema table.
[20 Sep 2013 8:34]
Peter Laursen
Actually I think that to 'mirror' "performance_schema STATUS" to an information_schema table would be the most logical continuation of what has already happened. SHOW ENGINE innoDB status was ported to I_S with the 'InnoDB plugin' some years ago already. However with PS I believe it would be a lot simpler as result from "SHOW p_s STATUS" is already tabular (what result from "SHOW InnoDB STATUS" is not").
[20 Sep 2013 8:39]
Peter Laursen
... and finally .. this should be seen in a monitoring context as well as in the context of automated server management.
[30 Sep 2013 4:38]
MySQL Verification Team
Hello Peter, Thank you for the feature request! Thanks, Umesh
Description: It would be nice to be able to use the output from "SHOW ENGINE performance_schema STATUS" in complex statements - in particular similar to a subquery in the FROM clause ("SELECT .. FROM (SELECT ..);"). This is not possible SELECT .... FROM (SHOW ENGINE performance_schema STATUS); The reason why it would be nice is that currently you will neeed to retrieve the full array from "SHOW ENGINE performance_schema STATUS" to the client and do filtering, sorting, parsing etc. in the client. Why not allow the use of server-side SQL for this as the resulting array from "SHOW ENGINE performance_schema STATUS" has a tabular format? (same would probably be relevant for SHOW ENGINE NDB STATUS - but I don't use that personally). How to repeat: See above. Suggested fix: Implement a SELECT-syntax/statement as a synonum for "SHOW ENGINE performance_schema STATUS" or just allow "SHOW ENGINE performance_schema STATUS" as inner query of a subquery? If there is a workaround for this, I'm not aware of, please describe and document it.