Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

bulk kill mysql processlist

SELECT CONCAT('KILL ',id,';') AS IDs
FROM information_schema.processlist 
WHERE TIME >10
AND command = "sleep"
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #bulk #kill #mysql #processlist
ADD COMMENT
Topic
Name
3+7 =