MySQL 死锁解决 CoderSunYu 2019-02-28 352 查看进程列表 SHOW PROCESSLIST 干掉死锁的进程 kill 1490 其它关于查看死锁的命令: 1:查看当前的事务 SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX; 2:查看当前锁定的事务 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 3:查看当前等锁的事务 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;