Mysql kill

Bulk kill mysql processlist

SELECT CONCAT('KILL ',id,';') AS IDs
FROM information_schema.processlist 
WHERE TIME >10
AND command = "sleep"

Source: stackoverflow.com

Mysql kill

mysql> SELECT GROUP_CONCAT(CONCAT('KILL ',id,';') SEPARATOR ' ') 
 
FROM information_schema.processlist WHERE user <> 'system user';

Source: scaledynamix.com

Mysql kill

-- 查询执行时间超过2分钟的线程，然后拼接成 kill 语句
select concat('kill ', id, ';')
from information_schema.processlist
where command != 'Sleep'
and time > 2*60
order by time desc

Source: cnblogs.com

Similar codes

1 vote133 views1 answer
Sql auto date
SQL
0 vote151 views1 answer
Get cpu details sql
SQL
3 votes192 views2 answers
Oracle sql first day of month
SQL
0 vote181 views1 answer
Sql query to select even numbers
SQL
0 vote136 views1 answer
Mysql grant all on all databases
SQL
1 vote152 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote174 views1 answer
Create table with timestamp mysql youtube
SQL
3 votes184 views1 answer
Dbms_scheduler drop_job
SQL
0 vote150 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote147 views1 answer
Drop all triggers oracle
SQL