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 vote279 views1 answer
How to alter length character varying postgres
SQL
0 vote268 views1 answer
Sql server manager close connection
SQL
0 vote271 views1 answer
Drop column from table if exist on live server mysql
SQL
4 votes230 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
1 vote262 views1 answer
Get url of cpanel database hostname
SQL
0 vote293 views1 answer
Sqlite unique multiple columns
SQL
15 votes287 views5 answers
Show tables in oracle
SQL
0 vote285 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote260 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote256 views1 answer
Sql server current time without date
SQL