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)

sql 命令开启 innodb_print_all_deadlocks ，日志记录死锁