mysql解除锁表

查看下在锁的事务 :SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;

杀死进程id(就是上面命令的trx_mysql_thread_id列):kill 线程ID

原文地址:https://www.cnblogs.com/luizw/p/11529437.html