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 votes271 views1 answer
Sql string_agg
SQL
0 vote294 views1 answer
Get last inserted primary key
SQL
0 vote268 views1 answer
To Create directory
SQL
2 votes244 views1 answer
Insert from table tsql
SQL
0 vote288 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote250 views1 answer
How to connect postgresql database with java
SQL
1 vote260 views1 answer
Sql server datetime vs datetime2
SQL
0 vote259 views1 answer
Mysql export search results
SQL
1 vote265 views2 answers
Copy database mysql
SQL
5 votes228 views1 answer
Mongodb vs
SQL