Oracle Linux 8.10 编译安装sysbench

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]# lsbulk_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