sysbench-cheatsheet.txt

docker run --network host --rm \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=4 \
--time=10 \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=sbtest \
--mysql-password=password \
/usr/share/sysbench/oltp_read_write.lua \
run




docker run --network host --rm \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=16 \
--time=10 \
--mysql-host=127.0.0.1 \
--mysql-port=15306 \
--mysql-user=sbtest \
--mysql-password=password \
/usr/share/sysbench/oltp_read_write.lua \
run


-------

docker run --network host --rm \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=8 \
--time=30 \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=sbtest \
--mysql-password=password \
--skip-trx=on \
/usr/share/sysbench/oltp_point_select.lua \
run




docker run --network host --rm \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=4 \
--time=30 \
--mysql-host=127.0.0.1 \
--mysql-port=15306 \
--mysql-user=sbtest \
--mysql-password=password \
--skip-trx=on \
/usr/share/sysbench/oltp_point_select.lua \
run

-------


docker run --network host --rm \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=8 \
--time=30 \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=sbtest \
--mysql-password=password \
--skip-trx=on \
/usr/share/sysbench/oltp_read_only.lua \
run




docker run --network host --rm \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=8 \
--time=30 \
--mysql-host=127.0.0.1 \
--mysql-port=15306 \
--mysql-user=sbtest \
--mysql-password=password \
--skip-trx=on \
/usr/share/sysbench/oltp_read_only.lua \
run

-------

docker run --network host --rm \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=16 \
--time=30 \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=sbtest \
--mysql-password=password \
--skip-trx=on \
--mysql-ignore-errors=1062 \
/usr/share/sysbench/oltp_write_only.lua \
run




docker run --network host --rm \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=1600 \
--time=30 \
--mysql-host=127.0.0.1 \
--mysql-port=15306 \
--mysql-user=sbtest \
--mysql-password=password \
--skip-trx=on \
--mysql-ignore-errors=1062 \
/usr/share/sysbench/oltp_write_only.lua \
run


-------


docker run --network host --rm \
-w /customsuites/sysbench/src/lua \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=8 \
--time=10 \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=sbtest \
--mysql-password=password \
--skip-trx=on \
--mysql-ignore-errors=1062 \
--read-percent=80 \
--write_percent=20 \
/customsuites/sysbench/src/lua/oltp_read_write_pct.lua \
run


docker run --network host --rm \
-w /customsuites/sysbench/src/lua \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--tables=40 \
--table-size=250000 \
--threads=8 \
--time=10 \
--mysql-host=127.0.0.1 \
--mysql-port=15306 \
--mysql-user=sbtest \
--mysql-password=password \
--skip-trx=on \
--mysql-ignore-errors=1062 \
--read-percent=80 \
--write_percent=20 \
/customsuites/sysbench/src/lua/oltp_read_write_pct.lua \
run


------


docker run --network host --rm \
-w /customsuites/sysbench/src/lua \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--threads=4 \
--time=60 \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=root \
--mysql-password=passwd \
--mysql-db=sbt \
--tables=40 --scale=4 --use_fk=0 \
/customsuites/sysbench/src/lua/tpcc.lua \
run


docker run --network host --rm \
-w /customsuites/sysbench/src/lua \
apecloud/customsuites:latest \
sysbench \
--db-driver=mysql \
--report-interval=1 \
--threads=1 \
--time=60 \
--mysql-host=127.0.0.1 \
--mysql-port=15306 \
--mysql-user=root \
--mysql-password=passwd \
--mysql-db=sbt \
--tables=40 --scale=4 --use_fk=0 \
/customsuites/sysbench/src/lua/tpcc.lua \
run