SysBench: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| (3 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| 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 | ||
| Zeile 21: | Zeile 21: | ||
sysbench --file-total-size=$SIZE cleanup | sysbench --file-total-size=$SIZE cleanup | ||
PW=Geheim | |||
DB=dbtest | DB=dbtest | ||
DBUSER=forum | DBUSER=forum | ||
ITEMS=10000 | |||
TABLES=16 | |||
THREADS=8 | THREADS=8 | ||
sysbench - | 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" prepare | --mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" prepare | ||
sysbench - | 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 \ | --mysql-db=$DB --mysql-user=$DBUSER "--mysql-password=$PW" --time=60 \ | ||
--max-requests=0 --threads=$THREADS run > /tmp/sysbench.mysql.txt | |||
sysbench -- | 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 | --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/oltp_read_write.lua --random-seed=4711 --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 --random-seed=4711 --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 | |||
</syntaxhighlight> | </syntaxhighlight> | ||
Aktuelle Version vom 11. Januar 2022, 06:32 Uhr
Zielsetzung[Bearbeiten]
Ermöglicht Benchmarks für FileIO, CPU, Datenbanken.
Installation[Bearbeiten]
apt install sysbench
Benchmarks[Bearbeiten]
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/oltp_read_write.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/oltp_read_write.lua --random-seed=4711 --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 --random-seed=4711 --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