mysql-monitor.sh

#!/bin/bash

args=$@

log_off() {
    mysql $args <<<"SET GLOBAL general_log = 'OFF'"
    echo 'set general_log off'
}

trap log_off SIGINT

log_file=`mysql $args <<<"SHOW VARIABLES LIKE 'general_log_file'" | sed -n 2p | cut -f 2`
mysql $args <<<"SET GLOBAL general_log = 'ON'"
echo 'set general_log on'
tail -f $log_file