InnoDB Locks Held


This feature modifies the output of SHOW ENGINE INNODB STATUS, removing the debug info for locked records, adding in detailed information for locks held by each transaction (previously only displayed when the InnoDB lock monitor was enabled).

Patch Origin

Baron Schwartz.


  • innodb_show_locks_held – Number of locks held to print for each InnoDB transaction in SHOW INNODB STATUS (default: 10, maximum: 1000).
  • innodb_show_verbose_locks – Whether to show records locked in SHOW INNODB STATUS (default: off).

Comments are closed.