| Bug #61016 | SHOW ENGINE INNODB STATUS [SECTION] | ||
|---|---|---|---|
| Submitted: | 30 Apr 2011 16:05 | Modified: | 30 Apr 2011 16:23 |
| Reporter: | Justin Swanhart | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: InnoDB Plugin storage engine | Severity: | S4 (Feature request) |
| Version: | 5.6 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[30 Apr 2011 16:23]
Valeriy Kravchuk
Thank you for the feature request.
Description: I would like to be able to display only a subsection of 'SHOW ENGINE INNODB STATUS [SECTION]'. SHOW ENGINE INNODB STATUS has become extremely large with the advent of multiple buffer pools, multiple io threads, etc. While the I_S.INNODB% tables are very useful, the easily digestible information in SHOW ENGINE INNODB STATUS is still very valuable. I'd like to be able to show only certain sections, like: FILE,ROWS,TRANSACTIONS,BUFFER [POOL],etc. How to repeat: This is a feature request. Suggested fix: Extend the parser slightly: SHOW ENGINE <ENGINE_NAME> STATUS [OPERATION := {ROW,BUFFER [POOL],TRANSACTIONS,...}][,OPERATION] Add logic to 'SHOW ENGINE INNODB STATUS' to support filtering information by operation.