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

7 votes158 views2 answers
Get database size mysql
SQL
0 vote183 views1 answer
Mssql last day of month
SQL
0 vote149 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote147 views1 answer
Alter table column size oracle
SQL
3 votes177 views3 answers
1396(hy00) mysql error
SQL
0 vote159 views3 answers
How to run sql query
SQL
0 vote164 views1 answer
Access mysql database docker container shell
SQL
1 vote187 views1 answer
Mysql return text after a final full stop
SQL
0 vote146 views1 answer
Fetch second word from a string in ms sql
SQL
1 vote184 views1 answer
Encrypt password postgresql
SQL