#!/bin/bash
Uptime=`mysqladmin status -uroot -p111111| awk '{print $2}'`
QPS() {
mysqladmin status -uroot -p111111|awk '{print $NF}'
}
#TPS
TPS() {
rollback=`mysqladmin extended-status -u root -p111111|grep Com_rollback|grep -v to|awk '{print $4}'`
commit=`mysqladmin extended-status -u root -p111111|grep Com_commit|grep -v to|awk '{print $4}'`
#echo $rollback
#echo $commit
e1=`expr $rollback + $commit`
#echo $e1
#echo $Uptime
A=`echo "scale=2; $e1/$Uptime" | bc`
echo $A
}
$1
运行脚本
sh mysql_qps_tps.sh QPS
或者
sh mysql_qps_tps.sh TPS