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 vote235 views1 answer
Mysql select statement after index
SQL
8 votes219 views2 answers
Mysql query dates between two dates
SQL
13 votes175 views2 answers
Oracle all source
SQL
0 vote228 views1 answer
How to check the port of mysql installation in mac
SQL
3 votes251 views3 answers
Update con select postgresql
SQL
1 vote228 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
5 votes226 views1 answer
Oracle asynchronous update
SQL
2 votes233 views3 answers
Mysql list tables by size
SQL
5 votes228 views3 answers
Oracle list columns in schema
SQL
0 vote219 views1 answer
Can we rollback data that are deleted using DELETE
SQL