MySQL解决死锁

显示用户正在运行的线程

SHOW PROCESSLIST 

查看当前的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
查看当前锁定的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
查看当前等锁的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
杀死进程

kill 进程ID