SysBench

Zielsetzung

Ermöglicht Benchmarks für FileIO, CPU, Datenbanken.

Installation

apt install sysbench

Benchmarks

THREADS=8
sysbench --test=cpu --cpu-max-prime=20000 --threads=$THREADS run

SIZE=150G
THREADS=8
sysbench --test=fileio --file-total-size=$SIZE prepare
sysbench --test=fileio --file-total-size=$SIZE --threads=$THREADS \
  --file-test-mode=rndrw --rand-seed=0 --time=300 --max-requests=0 run
sysbench --file-total-size=$SIZE cleanup

PW=Geheim
DB=dbtest
DBUSER=forum
ITEMS=10000
TABLES=16
THREADS=8
sysbench /usr/share/sysbench/select_random_points.lua --table-size=$ITEMS --tables=$TABLES --db-driver=mysql \
  --mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" prepare
sysbench /usr/share/sysbench/oltp_read_write.lua --table-size=$ITEMS --tables=$TABLES --db-driver=mysql \
  --mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" --time=60 \
  --max-requests=0 --threads=$THREADS run > /tmp/sysbench.mysql.txt
echo "=== cat /tmp/sysbench.mysql.txt"
sysbench /usr/share/sysbench/oltp_read_write.lua --table-size=$ITEMS --tables=$TABLES --db-driver=mysql \
  --mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" cleanup

PW=Geheim
DB=dbtest
DBUSER=forum
ITEMS=10000
TABLES=16
THREADS=8
sysbench /usr/share/sysbench/select_random_points.lua --table-size=$ITEMS --tables=$TABLES --db-driver=pgsql \
  --pgsql-db=$DB --pgsql-user=$DBUSER "--pgsql-password=$PW" prepare
sysbench /usr/share/sysbench/oltp_read_write.lua --table-size=$ITEMS --tables=$TABLES --db-driver=pgsql \
  --pgsql-db=$DB --pgsql-user=$DBUSER "--pgsql-password=$PW" --time=60 \
  --max-requests=0 --threads=$THREADS run > /tmp/sysbench.pg.txt
echo "=== cat /tmp/sysbench.pg.txt"
sysbench /usr/share/sysbench/oltp_read_write.lua --table-size=$ITEMS --tables=$TABLES --db-driver=pgsql \
  --pgsql-db=$DB --pgsql-user=$DBUSER "--pgsql-password=$PW" cleanup