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 vote331 views1 answer
Change database name psql 8
SQL
0 vote321 views1 answer
Drop procedure sql
SQL
1 vote331 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote310 views1 answer
Mssql check if date is greater than today
SQL
0 vote307 views1 answer
Postgresql alter column nullable
SQL
0 vote307 views1 answer
Update using case in mysql
SQL
12 votes353 views6 answers
Distinct in sql server
SQL
17 votes310 views3 answers
How to change a collumn name in sql
SQL
11 votes361 views1 answer
Oracle insert from select
SQL
9 votes326 views6 answers
Check constraint in sql
SQL