Kill long running MySQL queries (in AWS RDS)

kill-long-running-mysql-queries-in-rds.sh

#!/bin/bash

MYSQL="mysql --defaults-extra-file=/path/to/something.cnf"

# Find queries which have been running for longer than 1800 seconds.
for PID in $($MYSQL -BNe "SELECT id  FROM information_schema.processlist WHERE command <> 'Sleep' AND info NOT LIKE '%PROCESSLIST%' AND command <> 'Killed' AND time > 1800" )
do

    #OUTPUT=$($MYSQL -NBe "SELECT id,time,command,info FROM information_schema.processlist WHERE id = $PID ")
    #echo "Long running query output - $OUTPUT "

    # In AWS RDS :
	$MYSQL -e "call mysql.rds_kill($PID)" 

    # For normal MySQL :
    # $MYSQL -e "kill $PID"
done

Thank you!