?
msyql TPS v1:计算指定时间内(三)
e051="tpsre051.`date +%Y%m%d%H%M%S`.txt"
tps_re052="tpsre052.`date +%Y%m%d%H%M%S`.txt"
tps_re053="tpsre053.`date +%Y%m%d%H%M%S`.txt"
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${tps_051}" |grep -v Variable_name \
|cut -f 2 >${tps_re051}
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${tps_052}" |grep -v Variable_name \
|cut -f 2 >${tps_re052}
mysql -h${MYSQL_HOST} -u${MYSQL_USER} -p${MYSQL_PASS} -e"${tps_053}" |grep -v Variable_name \
|cut -f 2 >${tps_re053}
tps_051_re=`cat ${tps_re051}`
tps_052_re=`cat ${tps_re052}`
tps_053_re=`cat ${tps_re053}`
tps_sum_new=`awk 'BEGIN{print '${tps_051_re}' + '${tps_052_re}' + '${tps_053_re}' }'`
#获取上一次的值(见TPS-JOB)
tps_everydat_9="/root/tps_everydat_9.`date +%Y%m%d`.txt"
tps_sum_old=`cat ${tps_everydat_9}`
tps_sum_diff=`awk 'BEGIN{print '${tps_sum_new}' - '${tps_sum_old}' }' `
#获取时间差
last_exec_time="/root/tps_lastime.`date +%Y%m%d`.txt"
t02=`cat ${last_exec_time}`
start_time=`date +%s -d "$t02"`
end_time=`date +%s `
#echo $(($end_time-$start_time))
tps_uptime_gf=`awk 'BEGIN{ print '$end_time'-'$start_time'}'`
#计算早上9点到现在的TPS
tps_avg=`awk 'BEGIN{print '${tps_sum_diff}' / '${tps_uptime_gf}'}'|awk '{printf("%.f\n",$1)}'` #shell默认不支持浮点运算
cechon "From $t02 to now ,TPS: ${tps_avg} " red
echo " "
tps_01_re=`cat ${tps_re051}`
tps_02_re=`cat ${tps_re052}`
tps_03_re=`cat ${tps_re053}`
echo
rm -rf ${tps_re051}
rm -rf ${tps_re052}
rm -rf ${tps_re053}