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

17 votes208 views6 answers
Current date in sql
SQL
65 votes337 views6 answers
Sql add column to table
SQL
0 vote201 views1 answer
Oracle create table auto generated primary key
SQL
0 vote202 views1 answer
Nueva tabla mysql
SQL
11 votes207 views2 answers
Insert current date sql
SQL
10 votes213 views4 answers
Mysql if else
SQL
0 vote242 views1 answer
Wordpress make wp user in db
SQL
31 votes197 views3 answers
Sql count
SQL
3 votes345 views9 answers
Linq to sql converter online
SQL
0 vote207 views1 answer
Plsql check for string in numeric
SQL