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 vote225 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote193 views1 answer
Sql change date format
SQL
0 vote203 views1 answer
Sqlserver now
SQL
0 vote192 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
4 votes145 views1 answer
Generate class from sql table c#
SQL
0 vote210 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote228 views1 answer
Sql alter table order by
SQL
0 vote225 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote242 views3 answers
Call to undefined function mysql_connect()
SQL
42 votes267 views6 answers
Install beautifulsoup
SQL