查询进程MySQL进程ID

select `USER`, DB, concat('KILL ',id,';') from information_schema.processlist WHERE TIME > 100
原文地址:https://www.cnblogs.com/cheyunhua/p/13329910.html