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

Tyler & Cameron Winklevoss – Net Worth, Cryptocurrency holdings, Bio (in 2020)

Tyler & Cameron Winklevoss – Net Worth, Cryptocurrency holdings, Bio (in 2020) ... Blockmanity's role is to inform the cryptocurrency and blockchain ...
by via Google Alert - Cryptocurrency OR Blockchain

Comments

Popular posts from this blog

jcmd - a utility to send diagnostic command requests to a Java Virtual Machine supporting this feature.