I enabled the InnoDB Lock Monitor in my MariaDB 5.5 instance (using XtraDB+ as the InnoDB – which is the default in MariaDB) and noticed that while the SHOW ENGINE INNODB STATUS was being logged to the error log, it wasn’t logging the “additional” lock information – it just looked like the plain ‘ole INNODB STATUS.
Long story short, Percona added a new variable so one has better control over what gets logged:
innodb_show_verbose_locks
If off (default), then the InnoDB Lock Monitor logs the normal INNODB STATUS, and if enabled, then it logs it with the extended lock information.
They also created another variable that goes along with this one (and the InnoDB Lock Monitor), which is:
innodb_show_locks_held
This variable indicates the number of locks to print that are held …
[Read more]