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 vote211 views2 answers
Sql server concat string and int
SQL
4 votes201 views2 answers
How to count items with same name in sql
SQL
0 vote202 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote219 views1 answer
How to move a column to different spot mysql
SQL
0 vote219 views3 answers
Postgres date difference seconds
SQL
0 vote209 views1 answer
Get last date join sql
SQL
11 votes310 views5 answers
Update table from another table mysql
SQL
0 vote187 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote204 views1 answer
Sql how to get courses that i have made prerequisites
SQL
0 vote204 views1 answer
Mysql export search results
SQL