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:

innodb_print_all_deadlocks = 1


Popular posts from this blog

PowerMTA sample virtual PMTA config file

Hosting Control Panels