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 votes341 views2 answers
Mysql default value
SQL
0 vote331 views1 answer
Postgres copy command
SQL
5 votes347 views1 answer
How to get all dates in a month in oracle
SQL
0 vote328 views1 answer
Bash block size ls /var/lib/mysql
SQL
1 vote343 views2 answers
Postgres copy table from one schema to another
SQL
0 vote350 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote319 views1 answer
Stop psql server windows
SQL
0 vote324 views1 answer
Count the table indatabase
SQL
0 vote331 views1 answer
How to change the field size of an existing column
SQL
0 vote333 views2 answers
Postgresql get last day of month
SQL