echo "show variables like 'max_connections';" |$MYSQL$@ | perl -p -e 's/\s+(\w+)/="$1"/g' >> $VAR_LOG
#echo "$mysql_status"
}
function check_mysql_con_results(){
#echo "$max_connections,$Threads_connected"
Residue_conn=$(($max_connections-$Threads_connected))
#echo $Residue_conn
if [ $max_connections -lt 1000 ];then
if [ $Residue_conn -lt 50 ] ;then
code=2
else
code=1
fi
else
code=0
fi
}
if [ $# -le 0 ] || [ "$1" == "-h" ];then
usage
code=0
check_mysql_status $2
check_mysql_con_status $2
. $VAR_LOG
Residue_conn=$max_connections
check_mysql_con_results $2
PER_SECOND_QUESTION=`echo "$Uptime $Queries" | awk '{printf ("%4.3f") ,$2/$1}END{if($2/$1<0.05) exit 0 ;else exit 1;}'`
tmp_code=$
#
if [ -z $Uptime ];then
echo "$MYSQL $@ Connect Failed,Please check!" && exit 2
fi
#
printf "Uptime:$Uptime Threads_connected:$Threads_connected Max_connections:$max_connections Residue_connectios:$Residue_conn Open_tables:$Open_tables Queries per second avg:%s|Threads=$Threads_running Questions=$Questions Slowqueries=$Slow_queries Opens=$Opened_tables Opentables=$Open_tables Queriespersecondavg=%s" $PER_SECOND_QUESTION $PER_SECOND_QUESTION
#
exit $code
相关阅读：