SysBench: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| Zeile 27: | Zeile 27: | ||
TABLES=16 | TABLES=16 | ||
THREADS=8 | THREADS=8 | ||
sysbench /usr/share/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 /usr/share/sysbench/oltp_read_write.lua --table-size=$ITEMS --tables=$TABLES --db-driver=mysql \ | sysbench /usr/share/sysbench/oltp_read_write.lua --table-size=$ITEMS --tables=$TABLES --db-driver=mysql \ | ||
| Zeile 42: | Zeile 42: | ||
TABLES=16 | TABLES=16 | ||
THREADS=8 | THREADS=8 | ||
sysbench /usr/share/sysbench/ | 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 | --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 \ | 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 \ | --pgsql-db=$DB --pgsql-user=$DBUSER "--pgsql-password=$PW" --time=60 \ | ||
--max-requests=0 --threads=$THREADS run > /tmp/sysbench.pg.txt | --max-requests=0 --threads=$THREADS run > /tmp/sysbench.pg.txt | ||
| Zeile 50: | Zeile 50: | ||
sysbench /usr/share/sysbench/oltp_read_write.lua --table-size=$ITEMS --tables=$TABLES --db-driver=pgsql \ | 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 | --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