显示是否打开死锁检查进程 MySql8默认是打开死锁检测进程的 show variables like ‘innodb_deadlock_detect’ 关闭死锁检测进程 set global innodb_deadlock_detect = off 查看锁等待超时时间(默认是50秒) show variables like ‘innodb_lock_wait_timeout’ 显示进程状态 show processlist; 杀掉死锁锁定的进程 kill thread_id;