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 vote219 views1 answer
Dump only schema
SQL
3 votes279 views2 answers
Synonym oracle
SQL
0 vote226 views1 answer
Sql describe
SQL
0 vote224 views1 answer
Postgres select except
SQL
2 votes238 views1 answer
Find all triggers in database
SQL
0 vote265 views1 answer
How to create notes in mysql
SQL
0 vote238 views2 answers
Create fulltext index mysql
SQL
0 vote231 views1 answer
Oracle job session
SQL
0 vote239 views1 answer
Drop index in sql
SQL
4 votes227 views1 answer
Oracle change nls_date_format permanently
SQL