Configuration to 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
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
Post a Comment