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

7 votes152 views1 answer
Mysql load data infile csv
SQL
0 vote191 views2 answers
Which MySQL statement is used to delete data from a database
SQL
-1 vote135 views2 answers
On delete set default sql server
SQL
6 votes189 views4 answers
Mysql group by date
SQL
-1 vote191 views5 answers
Convert sql to linq query online
SQL
0 vote205 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
11 votes187 views1 answer
Creating tables in sql with python
SQL
0 vote188 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
2 votes180 views1 answer
Mariadb JSON_EXTRACT
SQL
11 votes178 views5 answers
How to install sqlite3 python
SQL