Prerequisites
These commands assume you have sysbench v1.0.2 or greater installed as well as the Percona TPCC scripts.
Prepare the database
./tpcc.lua \ --pgsql-host=${DB_HOST} \ --pgsql-port=${DB_PORT} \ --pgsql-password=${DB_PASSWORD} \ --pgsql-user=${DB_USER} \ --pgsql-db=${DB_NAME} \ --tables=20 \ --scale=250 \ --use_fk=0 \ --threads=20 \ --report-interval=1 \ --db-driver=pgsql \ prepare
Run the benchmark
./tpcc.lua \ --pgsql-host=${DB_HOST} \ --pgsql-port=${DB_PORT} \ --pgsql-password=${DB_PASSWORD} \ --pgsql-user=${DB_USER} \ --pgsql-db=${DB_NAME} \ --tables=20 \ --scale=250 \ --use_fk=0 \ --time=300 \ --threads=${THREAD_COUNT} \ --report-interval=1 \ --histogram=off \ --percentile=99 \ --db-driver=pgsql \ run