Alibaba Cloud ApsaraDB RDSにARMアーキテクチャがリリースされたので紹介および検証してみる

#!/bin/sh
mkdir -p logs
thread=500
echo "prepare data using default settings, ref sysbench SIZE"  >> logs/sysbench_read_write_0_prepare.log
./sysbench.sh prepare ${thread} >> logs/sysbench_read_write_0_prepare.log
echo "data had been successfully initialized."  >> logs/sysbench_read_write_0_prepare.log

#!/bin/sh
LUA=/usr/share/sysbench/oltp_read_write.lua
SIZE=10000000
DB=pgsql
HOST=pgm-1ud78r9lmbur2ayt.pg.rds.aliyuncs.com
PORT=5432
USER=sbtest
PASSWORD=Test1234
DBNAME=sbdb

usage()
{
  echo "Usage: ./sysbench.sh <prepare|run|cleanup> <num of threads>"
  exit "${1}"
}
#chack argumets
if [ "${1}" = "" -o $# -gt 3 ]; then
  usage 1
elif [ "${2}" = "" ]; then
  THREADS=1
else
  THREADS=${2}
fi
echo "Running command: sysbench ${LUA} --db-driver=${DB} --pgsql-host=${HOST} --pgsql-port=${PORT} --pgsql-user=${USER} --pgsql-password=${PASSWORD} --pgsql-db=${DBNAME} --table-size=${SIZE} --tables=100 --events=0 --time=60 --db-ps-mode=disable --percentile=95 --report-interval=1 --threads=${THREADS} ${1}"
sysbench ${LUA} --db-driver=${DB} --pgsql-host=${HOST} --pgsql-port=${PORT} --pgsql-user=${USER} --pgsql-password=${PASSWORD} --pgsql-db=${DBNAME} --table-size=${SIZE} --tables=100 --events=0 --time=120 --db-ps-mode=disable --percentile=95 --report-interval=1 --threads=${THREADS} ${1}

cd /root/arm
chmod a+x *.sh
nohup sh prepare.sh 2>&1&

#!/bin/sh
DATE=`date '+%Y%m%d%H%M'`
mkdir $DATE
# thread=500

# echo "prepare data using default settings, ref sysbench SIZE"  >> ${DATE}/sysbench_read_write_main.log
# ./sysbench.sh prepare ${thread} >> ${DATE}/sysbench_read_write_main.log
for thread in 500
do
    echo "Time: $(date +"%Y%m%d%H%M%S"), now running sysbench with thread of: " + ${thread}  >> ${DATE}/sysbench_read_write_${thread}.log
  ./sysbench.sh run ${thread} >> ${DATE}/sysbench_read_write_${thread}.log
done
# echo "cleaning data up."  >> ${DATE}/sysbench_read_write_main.log
# ./sysbench.sh cleanup ${thread} >> ${DATE}/sysbench_read_write_main.log

#!/bin/sh
LUA=/usr/share/sysbench/oltp_read_write.lua
SIZE=10000000
DB=pgsql
HOST=pgm-1ud78r9lmbur2ayt.pg.rds.aliyuncs.com（現在このインスタンスは削除済）
PORT=5432
USER=test
PASSWORD=Test1234（現在このインスタンスは削除済）
DBNAME=sbdb
usage()
{
  echo "Usage: ./sysbench.sh  "
  exit "${1}"
}
#chack argumets

if [ "${1}" = "" -o $# -gt 3 ]; then
  usage 1
elif [ "${2}" = "" ]; then
  THREADS=1
else
  THREADS=${2}
fi
echo "Running command: sysbench ${LUA} --db-driver=${DB} --pgsql-host=${HOST} --pgsql-port=${PORT} --pgsql-user=${USER} --pgsql-password=${PASSWORD} --pgsql-db=${DBNAME} --table-size=${SIZE} --tables=100 --events=0 --time=120 --db-ps-mode=disable --percentile=95 --report-interval=1 --threads=${THREADS} ${1}"
sysbench ${LUA} --db-driver=${DB} --pgsql-host=${HOST} --pgsql-port=${PORT} --pgsql-user=${USER} --pgsql-password=${PASSWORD} --pgsql-db=${DBNAME} --table-size=${SIZE} --tables=100 --events=0 --time=120 --db-ps-mode=disable --percentile=95 --report-interval=1 --threads=${THREADS} ${1}

nohup sh test.sh 2>&1&