Bug #26210 Describe SHOW INNODB STATUS results in more details
Submitted: 9 Feb 2007 6:54 Modified: 24 Apr 2009 18:59
Reporter: Valeriy Kravchuk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:4.1, 5.0, 5.1 OS:Any (any)
Assigned to: Paul DuBois CPU Architecture:Any

[9 Feb 2007 6:54] Valeriy Kravchuk 
Description:
This manual page, http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html, have only "some notes" on the output of SHOW INNODB STATUS (and no real details about the additional information provided by InnoDB Monitors). This makes InnoDB troubleshooting and perfromance tuning very hard for users.

How to repeat:
Read the manual and try to understand all the SHOW INNODB STATUS results (locks held by transactions, for example) beased on that limited notes.

Suggested fix:
Describe it at least at the level of details given in http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/. Or give a link to that and other useful articles from community.
[28 Jul 2008 14:12] MC Brown 
Assigning to Paul
[24 Apr 2009 18:59] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Added links to the MySQL Performance Blog article and and article by Mark Leith.
Added some information for the standard InnoDB Monitor.
Added sections for the Tablespace and Table Monitors.