Bug #44671 InnoDB: standard Monitor missing TRANSACTIONS section

Submitted: 5 May 2009 15:13 Modified: 10 Sep 2009 17:22
Reporter: Paul DuBois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.4.0 OS:Any
Assigned to: Kelly Long CPU Architecture:Any

[5 May 2009 15:13] Paul DuBois 
Description:
MySQL 5.4 includes a Google patch to provide more output from the standard InnoDB Monitor/SHOW ENGINE INNODB STATUS. In the original Google patch, the TRANSACTIONS section of the output is moved to be last:

http://code.google.com/p/google-mysql-tools/wiki/NewShowInnodbStatus

In MySQL 5.4, this section does not appear at all, and thus Monitor output is missing some pretty important information.

How to repeat:
Issue a SHOW ENGINE INNODB STATUS statement in MySQL 5.4.
[5 May 2009 16:02] MySQL Verification Team 
Monitor output in 5.4

Attachment: innodb_monitor_output.txt (text/plain), 9.66 KiB.
[5 May 2009 16:04] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[15 Jul 2009 21:40] Kelly Long 
Possible patch for bug 44671-missing transaction status in show innodb status

Attachment: mysql-bug44671.patch (application/octet-stream, text), 809 bytes.
[21 Jul 2009 20:11] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/79131

2855 Kelly Long	2009-07-21
      Fix Bug#44671
      Part of the 'show status' code was erronously removed when the google
      	patch was applied.  This patch puts it back.
[10 Sep 2009 17:22] Paul DuBois 
Noted in 5.4.2 changelog.

During incorporation of a Google patch to SHOW ENGINE INNODB STATUS
in MySQL 5.4.0, the TRANSACTIONS section of the output was
inadvertently omitted. This section has been restored.
[16 Sep 2009 5:52] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/83400

2846 Alexander Nozdrin	2009-09-16 [merge]
      Null-merge of mysql-trunk revno:2855:
      =====
      committer: Kelly Long <k.long@sun.com>
      branch nick: mysql-5.1-performance-version
      timestamp: Tue 2009-07-21 14:10:09 -0600
      message:
        Fix Bug#44671
        Part of the 'show status' code was erronously removed when the google
        patch was applied.  This patch puts it back.
      =====
      
      This patch is not compatible with 6.0.
[16 Sep 2009 6:45] Bugs System 
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090916063112-8hjmu6wkxfx5qxf4) (version source revid:alik@sun.com-20090916055020-7vc22khb1umsvkjm) (merge vers: 5.4.4-alpha) (pib:11)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.067 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.