/SQL/Bulk kill mysql processlist

Bulk kill mysql processlist

Kill mysql processlist in whose time more than 200

mysql> select group_concat(concat('KILL ',id,';')) from 
information_schema.processlist where user='root' and time > 500;

mysql> source /tmp/a.txt;

3

Source: stackoverflow.com

Bulk kill mysql processlist

SELECT CONCAT('KILL ',id,';') AS IDs
FROM information_schema.processlist 
WHERE TIME >10
AND command = "sleep"

1

Source: stackoverflow.com

Similar codes

0 vote252 views1 answer
Mysql select random rows large table
SQL
2 votes211 views1 answer
Datefromparts mssql
SQL
11 votes303 views2 answers
Import mysql dump command line windows
SQL
0 vote201 views1 answer
Openquery update linked server
SQL
-3 votes158 views1 answer
Remove spaces sql 2008
SQL
5 votes159 views1 answer
How to check nls timestamp format in oracle
SQL
4 votes164 views1 answer
SQL order random
SQL
1 vote185 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
3 votes179 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote289 views1 answer
Mysql update all record removing 2 hours from column
SQL

Share