bash script to kill process "SELECT & Sleep" at processlist in MySQL.

mysql_kill_process_based_on_ips.sh

#!/bin/bash
#title           : mysql_kill_process_based_on_ips.sh
#description     : bash script to kill process "SELECT & Sleep" at processlist in MySQL.
#author          : Agung Pambudi
#website         : http://agungpambudi.com
#email           : [email protected]
#version         : 0.2
#==============================================================================
#
#                                   _         _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
#| .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
#|__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
#    |___|       |___|_|

DB="database"
HOST="--host=192.168.07.122"
USER="--user=root"
PASSWORD="--password=123"
   
   for i in `mysql $HOST $USER $PASSWORD $DB -e 'select id from information_schema.processlist where COMMAND like "%Sleep%" AND TIME > 3' | sed 's/\(^[0-9]*\).*/\1/'`; do
        echo "Killing sleep - ${i}";
        mysql $HOST $USER $PASSWORD $DB -e "kill ${i}";
   done

   for i in `mysql $HOST $USER $PASSWORD $DB -e 'select id from information_schema.processlist where HOST not like "%192.168.07.08%" AND HOST not like "%192.168.07.12%" AND HOST not like "%192.168.07.50%" AND INFO like "SELECT%"' | sed 's/\(^[0-9]*\).*/\1/'`; do
        echo "Killing query - SELECT - ${i}";
        mysql $HOST $USER $PASSWORD $DB -e "kill ${i}";
   done

   for i in `mysql $HOST $USER $PASSWORD $DB -e 'select id from information_schema.processlist where HOST not like "%192.168.07.08%" AND HOST not like "%192.168.07.12%" AND HOST not like "%192.168.07.50%" AND INFO like "select%"' | sed 's/\(^[0-9]*\).*/\1/'`; do
        echo "Killing query - select - ${i}";
        mysql $HOST $USER $PASSWORD $DB -e "kill ${i}";
   done

   for i in `mysql $HOST $USER $PASSWORD $DB -e 'select id from information_schema.processlist where HOST not like "%192.168.07.08%" AND HOST not like "%192.168.07.12%" AND HOST not like "%192.168.07.50%" AND INFO like "Select%"' | sed 's/\(^[0-9]*\).*/\1/'`; do
        echo "Killing query - Select - ${i}";
        mysql $HOST $USER $PASSWORD $DB -e "kill ${i}";
   done

echo "=========================================="
echo "                    done !                "
echo "=========================================="