1.安装依赖包
yum -y install make automake libtool pkgconfig libaio-devel vim-common mysql-devel
2.下载sysbench
#201908
wget https://src.fedoraproject.org/repo/pkgs/sysbench/sysbench-1.0.17.tar.gz/sha512/95a6bb7ec9b0fb111bf2844e110b8fb51c006fd68b5bac75c1b80e2ed18e839d6f07f79d55fb5adef67b41d00f67bbf659d129d1cb593d4fd118092b15431815/sysbench-1.0.17.tar.gz
3.解压和编译安装
tar -zxvf sysbench-1.0.17.tar.gz
cd sysbench-1.0.17
./autogen.sh
./configure
make
make install
sysbench --help
4.Lua安装
#依赖包
yum install readline-devel -y
wget https://www.lua.org/ftp/lua-5.3.5.tar.gz
tar -zxvf lua-5.3.5.tar.gz
cd lua-5.3.5
make linux
make install
5.mysql事务压测
#准备
sysbench /app/sysbench-1.0.17/src/lua/oltp_read_write.lua --time=180 --mysql-host=192.168.92.201 --mysql-port=3306 --mysql-user=root --mysql-password=密码 --mysql-db=test --table-size=50000 --tables=15 --threads=8 prepare
#运行
sysbench /app/sysbench-1.0.17/src/lua/oltp_read_write.lua --time=180 --mysql-host=192.168.92.201 --mysql-port=3306 --mysql-user=root --mysql-password=密码 --mysql-db=test --table-size=50000 --tables=15 --threads=8 run
SQL statistics:
queries performed:
read: 2462950
write: 703700
other: 351850
total: 3518500
transactions: 175925 (977.29 per sec.)
queries: 3518500 (19545.75 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)General statistics:
total time: 180.0120s
total number of events: 175925Latency (ms):
min: 3.34
avg: 8.18
max: 324.89
95th percentile: 10.09
sum: 1439786.21Threads fairness:
events (avg/stddev): 21990.6250/425.56
execution time (avg/stddev): 179.9733/0.00