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 vote366 views1 answer
Sql query to find duplicate email address
SQL
1 vote370 views1 answer
Oracle sequence last_number
SQL
1 vote332 views1 answer
Stored procedure return value
SQL
0 vote413 views1 answer
Sql statement show all emails with dome
SQL
3 votes433 views1 answer
Where id is in list sql
SQL
0 vote362 views1 answer
Firebird where
SQL
2 votes385 views5 answers
Install postgresql 10 centos 7
SQL
0 vote461 views1 answer
Compare strings lexicographically in sql
SQL
0 vote341 views1 answer
How to count with except in psql
SQL
24 votes352 views2 answers
Alter table delete column
SQL