Innodb Deadlock Monitoring

The 'InnoDB deadlock' monitor is a little different than the rest of the monitors and will require a little additional explanation. Whereas all other monitors are based on the return of SHOW GLOBAL STATUS, SHOW GLOBAL VARIABLES and SHOW SLAVE STATUS, the 'InnoDB deadlock' monitor is based on output from SHOW ENGINE INNODB STATUS. This statement differs from the first-mentioned in the sense that it does not return as single discrete value (like a single number), but a rather long string instead with lots of information. From this long string we extract what is related to deadlocks. 

With this monitor it does not make sense to distinguish between 'Current' and 'Delta' timeframes. They will display the same in Monyog - like this,

Deadlockmonitoring

'new deadlock detected' tells if a new deadlock was reported by INNODB STATUS between the last two data retrievals. 'last deadlock detected' shows information about the last deadlock detected (if any). To view all deadlock situation that Monyog has information about use the 'History' timeframe.

Note that there is a limitation with deadlock information returned by SHOW ENGINE INNODB STATUS that will also affect Monyog: It returns only information about the last deadlock. So if more than one deadlock has occurred between two data retrievals, Monyog will only have information about the latest.


NOTE: Security, Excessive Privileges, InnoDB Deadlocks and Replication counters are available only in Monyog Ultimate.

Still need help? Contact Us Contact Us