SysBench: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „Kategorie:ServerApplication = Zielsetzung = Ermöglicht Benchmarks für FileIO, CPU, Datenbanken. = Installation = <syntaxhighlight> apt install sysbench…“) |
|||
| Zeile 11: | Zeile 11: | ||
= Benchmarks = | = Benchmarks = | ||
<syntaxhighlight> | <syntaxhighlight> | ||
sysbench --test=cpu --cpu-max-prime=20000 --threads= | THREADS=8 | ||
sysbench --test=cpu --cpu-max-prime=20000 --threads=$THREADS run | |||
SIZE=150G | SIZE=150G | ||
THREADS=8 | |||
sysbench --test=fileio --file-total-size=$SIZE prepare | sysbench --test=fileio --file-total-size=$SIZE prepare | ||
sysbench --test=fileio --file-total-size=$SIZE --file-test-mode=rndrw -- | sysbench --test=fileio --file-total-size=$SIZE --threads=$THREADS \ | ||
sysbench | --file-test-mode=rndrw --rand-seed=0 --time=300 --max-requests=0 run | ||
sysbench --file-total-size=$SIZE cleanup | |||
DB=dbtest | DB=dbtest | ||
DBUSER=forum | DBUSER=forum | ||
PW=Geheim | PW=Geheim | ||
ITEMS=1000000 | |||
THREADS=8 | THREADS=8 | ||
sysbench --test=oltp --oltp-table-size=$ | sysbench --test=oltp --oltp-table-size=$ITEMS --db-driver=mysql \ | ||
--mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" prepare | --mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" prepare | ||
sysbench --test=oltp --oltp-table-size=$ | sysbench --test=oltp --oltp-table-size=$ITEMS --db-driver=mysql \ | ||
--mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" - | --mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" --time=60 \ | ||
--oltp-read-only=on --max-requests=0 --num-threads=$THREADS run | --oltp-read-only=on --max-requests=0 --num-threads=$THREADS run | ||
sysbench --test=oltp --db-driver=mysql \ | sysbench --test=oltp --db-driver=mysql \ | ||
--mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" cleanup | --mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" cleanup | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Version vom 10. Januar 2022, 12:08 Uhr
Zielsetzung
Ermöglicht Benchmarks für FileIO, CPU, Datenbanken.
Installation
apt install sysbenchBenchmarks
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
DB=dbtest
DBUSER=forum
PW=Geheim
ITEMS=1000000
THREADS=8
sysbench --test=oltp --oltp-table-size=$ITEMS --db-driver=mysql \
--mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" prepare
sysbench --test=oltp --oltp-table-size=$ITEMS --db-driver=mysql \
--mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" --time=60 \
--oltp-read-only=on --max-requests=0 --num-threads=$THREADS run
sysbench --test=oltp --db-driver=mysql \
--mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" cleanup