tpch-mysql-implementation

Project's tree with short descriptions: DIRECTORY.md

Table of contents:

1. Description
2. Setup
3. Credits

Description

Python implementation for TPC-H benchmark of MYSQL database. CLI tools for measures database performance in docker.

Setup

Download and extract tpch tools (dbgen and qgen) to tpch_tools dir (required to run project): download link

Build and prepare docker images:

docker-compose build

Run containers:

docker-compose up

Run containers:

docker-compose up

Generate database to test (in benchmark container):

generators/generate_db.sh

Run performance test (in benchmark container):

python3 benchmark_cli/cli.py --help
python3 benchmark_cli/cli.py run_benchmark 2

Credits

Tomasz Czochański and Michał Matczak