SELECT * FROM information_schema.processlist WHERE DB LIKE ‘%数据库名%’ and INFO LIKE '%your_table%;
KILL 55848;
方法二:
https://blog.csdn.net/ningjiebing/article/details/89411065
mysql查看是否锁表
于 2019-08-15 17:18:57 首次发布
SELECT * FROM information_schema.processlist WHERE DB LIKE ‘%数据库名%’ and INFO LIKE '%your_table%;
KILL 55848;
方法二:
https://blog.csdn.net/ningjiebing/article/details/89411065