Log all MySQL dead locks

SET GLOBAL innodb_print_all_deadlocks = 'ON';
The option is dynamic, and can be enabled without a service restart. 
If you want to make it persistent after a service restart, you may want to add it to the my.cnf file as:

[mysqld]
...
...
innodb_print_all_deadlocks = 1

Comments