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 vote328 views1 answer
Sql count more than 1
SQL
0 vote328 views1 answer
Soql user profile
SQL
0 vote347 views1 answer
Faire une recherche par liste de mot clé sql
SQL
5 votes346 views3 answers
MySql get fields of table
SQL
0 vote386 views1 answer
PostgreSQL types and C# types
SQL
0 vote313 views1 answer
Oracle select invalid views
SQL
0 vote323 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote328 views1 answer
Import big data to mysql
SQL
0 vote322 views1 answer
Select from another database
SQL
0 vote368 views2 answers
Insert data mysql with cmd
SQL