MySQL Bugs: #40469: Put most status counters from SHOW INNODB STATUS into SHOW STATUS

Bug #40469	Put most status counters from SHOW INNODB STATUS into SHOW STATUS
Submitted:	1 Nov 2008 14:20	Modified:	23 Sep 2010 8:52
Reporter:	Mark Callaghan	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S4 (Feature request)
Version:	5.0.37	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	innodb, show, STATUS

Description:
SHOW INNODB STATUS is limited to 64000 bytes. This is frequently too small and when the limit is reached useful output is truncated. This is made worse by printing a large variable length section (list of open transactions) before smaller status information (os_aio_print(), ibuf_print(), buf_print_io(), ...)

How to repeat:
Create many connections, run SHOW INNODB STATUS

Suggested fix:
Make the default for the limit larger than 64000. 
Make the limit configurable via a my.cnf variable.
Print the transaction list last.

Put most status counters in SHOW STATUS output so that tools don't need SHOW INNODB STATUS for performance monitoring. This is much better as less parsing is needed to extract name/value pairs from SHOW STATUS.

Mark,

I think this request is actually a duplciate of http://bugs.mysql.com/bug.php?id=19825 (although your suggestion about SHOW STATUS seems new). Please, check.

Yes it is a duplicate except for the request that more data from Innodb be put into SHOW STATUS. My search found this, but I did not read it given the title. Sorry for the extra work.

I think that the request to put most status counters in SHOW STATUS output so that tools don't need to parse SHOW INNODB STATUS is new and more than reasonable. I had changed the title for this bug report accordingly.

Mark, we are gradually moving away from unstructured printout such as show innodb status and innodb_monitor_table etc. Most status counters will be available as counters in INFORMATION_SCHEMA.INNODB_METRICS table. And any new counters will be added to metrics table instead of status variable. We plan to  keep the existing output for a release or two before gradually phase them out.

Bug #56922 increase the show innodb status limit from 64K to 1M. And we are moving status to the new metrics table.