【数据库功能测试】buffer命中率

buffer命中率

disk_count=$($bin -h$ip -P$port -u$user -p$MYSQL_PWD -S$sock -e "show status like 'Innodb_buffer_pool_reads';"|awk 'NR==2{print $2}')
#echo $disk_count

total_count=$($bin -h$ip -P$port -u$user -p$MYSQL_PWD -S$sock -e "show status like 'Innodb_buffer_pool_read_requests';"|awk 'NR==2{print $2}')
#echo $total_count

export disk_rate=$(echo "scale=2; $disk_count/$total_count"|bc |awk '{printf "%.2f", $0}')
export buffer_rate=$(echo "scale=2; 1-$disk_rate"|bc |awk '{printf "%.2f", $0}')
echo $buffer_rate