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 vote182 views1 answer
Events not working db
SQL
0 vote180 views1 answer
SQL loop with cursor
SQL
0 vote207 views1 answer
Tsql pad left
SQL
8 votes198 views10 answers
Sql
SQL
2 votes213 views1 answer
Sql skip the first row
SQL
0 vote208 views1 answer
Mysql persistence.xml
SQL
0 vote184 views1 answer
Ignore case in string sql
SQL
0 vote234 views1 answer
Download mysql database to excel in android studio
SQL
0 vote231 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote180 views1 answer
Connexion mysql
SQL