/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 vote405 views1 answer
Oracle simple quote
SQL
10 votes351 views2 answers
Tsql merge example
SQL
-1 vote380 views1 answer
Difference berween database and data base management system
SQL
3 votes359 views4 answers
Truncate syntax in sql
SQL
0 vote320 views1 answer
Sql change date format
SQL
0 vote318 views2 answers
How to update the multiple rows in sql
SQL
5 votes314 views1 answer
Oracle find foreign key dependencies
SQL
0 vote318 views1 answer
Query on date sqlite flutter
SQL
0 vote346 views1 answer
Procedure excute monthly oracle
SQL
0 vote307 views1 answer
Oracle sqlp update amount / quantity
SQL

Share