mtop.sh - mysql top

mtop

#!/bin/bash
if [ ! -z $1 ]; then
 export MTOPU="-uroot"
 export MTOPPW="-p$1"
fi
if [ -f /root/.my.cnf  ]; then
        MTOPU=' '
        MTOPPW=' '
fi
if [ -z $MTOPU  ] && [ -z $MTOPPW] && [ $MTOPU != ' ' ];  then
 echo "User/Password!!"
 read -p 'user:' us
 read -s -p 'pw:' pw
 export MTOPU="-u${us}"
 export MTOPPW="-p${pw}"
# exit;
fi
clear;
watch "top -b | head; mysqladmin -u $MTOPU -p$MTOPPW status;echo; mysqladmin $MTOPU $MTOPPW processlist | head -20"

exit;