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

2 votes145 views1 answer
Use cases condition in sql query laravel
SQL
1 vote127 views1 answer
Create sample data postgresql
SQL
0 vote137 views1 answer
Drop all procedures sql server
SQL
0 vote312 views1 answer
Sql datum formatieren
SQL
0 vote129 views1 answer
Sql server udf performance
SQL
0 vote133 views1 answer
Mysql url
SQL
0 vote188 views1 answer
TSQL Find csv file in folder
SQL
21 votes101 views7 answers
Table drop if exist sql server
SQL
0 vote132 views1 answer
Kill a pid redshift
SQL
0 vote139 views1 answer
How to tell if i have lactose intolerance
SQL