Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- # Credentials for a MySQL user with PROCESS, SUPER permissions
- USERNAME=
- PASSWORD=
- # MySQL Server location
- HOST=127.0.0.1
- 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 1,2,6 | awk '{ if ($3 > $TIMEOUT && $2 == $TARGET_USER) print "KILL " $1 ";" }'
Add Comment
Please, Sign In to add comment