/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

5 votes178 views1 answer
Oracle asynchronous procedure
SQL
0 vote100 views1 answer
Postrgres trunc
SQL
2 votes111 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote111 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote108 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote57 views1 answer
Oracle character set
SQL
3 votes111 views3 answers
How to add month in update sql
SQL
0 vote107 views1 answer
Run postgresql dump to csv
SQL
0 vote115 views1 answer
Query params sql insert python f string
SQL
0 vote108 views1 answer
Postgresql create table with boolean column
SQL

Share