MySQL锁表解决

#查询是否锁表
show OPEN TABLES where In_use > 0;

#查看所有进程
show processlist

#kill
kill 288607;

#查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;