SysBench: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K (→Benchmarks) |
|||
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