🐞 线程锁导致更新失败 mysql, Lock wait timeout exceeded; try restarting
查看所有进程描述(推荐Navicat Query执行)
show processlist;
【单个】kill 线程号 id,时间长的,全干掉(排除event),看心情删
【批量】
-- show processlist;
SELECT
concat( 'KILL ', id, ';' )
FROM
information_schema.PROCESSLIST
WHERE
time > 500
AND USER = 'root';
复制列表拼接的SQL 语句,执行即可
KILL 2176;
KILL 2184;
KILL 2177;
KILL 2185;
KILL 2169;
KILL 2178;
KILL 2170;
KILL 2186;
KILL 2171;
KILL 2172;