- 下载tpch压缩包
http://www.tpc.org/tpch/
此网页的右中间有
- DBGEN & Reference Data Set zip (23 MB)
- 上传至linux并解压
[root@dn210120 software]# unzip tpch_2_14_3.zip
- 重命名makfile.suite为makefile并修改其中的内容
修改成如下脚本:[root@dn210120 software]# cd dbgen/ [root@dn210120 dbgen]# cp makefile.suite makefile [root@dn210120 dbgen]# vim makefile
################ ## CHANGE NAME OF ANSI COMPILER HERE ################ CC = gcc # Current values for DATABASE are: INFORMIX, DB2, TDAT (Teradata) # SQLSERVER, SYBASE, ORACLE, VECTORWISE # Current values for MACHINE are: ATT, DOS, HP, IBM, ICL, MVS, # SGI, SUN, U2200, VMS, LINUX, WIN32 # Current values for WORKLOAD are: TPCH DATABASE= MYSQL MACHINE = LINUX WORKLOAD = TPCH
- 增加mysql的脚本支持
增加如下脚本:[root@dn210120 dbgen]# vim tpcd.h
#ifdef MYSQL #define GEN_QUERY_PLAN "" #define START_TRAN "START TRANSACTION" #define END_TRAN "COMMIT" #define SET_OUTPUT "" #define SET_ROWCOUNT "limit %d;\n" #define SET_DBASE "use %s;\n" #endif
- 编译tpch
会多了很多*.o文件,生成了dbgen和qgen可执行文件,生成了dss.ddl和dss.ri文件[root@dn210120 dbgen]# make
- 生成数据脚本
可通过查看README来了解其用法[root@dn210120 dbgen]# ./dbgen -s 1
- 修改dss.ddl和dss.ri文件
[root@dn210120 dbgen]# cat dss.ddl | tr A-Z a-z > dss-lower.ddl
</