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

1 vote380 views1 answer
Psql filed name alter
SQL
0 vote347 views2 answers
Reseed sql identity
SQL
0 vote359 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote338 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
-1 vote337 views1 answer
Sql add column bit
SQL
1 vote358 views1 answer
Woocommerce mysql price table
SQL
0 vote425 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote329 views1 answer
Search db for table name
SQL
3 votes331 views1 answer
V$session not found in oracle
SQL
1 vote341 views4 answers
Mysqldump 1 table only
SQL