查看所有被锁表的进程
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
找到进程号,即 trx_mysql_thread_id
SELECT trx_mysql_thread_id FROM INFORMATION_SCHEMA.INNODB_TRX;
然后执行
kill 进程号;
查看所有被锁表的进程
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
找到进程号,即 trx_mysql_thread_id
SELECT trx_mysql_thread_id FROM INFORMATION_SCHEMA.INNODB_TRX;
然后执行
kill 进程号;