sql 命令开启 innodb_print_all_deadlocks ,日志记录死锁
mysql> set global innodb_print_all_deadlocks = ON;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like 'innodb_print_all_deadlocks';
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| innodb_print_all_deadlocks | ON |
+----------------------------+-------+
1 row in set (0.01 sec)
-
mysql 服务重启后,就off 了.......
-
/etc/my.cnf 文件中修改或增加配置,注意增加的位置[mysqld] 的下面,否则无效;
innodb_print_all_deadlocks = ON
相信坚持的力量,日复一日的习惯.