TPC-H Benchmark, specific for MYSQL
file structure
- alltable.load
mysql commands to load all data
- dss.ddl
modified schema definition file
- dss.ri
modified constraint definition file
- get-all-query-time.pl
perl script to get runtime of each query
- get-query-time.pl
perl script to get runtime of a query
- queries
22 TPC-H queries
- restart-mysql.pl
perl script to restart mysql server
- tablescanquery.pl
perl script to generate scan query for all tables
Some changes have been made to official files provided by TPC-H, to make
them work with MYSQL. Tested for Ver 14.14 Distrib 5.5.29.
Changes
- [dss.ddl] table name from capital to lower case
- [dss.ri] database name and table names from capital to lower case;
added the key name in the primary table for creating foreign keys.
- [queries/13.sql]