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

3 votes128 views2 answers
Oracle synonym
SQL
0 vote137 views1 answer
My sql data file extention
SQL
0 vote122 views1 answer
Knex last insert id mysql
SQL
0 vote148 views1 answer
Mysql row generator
SQL
15 votes138 views3 answers
Mysql update add to existing value
SQL
0 vote139 views1 answer
Implicit inner join table alias with id values
SQL
1 vote134 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote205 views1 answer
Sql select max value for each group
SQL
3 votes161 views1 answer
Apex set debug level
SQL
-1 vote147 views2 answers
Full join sql
SQL