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 vote297 views1 answer
Sub query in linq
SQL
0 vote327 views1 answer
Sql change primary key to composite key
SQL
6 votes304 views4 answers
How to remove unique key in mysql
SQL
0 vote309 views1 answer
Check if string is a number sql
SQL
2 votes326 views1 answer
Mysql trigger after update
SQL
4 votes387 views1 answer
How to check last gather stats on table in oracle
SQL
-1 vote267 views1 answer
Oracle db list usernames
SQL
0 vote322 views1 answer
SQL column name Oracle
SQL
0 vote291 views1 answer
Mysql database is not starting in xampp
SQL
0 vote288 views1 answer
Sqlalchemy.exc.OperationalError:
SQL