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 vote259 views2 answers
Timing sql queries
SQL
0 vote260 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote262 views1 answer
See Foreign Key
SQL
10 votes256 views4 answers
Mysql one week ago
SQL
-1 vote254 views3 answers
Update mongodb version ubuntu
SQL
0 vote263 views1 answer
Mysql query problems and solutions
SQL
3 votes288 views1 answer
Sql print all names that start with a given letter
SQL
1 vote210 views1 answer
How to run sql script
SQL
0 vote265 views1 answer
Pass array parameter to stored procedure c#
SQL
7 votes286 views1 answer
Oracle pagination query rownum
SQL