Mysql Logging all deadlocks

Question

I have a MySql DB that is encountering some deadlocks. I want the log all deadlocks, any thoughts of how to do this?

score 1 · Answer 1 · answered Jun 07 '11 at 12:43

1

For windows I guess you can do it here There is a bug report for this at here.

answered Jun 07 '11 at 12:43

and how do i log the deadlocks on linux? – Ran Jun 07 '11 at 12:51
It can be done by the same way as written in the answer. – Veer Abheek Singh Manhas May 29 '17 at 06:34

score 0 · Answer 2 · answered Jun 02 '17 at 12:36

Enable the global variable :- innodb_print_all_deadlocks. When this variable is enabled, information about all deadlocks in InnoDB user transaction is recorded in mysqld error log. Otherwise, you see information about only the last deadlock, using the SHOW ENGINE INNODB STATUS command. I use a tool called Monyog, it is of great help in catching deadlocks, it has a dedicated InnoDb deadlock Monitor group for which you can enable mail alerts and it notifies you every time the variable reaches critical/warning state.

Mysql Logging all deadlocks

2 Answers2