GitHub - Toknowledge/sqlbench: a forked project from dbt2, can do a standard TPC-C test.

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 53 Commits
src		src
.gitignore		.gitignore
AUTHORS		AUTHORS
COPYING		COPYING
ChangeLog		ChangeLog
INSTALL		INSTALL
Makefile.am		Makefile.am
Makefile.in		Makefile.in
NEWS		NEWS
README		README
TODO		TODO
aclocal.m4		aclocal.m4
compile		compile
config.h.in		config.h.in
configure		configure
configure.ac		configure.ac
depcomp		depcomp
install-sh		install-sh
missing		missing

Repository files navigation

create tables
-------------
PostgreSQL:
psql -f src/scripts/create-tables.sql
MySQL:
mysql < src/scripts/create-tables.sql

load data
----------
PostgreSQL:
src/core/datagen -t postgresql --dbname=tpcc --user=dcwang --host=localhost -w 100 -j 10
MySQL:
src/core/datagen -t mysql --dbname=tpcc --user=dcwang --host=127.0.0.1 -w 100 -j 10

create indexes
--------------
Execute Use src/scripts/create-indexes.sql using SQL shell, eg.
psql -f src/scripts/create-indexes.sql
analyze;

check plans
-----------
PostgreSQL:
PGPORT=5566 PGHOST=localhost DBT2DBNAME=tpcc src/scripts/pgsql/plans -o plans.out

run test
--------
PostgreSQL:
sqlbench/sqlbench -t postgresql --dbname=tpcc --user=tpcc --host=localhost --port=5566 -w100 -c32 -l7200 -r1200
MySQL:
sqlbench/sqlbench -t mysql --dbname=tpcc --user=tpcc --host=127.0.0.1 --port=3306 -w100 -c32 -l7200 -r1200


test result
-----------
sqlbench/src/utils/post_process -l mix.log