https://blog.csdn.net/ZBylant/article/details/81940892
https://www.cnblogs.com/jpfss/p/9203679.html
1、查询是否锁表 show OPEN TABLES where In_use > 0;
2、查询进程
show processlist 查询到相对应的进程===然后 kill id
补充：
查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
https://blog.csdn.net/dc_726/article/details/8576151/
https://blog.csdn.net/chengmeng_123/article/details/78641743
