]]>
Call us: 1-888-316-9775 • Contact Us
MySQL and InnoDB are trademarks of Oracle Corp.
Proudly running Percona Server
Copyright © 2006-2013 Percona Inc.
Copyright, Trademark, and Privacy Policy • Sitemap
]]>
More Compact Locks Status Output
Description
This feature makes InnoDB's status output more compact so deadlocks don't fill it up and make useful information hard to find. It makes it possible to configure the number and verbosity of locks printed.
Other Information
| Author/Origin | Baron Schwartz, http://lists.mysql.com/internals/35174 |
| Bugs fixed | http://bugs.mysql.com/bug.php?id=29126 |
System Variables
This feature provides two new status variables.
innodb_show_locks_held
| General Description: | |
|---|---|
| Command Line | Yes |
| Config File | Yes |
| Variable Scope | Global |
| Dynamic Variable | Yes |
Specifies the number of locks held to print for each InnoDB transaction in SHOW INNODB STATUS.
innodb_show_verbose_locks
| General Description: | |
|---|---|
| Command Line | Yes |
| Config File | Yes |
| Variable Scope | Global |
| Dynamic Variable | Yes |
Specifies to show records locked in SHOW INNODB STATUS. The default is 0, which means only the higher-level information about the lock (which table and index is locked, etc) is printed. If set to 1, then traditional InnoDB behavior is enabled: the records that are locked are dumped to the output.
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
