麒麟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
你们也用麒麟系统???贼难用。。 我们要求完全替代
问题不大,习惯就行,后续这玩意直接跑docker或者k8s。