Prerequisites
These commands assume you have sysbench v1.0.2 or greater installed.
Prepare the database
sysbench oltp_read_only --pgsql-host=${DB_HOST} \ --pgsql-port=${DB_PORT} \ --pgsql-password=${DB_PASSWORD} \ --pgsql-user=${DB_USER} \ --pgsql-db=${DB_NAME} \ --tables=10 \ --table-size=130000000 \ --threads=2 \ --report-interval=1 \ --db-driver=pgsql \ prepare
Run the OLTP Read-only benchmark
sysbench oltp_read_only \ --pgsql-host=${DB_HOST} \ --pgsql-port=${DB_PORT} \ --pgsql-password=${DB_PASSWORD} \ --pgsql-user=${DB_USER} \ --pgsql-db=${DB_NAME} \ --tables=10 \ --table-size=130000000 \ --time=300 \ --threads=${THREAD_COUNT} \ --report-interval=1 \ --histogram=off \ --percentile=99 \ --db-driver=pgsql \ run