/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 vote142 views1 answer
Do postgresql
SQL
1 vote169 views2 answers
End mysql command
SQL
13 votes147 views2 answers
Oracle select into and inner join
SQL
0 vote156 views1 answer
Oracle list partitions
SQL
3 votes181 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote221 views1 answer
Sql to search who modified
SQL
60 votes369 views6 answers
Add column in sql
SQL
0 vote139 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote147 views1 answer
Oracle right characters
SQL
0 vote143 views1 answer
Monthly Birthday SQL Query
SQL

Share