-- 查看进程,删除trx_state=LOCK的进程 select * from information_schema.innodb_trx; kill trx_id; -- 删除耗时较长的线程 SELECT * from information_schema.`PROCESSLIST` WHERE Time > 1000 AND USER = 'root' ORDER BY TIME desc; kill id;
-- 查看进程,删除trx_state=LOCK的进程 select * from information_schema.innodb_trx; kill trx_id; -- 删除耗时较长的线程 SELECT * from information_schema.`PROCESSLIST` WHERE Time > 1000 AND USER = 'root' ORDER BY TIME desc; kill id;