Forked from https://github.com/sjp38/tpch-mariadb
Modification:
- use
"SET GLOBAL local_infile=1;"
to load local data in file - set "password" as default password (insecure)
This repository is a toolbox for TPC-H benchmark[1] execution on MySQL. The tools help modifying, building, and running TPC-H kit source code for MySQL.
- You should get TPC-H kit source code before using the tools.
- You can download it from TPC website[2] as a tar ball after agree to their license.
This toolbox is tested for TPC-H V3.0.1 and MySQL 8.0.31, the latest version as of this writing.
This section describes simple steps for TPC-H test setup and execution. Every example assumes that your current working directory is this repository.
$ unzip xxx-tpc-h-tool.zip
$ mv TPC-H\ V3.0.1/ tpch-kit/
$ ./modify_src.sh
$ ./build.sh
$ ./dbgen.sh <scale factor>
Before next command, you should start mysqld daemon. Next command assumes that
your mysqld has user root
without password. In other words, it should be
able to use $ mysql -u root
to connect to MariaDB prompt.
$ ./loadtest.sh [user] [password]
$ ./mkqueries.sh <scale factor>
$ ./powertest.sh [user] [password]
$ ./mkqueries.sh <scale factor>
$ ./runquery.sh 2 [user] [password]
Pei Mu ds1231h@gmail.com
[1] http://www.tpc.org/tpch/
[2] https://www.tpc.org/tpc_documents_current_versions/current_specifications5.asp