sysbench 压测

sysbench安装

（1）下载解压
wget https://github.com/akopytov/sysbench/archive/1.0.zip -O "sysbench-1.0.zip"
unzip sysbench-1.0.zip
cd sysbench-1.0

（2）安装依赖
yum install automake libtool –y

（3）安装
安装之前，确保位于之前解压的sysbench目录中。

./autogen.sh
./configure
export LD_LIBRARY_PATH=/usr/include/mysql
#whereis mysql 如果找不到mysql/include,则是没有安装mysql-community-devel-5.7.38-1.el7.x86_64.rpm包，需安装此包
make
make install

sysbench --version

create database sbtest;

sysbench ./tests/include/oltp_legacy/oltp.lua  --mysql-socket=/mysql/data/mysql.sock  --mysql-port=3306 --mysql-user=root --mysql-password=123456 --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=10 --time=120 --report-interval=10 prepare

vi /home/test/mysysbench.log

sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-socket=/mysql/data/mysql.sock  --mysql-port=3306 --mysql-user=root --mysql-password=123456 --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=10 --time=120 --report-interval=10 run >> /home/test/mysysbench.log

sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-socket=/mysql/data/mysql.sock  --mysql-port=3306 --mysql-user=root --mysql-password=123456 cleanup