SysBench: Unterschied zwischen den Versionen

Aus Info-Theke
Zur Navigation springen Zur Suche springen
Zeile 5: Zeile 5:


= Installation =
= Installation =
<syntaxhighlight>
<syntaxhighlight lang="bash">
apt install sysbench
apt install sysbench
</syntaxhighlight>
</syntaxhighlight>


= Benchmarks =
= Benchmarks =
<syntaxhighlight>
<syntaxhighlight lang="bash">
THREADS=8
THREADS=8
sysbench --test=cpu --cpu-max-prime=20000 --threads=$THREADS run
sysbench --test=cpu --cpu-max-prime=20000 --threads=$THREADS run

Version vom 10. Januar 2022, 13:43 Uhr


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.report.txt
echo "=== cat /tmp/sysbench.report.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