mysql mtop by bash

#!/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; 

	#!/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;

view raw mtop hosted with ❤ by GitHub