1. Install openGauss according to the guide (https://opengauss.org/zh/docs/2.1.0/docs/installation/installation.html)

# install dependency
yum install -y net-tools libaio-devel flex bison ncurses-devel glibc-devel patch libnsl openeuler-lsb-core readline-devel

# opengauss depends on libreadline7, but openEuler 22.03LTS only provides libreadline8, here manually create a libreadline7 soft link
ln -s /usr/lib64/libreadline.so.8 /usr/lib64/libreadline.so.7

# download software package from official website
[[ `arch` == "x86_64" ]] && wget https://opengauss.obs.cn-south-1.myhuaweicloud.com/2.1.0/x86_openEuler/openGauss-2.1.0-openEuler-64bit.tar.bz2
[[ `arch` == "aarch64" ]] && wget https://opengauss.obs.cn-south-1.myhuaweicloud.com/2.1.0/arm/openGauss-2.1.0-openEuler-64bit.tar.bz2

# create install dir and extract files
mkdir -p /opt/software/openGauss
tar -xf openGauss-2.1.0-openEuler-64bit.tar.bz2 -C /opt/software/openGauss

# create user and group for opengauss
mkdir -p /var/lib/opengauss/
groupadd -r opengauss
adduser -M -N -g opengauss -r -d /var/lib/opengauss -s /bin/bash opengauss
chown -R opengauss:opengauss /var/lib/opengauss/
chown -R opengauss:opengauss /opt/software/openGauss

# run install script, with password "password@123"
su - opengauss
cd /opt/software/openGauss/simpleInstall
sh install.sh -w "password@123"

# load opengauss environment variable
source ~/.bashrc

# verify install result, opengauss has started
gs_ctl query -D /opt/software/openGauss/data/single_node

# create benchmark database as tpcc
gsql -d postgres -r -c 'create database tpcc; create user tpcc with password "password@123"; grant all privileges to tpcc;'

# quit opengauss user and get back to opengauss example dir
exit

2. Install benchmarksql-5.0 as benchmark

# install dependency
yum install -y java ant

# download software package and extract files
wget https://udomain.dl.sourceforge.net/project/benchmarksql/benchmarksql-5.0.zip
unzip -q benchmarksql-5.0.zip
cd benchmarksql-5.0

# install opengauss jdbc driver for benchmarksql and recompile benchmarksql
[[ `arch` == "x86_64" ]] && wget https://opengauss.obs.cn-south-1.myhuaweicloud.com/2.1.0/x86_openEuler/openGauss-2.1.0-JDBC.tar.gz
[[ `arch` == "aarch64" ]] && wget https://opengauss.obs.cn-south-1.myhuaweicloud.com/2.1.0/arm/openGauss-2.1.0-JDBC.tar.gz
tar -xvf openGauss-2.1.0-JDBC.tar.gz
rm ./lib/postgres/postgresql*.jar
mv ./postgresql.jar ./lib/postgres/gsjdbc4.jar
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:`pwd`/lib/postgres/gsjdbc4.jar
echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:`pwd`/lib/postgres/gsjdbc4.jar" >> /etc/profile
ant

# create benchmark configuration file props.opengauss
cd run/
cp props.pg props.opengauss
vim props.opengauss

update following properties(adjust for your own machine according to comment):

// connection parameters, conn url should point to the tpcc database we have created
db=postgres
driver=org.postgresql.Driver
conn=jdbc:postgresql://localhost:5432/tpcc
user=tpcc
password=password@123

// number of warehouses, each warehouse contains about 80M data, total warehouses size should not exceed available memory
warehouses=20
// number of processes used to load data, should not exceed cpu core number
loadWorkers=4
// concurrent terminal count, usually not more than cpu core number
terminals=4

// To run specified transactions per terminal - if this is set nonzero, runMins must equal zero
runTxnsPerTerminal=0
// To run benchmark for specified minutes - if this is set nonzero, runTxnsPerTerminal must equal zero
runMins=5

// number of total transactions per minute, 0 means no limit
limitTxnsPerMin=0
// binding mode for terminal and warehouse, usually set true for TPCC
terminalWarehouseFixed=true

// no need to collect os information, just comment following options if they are not commented
// osCollectorScript=
// osCollectorInterval=
// osCollectorSSHAddr=
// osCollectorDevices=

build benchmark database:

./runDatabaseBuild.sh props.opengauss

3. Prepare the environment

sh prepare.sh

4. Start to tuning

atune-adm tuning --project openGauss_tpcc --detail openGauss_client.yaml

5. Restore the environment

atune-adm tuning --restore --project openGauss_tpcc