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

3 votes164 views1 answer
Oracle apex message quit website
SQL
2 votes149 views1 answer
Mysql last 7 days including today
SQL
0 vote150 views1 answer
Sql drop procedure if exists
SQL
20 votes152 views2 answers
Mysql bigint max value
SQL
6 votes242 views1 answer
Sql insert values into table
SQL
46 votes224 views4 answers
Create column sql
SQL
16 votes167 views1 answer
Mssql int max value
SQL
4 votes146 views2 answers
How to delete row in sql
SQL
0 vote147 views1 answer
Run mssql server terminal
SQL
0 vote174 views1 answer
How to print sql query
SQL