Finding long-running queries in MySQL

query_finder.sql

SELECT id, concat('kill ', id, ';') as kill_command, state, command, time, info
FROM information_schema.processlist
WHERE command <> 'Sleep' 
AND info NOT LIKE '%PROCESSLIST%'
ORDER BY time DESC LIMIT 50;

query_killer.sh

host="octopus-read-1"
password=XXXXXXX
client="mysql -uhousetrip -p${password} --ssl-ca=/var/www/housetrip/shared/config/mysql-ssl-ca-cert.pem -h ${host}.cjumddpb9pgp.eu-west-1.rds.amazonaws.com housetrip_production"
query="SELECT id
  FROM information_schema.processlist
  WHERE command <> 'Sleep'
  AND info NOT LIKE '%PROCESSLIST%'
  AND command <> 'Killed'
  AND info LIKE '%EXPLAIN'"

$client -e "${query}" | \
sed -e 's/[^0-9]//g; s/^/kill /; s/$/;/' | {
  while read LINE ; do
    echo "$LINE"
    echo "$LINE" | $client
  done
}