Skip to content
Sysbench scripts to generate a tpcc-like workload for MySQL and PostgreSQL
Branch: master
Clone or download

Latest commit

Latest commit 72c5634 Jan 23, 2020


Type Name Latest commit message Commit time
Failed to load latest commit information.
LICENSE Update Jul 12, 2018
tpcc-scm-1.rockspec Add a LuaRocks scm-type spec. Jun 17, 2018
tpcc.lua Fixes Jan 14, 2020
tpcc_check.lua Improve check May 19, 2018
tpcc_common.lua Fixes Jan 14, 2020
tpcc_run.lua Update tpcc_run.lua Dec 20, 2018


TPCC-like workload for sysbench 1.0.x. Make sure you are using sysbench 1.0.14 or better!

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 --db-driver=mysql 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 --db-driver=mysql 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 --db-driver=mysql run


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

You can’t perform that action at this time.