]]>
]]>

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

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.

 
percona-server/features/innodb_locks_held.txt · Last modified: 2011/07/17 21:05 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Contact Us 24 Hours A Day
SupportContact us 24×7
Emergency? Contact us for help now!
Sales North America(888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training(855) 55TRAIN or
(925) 271-5054

 

Share This
]]> ]]>