查看mysql中已建立了哪些连接:
SHOW FULL PROCESSLIST ;
根据某些条件获取要关闭的 Session ID:
SELECT CONCAT('KILL ',id,';') FROM information_schema.processlist WHERE USER='root'
AND STATE='Waiting for table metadata lock' AND HOST LIKE CONCAT('localhost:53','%')
AND DB = 'tms'
这里我筛选的条件是:操作用户为
root
,该连接状态为Waiting for table metadata lock
,IP为localhost
,且端口号为53开头
,操作数据库为tms
将查询结果复制出来单独执行:
KILL 56;
KILL 57;
KILL 58;
KILL 51;
KILL 59;
KILL 52;
KILL 60;
KILL 53;
KILL 54;
KILL 55;
搞定: