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

4 votes224 views6 answers
Laravel jwt
SQL
0 vote142 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
2 votes104 views1 answer
Ifnull postgres
SQL
8 votes119 views1 answer
Oracle search source code
SQL
0 vote123 views1 answer
Sql search all columns of database oracle sql
SQL
4 votes143 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote129 views1 answer
Mysql error 1251
SQL
8 votes112 views2 answers
Replace string value in sql
SQL
7 votes132 views1 answer
Sql limit decimal places
SQL
0 vote119 views1 answer
Plpgsql raise notice
SQL