show variables like "%innodb_print_all_deadlocks%";
开启记录死锁
set global innodb_print_all_deadlocks=1
重启mysql后会失效
查看死锁
show engine innodb status;
=====================================
查看慢查询日志：
mysqldumpslow -s -t 10 slow.log
原文：https://www.cnblogs.com/yyxx8888/p/10374842.html