测试MySQL ECS 性能指标tps脚本

Demonson

于 2022-07-15 14:55:58 发布

阅读量276

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/demonson/article/details/125804705

版权

vim aa.sh 

#/usr/bin/env bash
OLD_COM_INSERT=`echo "show global status where Variable_name='Com_insert';"|mysql -uroot -proot123 -h127.0.0.1 -N|awk '{print $2}'`
OLD_COM_UPDATE=`echo "show global status where Variable_name='Com_update';"|mysql -uroot -proot123 -h127.0.0.1 -N|awk '{print $2}'`
OLD_COM_DELETE=`echo "show global status where Variable_name='Com_delete';"|mysql -uroot -proot123 -h127.0.0.1 -N|awk '{print $2}'`
sleep $1
NEW_COM_INSERT=`echo "show global status where Variable_name='Com_insert';"|mysql -uroot -proot123 -h127.0.0.1 -N|awk '{print $2}'`
NEW_COM_UPDATE=`echo "show global status where Variable_name='Com_update';"|mysql -uroot -proot123 -h127.0.0.1 -N|awk '{print $2}'`
NEW_COM_DELETE=`echo "show global status where Variable_name='Com_delete';"|mysql -uroot -proot123 -h127.0.0.1 -N|awk '{print $2}'`
echo "(($NEW_COM_INSERT - $OLD_COM_INSERT) + ($NEW_COM_UPDATE - $OLD_COM_UPDATE) + ($NEW_COM_DELETE - $OLD_COM_DELETE)) / $1"|bc