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 votes316 views2 answers
Postgresql get table names
SQL
0 vote299 views2 answers
Oracle create tablespace autoextend
SQL
2 votes333 views1 answer
How to check if a row is null in sql
SQL
0 vote267 views1 answer
Database springboot
SQL
2 votes301 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes274 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote274 views1 answer
Mysql show foreign keys column
SQL
1 vote288 views1 answer
Get parameter value in mysql trigger
SQL
0 vote289 views1 answer
Sql bild in function
SQL
1 vote323 views1 answer
How to see logical reads in sql server
SQL