mysqluptime=$(/usr/local/mysql/bin/mysqladmin -uzabbix -pzabbix status|awk '{print $2}')
mysqlquery=$(/usr/local/mysql/bin/mysqladmin -uzabbix -pzabbix status|awk '{print $6}')
time_old=$(cat /usr/local/zabbix/sbin/mysql_uptime)
query_old=$(cat /usr/local/zabbix/sbin//mysql_qps)
if (($((${mysqluptime}-${time_old}))!=0)) ;then
echo $(($((${mysqlquery}-${query_old}))/$((${mysqluptime}-${time_old}))))
else
echo 1
fi
echo $mysqlquery >mysql_qps
echo $mysqluptime > mysql_uptime
注意的是:QPS=query变化量/uptime的变化量
mysql_uptime和mysql_qps存放着前段某个时间的query数目、uptime时间、