planetscale / sysbench-tpcc Public

forked from Percona-Lab/sysbench-tpcc

Notifications You must be signed in to change notification settings
Fork 3
Star 1

Sysbench scripts to generate a tpcc-like workload for MySQL and PostgreSQL

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 20 Commits
README.md		README.md
tpcc.lua		tpcc.lua
tpcc_check.lua		tpcc_check.lua
tpcc_common.lua		tpcc_common.lua
tpcc_run.lua		tpcc_run.lua

Repository files navigation

sysbench-tpcc

TPCC-like workload for sysbench

prepare data and tables

./tpcc.lua --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=sbt --time=300 --threads=64 --report-interval=1 --tables=10 --scale=100 prepare

prepare for RocksDB

./tpcc.lua --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=sbr --time=3000 --threads=64 --report-interval=1 --tables=10 --scale=100 --use_fk=0 --mysql_storage_engine=rocksdb --mysql_table_options='COLLATE latin1_bin' --trx_level=RC prepare

Run benchmark

./tpcc.lua --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=sbt --time=300 --threads=64 --report-interval=1 --tables=10 --scale=100 run

Cleanup

./tpcc.lua --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql-db=sbt --time=300 --threads=64 --report-interval=1 --tables=10 --scale=100 cleanup