Bug #27774 Add undo slots metrics counter information

• Submitted: 12 Apr 2007 2:52
• Modified: 11 Feb 2011 0:19
• Reporter: Arjen Lentz
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S4 (Feature request)
• Version: any
• OS: Any
• Assigned to: Jimmy Yang
• CPU Architecture: Any
• Tags: innodb, show, STATUS, undo

[12 Apr 2007 2:52] Arjen Lentz

Description:
It would be great if SHOW ENGINE INNODB STATUS could display stats regarding undo
slots. It's pretty bad to have such a bad issue occur with no advance warning or way of monitoring.

How to repeat:
See bug#18828, bug#26590, bug#26608

[12 Apr 2007 3:12] MySQL Verification Team

Thank you for the bug report.

[7 Oct 2010 11:03] Jimmy Yang

Added a monitor counter "trx_num_undo_slot_used" to monitor how many undo slot has been used (and its max value etc.)

[29 Oct 2010 6:55] Jimmy Yang

checked in mysql-trunk-innodb

[13 Nov 2010 16:17] Bugs System

Pushed into mysql-trunk 5.6.99-m5 (revid:[e-mail]-20101113155825-czmva9kg4n31anmu) (version source revid:[e-mail]-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)

[13 Nov 2010 16:30] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20101113160336-atmtmfb3mzm4pz4i) (version source revid:[e-mail]-20101113152540-gxro4g0v29l27f5x) (pib:21)