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

1 vote190 views1 answer
Tsql find foreign key references
SQL
0 vote201 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote187 views1 answer
T-SQL Retry (deadlock)
SQL
12 votes176 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote185 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote205 views1 answer
How to define a non primary composite key in sql
SQL
0 vote189 views1 answer
Oracle synonym procedure dblink
SQL
1 vote186 views1 answer
Oracle add proxy
SQL
-1 vote183 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
19 votes231 views1 answer
Sqrt(-1)
SQL