麒麟v10 BenchmarkSQL5.1部署

环境

工具版本：benchmarksql-5.1
达梦版本：dm8
系统版本：Kylin Linux Advanced Server V10

安装benchmarkSQL5.1

#安装依赖包
yum install gcc glibc-headers gcc-c++ gcc-gfortran readline-devel  libXt-devel pcre-devel libcurl libcurl-devel -y
yum install ncurses ncurses-devel autoconf automake zlib zlib-devel bzip2 bzip2-devel xz-devel -y

# 安装jdk
rpm -iv jdk-11.0.24_linux-aarch64_bin.rpm

# 安装ant
tar -xzvf apache-ant-1.10.15-bin.tar.gz -C /usr/local
vim /etc/profile
export ANT_HOME=/usr/local/apache-ant-1.10.15
export PATH=$PATH:$ANT_HOME/bin
source /etc/profile


# 编译安装R语言
yum install pango-devel pango libpng-devel cairo cairo-devel -y
tar -zxf R-3.6.3.tar.gz
cd R-3.6.3
./configure && make && make install


#编译安装htop
unzip htop-3.3.0.zip
cd htop-3.3.0
./autogen.sh && ./configure && make && make install
##########
wget https://hisham.hm/htop/releases/2.2.0/htop-2.2.0.tar.gz
tar -zxvf htop-2.2.0.tar.gz
cd htop-2.2.0/
./configure && make && make install


#检查安装情况
[root@kescs01 R-3.6.3]# java -version
java version "11.0.24" 2024-07-16 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.24+7-LTS-271)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.24+7-LTS-271, mixed mode)
[root@kescs01 R-3.6.3]# ant -version
Apache Ant(TM) version 1.10.15 compiled on August 25 2024
[root@kescs01 R-3.6.3]# 
[root@kescs01 R-3.6.3]# htop --version
htop 2.2.0 - (C) 2004-2025 Hisham Muhammad
Released under the GNU GPL.

[root@kescs01 R-3.6.3]# 
[root@kescs01 R-3.6.3]# R --version
R version 3.6.3 (2020-02-29) -- "Holding the Windsock"
Copyright (C) 2020 The R Foundation for Statistical Computing
Platform: aarch64-unknown-linux-gnu (64-bit)

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under the terms of the
GNU General Public License versions 2 or 3.
For more information about these matters see
https://www.gnu.org/licenses/.

配置达梦支持

下载benchmarkSQL地址：https://github.com/petergeoghegan/benchmarksql/tree/master

benchmarksql默认不支持达梦，编译前需要修改两个配置文件

# 解压后进入benchmarksql目录
unzip benchmarksql-master.zip

# src/client/jTPCC.java文件中添加如下内容
if (iDB.equals("firebird"))
    dbType = DB_FIREBIRD;
else if (iDB.equals("oracle"))
    dbType = DB_ORACLE;
else if (iDB.equals("postgres"))
    dbType = DB_POSTGRES;
else if (iDB.equals("dm"))
    dbType = DB_UNKNOWN;

# run/funcs.sh文件中添加如下内容
function setCP()
{
    case "$(getProp db)" in
    firebird)
        cp="../lib/firebird/*:../lib/*"
        ;;
    oracle)
        cp="../lib/oracle/*"
        if [ ! -z "${ORACLE_HOME}" -a -d ${ORACLE_HOME}/lib ] ; then
        cp="${cp}:${ORACLE_HOME}/lib/*"
        fi
        cp="${cp}:../lib/*"
        ;;
    postgres)
        cp="../lib/postgres/*:../lib/*"
        ;;
    dm)
        cp="../lib/dm/*:../lib/*"
        ;;    
    esac
    myCP=".:${cp}:../dist/*"
    export myCP
}

替换JDBC驱动

mkdir -p /usr/local/src/benchmarksql-master/lib/dm
cp /home/dmdba/dmdbms/drivers/jdbc/DmJdbcDriver*.jar /usr/local/src/benchmarksql-master/lib/dm
[root@localhost.localdomain:/root/benchmarksql5.1-master/lib/dm]# ls -l
总用量 6336
-rwxr-xr-x 1 root root 1618183  8月 12 15:46 DmJdbcDriver11.jar
-rwxr-xr-x 1 root root 1620655  8月 12 15:46 DmJdbcDriver6.jar
-rwxr-xr-x 1 root root 1619913  8月 12 15:46 DmJdbcDriver7.jar
-rwxr-xr-x 1 root root 1618261  8月 12 15:46 DmJdbcDriver8.jar

编译

#使用ant编译BenchmarkSQL
[root@kescs01 benchmarksql-master]# ant
Buildfile: /usr/local/src/benchmarksql-master/build.xml
init:
compile:
    [javac] Compiling 11 source files to /usr/local/src/benchmarksql-master/build
dist:
      [jar] Building jar: /usr/local/src/benchmarksql-master/dist/BenchmarkSQL-6.devel.jar
BUILD SUCCESSFUL
Total time: 1 second

参考

1.https://eco.dameng.com/community/article/20240419141047S3X2PJBNKG4S1IBXBO