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

0 vote215 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote266 views1 answer
How to use sqlcommand
SQL
0 vote212 views3 answers
Group_concat sql server
SQL
0 vote226 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote243 views1 answer
Implode in sql query
SQL
4 votes218 views3 answers
How to describe a table in sqlite3
SQL
2 votes225 views1 answer
Add new column not null sql server
SQL
0 vote206 views1 answer
Convert sql server guid to varbinary
SQL
1 vote216 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote295 views2 answers
Mysql insert rows to another database
SQL