show OPEN TABLES where In_use > 0;
show processlist
查询到相对应的进程===然后 kill id
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
mysql 查询表死锁 和结束死锁的表步骤
原文：http://www.cnblogs.com/tl542475736/p/5541396.html
