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

0 vote183 views1 answer
How to get first 10 records of a table in mysql
SQL
1 vote192 views1 answer
Mysql find tables with column name
SQL
0 vote189 views1 answer
Oracle db timestamp auto add
SQL
0 vote174 views1 answer
Login failed for login due to trigger execution
SQL
4 votes162 views3 answers
Oracle sql first day of quarter
SQL
1 vote181 views1 answer
Select count distinct multiple columns sql server
SQL
-1 vote165 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
1 vote173 views1 answer
Mariadb case switch
SQL
1 vote156 views5 answers
Spring boot sql logging
SQL
1 vote136 views1 answer
Mysql show attributes of a table
SQL