【mysql】查看/批量kill进程

— 查看进程

show PROCESSLIST

–kill 单个进程

kill ${id}

kill 1827021

— 批量kill进程

select CONCAT(‘KILL ‘,id,’;’) FROM information_schema.`PROCESSLIST` where db = ‘db_name’;

或

SELECT CONCAT(‘KILL ‘,id,’;’) AS command
FROM information_schema.processlist
WHERE `db`=’db_name’