Mysql死锁监控排查

死锁监控

查看最后一个死锁
show engine innodb status\G;

查看有没有开启innodb_print_all_deadlocks
show variables like "%deadlock%";

开启打印死锁到错误日志的参数
vim /etc/my.cnf
innodb_print_all_deadlocks = 1   # 把死锁信息写入错误日志