show OPEN TABLES where In_use > 0;
show processlist
kill id
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
kill 线程ID
例子:
查出死锁进程:SHOW PROCESSLIST
其它关于查看死锁的命令:
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;