1.首先下载sysbench二进制包
[root@mysql8_3 software]# wget https://github.com/akopytov/sysbench/archive/refs/heads/master.zip
--2025-04-24 16:14:25-- https://github.com/akopytov/sysbench/archive/refs/heads/master.zip
正在解析主机 github.com (github.com)... 20.205.243.166
正在连接 github.com (github.com)|20.205.243.166|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 302 Found
位置：https://codeload.github.com/akopytov/sysbench/zip/refs/heads/master [跟随至新的 URL]
--2025-04-24 16:14:29-- https://codeload.github.com/akopytov/sysbench/zip/refs/heads/master
正在解析主机codeload.github.com (codeload.github.com)... 20.205.243.165
正在连接codeload.github.com (codeload.github.com)|20.205.243.165|:443... 已连接。
已发出 HTTP 请求，正在等待回应... 200 OK
长度：未指定[application/zip]
正在保存至: “master.zip”
master.zip[ <=> ] 2.23M 68.6KB/s 用时 38s
2025-04-24 16:15:07 (61.0 KB/s) - “master.zip” 已保存[2343410]
2.重命名并解压
[root@mysql8_3 software]# mv master.zip sysbench.zip
[root@mysql8_3 software]# unzip sysbench.zip
3.安装关联包
[root@mysql8_3 software]# yum -y install make automake libtool pkgconfig libaio-devel
[root@mysql8_3 software]# yum -y install mariadb-devel openssl-devel
4.编译安装
[root@mysql8_3 sysbench-master]# ./autogen.sh
[root@mysql8_3 sysbench-master]# ./configure
[root@mysql8_3 sysbench-master]# make -j
[root@mysql8_3 sysbench-master]# make install
5.最后的安装路径在/usr/local/bin下，默认的脚本在/usr/local/share/sysbench/下
[root@mysql8_3 sysbench-master]# which sysbench
/usr/local/bin/sysbench
[root@mysql8_3 sysbench-master]# ll /usr/local/bin/sysbench
-rwxr-xr-x 1 root root 1652464 4月24 16:23 /usr/local/bin/sysbench
[root@mysql8_3 /]# cd /usr/local/share/sysbench/
[root@mysql8_3 sysbench]# ls
bulk_insert.lua oltp_insert.lua
。。。
6.测试
sysbench --db-driver=mysql --mysql-user=root --mysql-password=123456 --mysql-socket=/tmp/mysql.sock --mysql-db=test --range_size=100 --table_size=10000 --tables=10 --threads=1 --events=0 --time=60 --rand-type=uniform /usr/local/share/sysbench/oltp_read_only.lua prepare/run/cleanup
参考:
https://github.com/akopytov/sysbench?tab=readme-ov-file#rhelcentos
