Kill slow mysql queries

A Shell script for killing slow MySQL queries: #!/bin/sh # Credentials for a MySQL user with PROCESS, SUPER permissions USERNAME= PASSWORD= # MySQL Server location HOST= PORT=3306 TIMEOUT=60 # 1 minute TARGET_USER= # MySQL user to monitor MYSQL=”mysql -u $USERNAME –password=$PASSWORD -h $HOST -P $PORT -B” $MYSQL -N -e ‘SHOW FULL PROCESSLIST’ | cut -f … Read more