cechon "1.6 server version is: " red
echo ${sysver}

cechon "1.7 server system kernel version is: " red
echo ${kerver}

cechon "1.8 server Physical memory number is:" red
echo ${phmem}

cechon "1.9 server memory usage rate is: " red
echo ${mem_rate:0:5}%

cechon "1.10 server disk usage is: " red
echo
#disk usage
df -H |awk -F '\t' '{ print $1,$2,$3,$4,$5,$6}'

echo
cechon "1.11 server CPU load average is: " red
echo
uptime | awk 'BEGIN{print "1min, 5min, 15min"} {print $10,$11,$12}'

echo
cechon "1.12 server started services is: " red
echo
chkconfig --list | grep on
echo

echo
cechon "1.13 server CPU free is: " red
top -b -n 1 | grep Cpu | awk '{print $5}' | cut -f 1 -d "."
echo

cechon "1.14 mysql ESTABLISHED connect is: " red
echo
netstat -an -t | grep ":3306" | grep ESTABLISHED | awk '{printf "%s %s\n",$5,$6}' | sort |sed 's/^::ffff://'
echo

cechon "1.15 server ESTABLISHED TCP connect number is: " red
echo
netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a]}'
echo

echo
echo "***********************************************************************"
echo

#2.mysql版本
v_01="select @@version;"
v_02="v02.`date +%Y%m%d%H%M%S`.txt"
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${v_01}" >${v_02}
v_03=`cat ${v_02} | grep -v @@version`
cechon "2.1 mysql runing version is: ${v_03} " red
echo " "
rm -rf ${v_02}
mysql_port=`cat /usr/local/mysql/my.cnf |grep '^port' |sed -n 1p|awk -F= ' {print $2}'`
cechon "2.2 mysql port is: ${mysql_port} " red
echo " "

#3.系统mysql的进程数
mysql_processnum=`ps -ef | grep "mysql" | grep -v "grep" | wc -l`
cechon "3. mysql process number is: ${mysql_processnum} " red
echo " "

#4.客户端连接的mysql进程数

conn_01="conn01.`date +%Y%m%d%H%M%S`.txt"
conn_02="show processlist;"
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${conn_02}" | grep -v Id >${conn_01}
client_conn_num=`cat ${conn_01} |wc -l`
cechon "4. mysql client connect number is: ${client_conn_num} " red
echo " "
rm -rf ${conn_01}

#5.QPS(每秒事务量)

qps_01="show global status like 'Questions';"
qps_re="qpsre.`date +%Y%m%d%H%M%S`.txt"
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${qps_01}" |grep -v Variable_name \
|cut -f 2 >${qps_re}
qps_02=`cat ${qps_re}`
qps_03=`cat /proc/uptime |awk '{print $1}'`
qps_04=`awk 'BEGIN{print '${qps_02}' / '${qps_03}'}'` #shell默认不支持浮点运算
cechon "5. current mysql server QPS is: ${qps_04:0:5} " red
echo " "
rm -rf ${qps_re}

#6.TPS(每秒事务量)
tps_01="show status where Variable_name in('Com_commit'); "
tps_02="show status where Variable_name in('Com_rollback'); "
tps_re01="tpsre01.`date +%Y%m%d%H%M%S`.txt"
tps_re02="tpsre02.`date +%Y%m%d%H%M%S`.txt"
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${tps_01}" |grep -v Variable_name \
|cut -f 2 >${tps_re01}
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${tps_02}" |grep -v Variable_name \
|cut -f 2 >${tps_re02}
tps_03=`cat ${tps_re01}`
tps_04=`cat ${tps_re02}`
tps_sum=`awk 'BEGIN{print '${tps_03}' + '${tps_04}'}'` #shell默认不支持浮点运算
tps_uptime=`cat /proc/uptime |awk '{print $1}'`
tps_avg=`awk 'BEGIN{print '${tps_sum}' / '${tps_uptime}'}'` #shell默认不支持浮点运算
cechon "6. current mysql server TPS is: ${tps_avg} " red
echo " "
rm -rf ${tps_re01}
rm -rf ${tps_re02}

#7.key Buffer 命中率

#key_buffer_read_hits = (1-key_reads / key_read_requests) * 100%