Digital Marketing

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

Popular posts from this blog

How to fix Google Apps Script: Script function not found: doGet

Creating sort index in MySQL

How to fix: df shows no file systems processed on Linux