v1.1.0-beta-2

What's Changed

• 支持Oracle by @wuwen5 in #1

Oracle客户端下载地址

https://www.oracle.com/database/technologies/instant-client/downloads.html

使用RPM安装方式，将以下RPM上传到服务器:

• oracle-instantclient19.22-basic-19.22.0.0.0-1.x86_64.rpm
• oracle-instantclient19.22-devel-19.22.0.0.0-1.x86_64.rpm

yum -y localinstall oracle-instantclient19.22-basic-19.22.0.0.0-1.x86_64.rpm
yum -y localinstall oracle-instantclient19.22-devel-19.22.0.0.0-1.x86_64.rpm

使用zip 安装方式

unzip instantclient-basic-linux.x64-19.22.0.0.0dbru.zip
unzip instantclient-sdk-linux.x64-19.22.0.0.0dbru.zip

echo "/root/instantclient_19_22" > /etc/ld.so.conf.d/oracle-instantclient.conf
ldconfig

编译&安装 Sysbench

./autogen.sh
# 使用--with-oracle 支持oracle， 通过--with-oracle-includes --with-oracle-libs指定Oracle客户端路径 (如未安装mysql客户端驱动,可--without-mysql排除默认的mysql支持)
# --with-oracle-libs=lib路径，如rpm安装方式，可指定为/usr/lib/oracle/19.22/client64/lib
# --with-oracle-includes=include路径，如rpm安装方式，可指定为/usr/include/oracle/19.22/client64
./configure --with-oracle --with-oracle-libs=/root/instantclient_19_22 --with-oracle-includes=/root/instantclient_19_22/sdk/include --without-mysql
make -j
make install

New Contributors

• @wuwen5 made their first contribution in #1

Full Changelog: v1.1.0-beta-1...v1.1.0-beta-2

v1.1.0-beta-1

• 支持达梦驱动

Sysbench(达梦)安装示例 CentOS

• 达梦客户端必要文件(如编译本机未安装达梦，可从已安装机器中拷入以下必要文件到相应目录)

# /opt/dmdbms
├── bin
│   └── libcrypto.so
└── include
    ├── DCI.h
    ├── DPIext.h
    ├── DPI.h
    ├── DPItypes.h
    ├── libdmdci.a
    └── libdmdpi.a

• 编译安装

export LDFLAGS=-lrt
export DM_HOME=/opt/dmdbms
./autogen.sh
#如未安装mysql-dev或不需要支持mysql,可增加 --without-mysql
./configure --with-dm --with-dm-includes=/opt/dmdbms/include --without-mysql
make -j
make install

测试示例

sysbench oltp_point_select --tables=1 --table-size=1 --db-driver=dm --dm-db=192.168.x.x:5237 --dm-user=SYSDBA --dm-password=SYSDBA --threads=16 --time=10 --report-interval=10 prepare

Full Changelog: https://github.com/wuwen5/sysbench/commits/v1.1.0-beta-1