批量KILL MYSQL数据库进程

1. 查询进程

SELECT
    *
FROM
    information_schema.`PROCESSLIST`
WHERE
    info IS NOT NULL
ORDER BY TIME DESC;

2. kill单个进程

kill id;

3. 批量kill

select 
    concat('KILL ',id,';') 
from 
    information_schema.processlist 
where 
    user='user_nasme' 
    and info is not null ;

复制查询结果并执行