How do I install HammerDB on Linux?

Refer to the official documentation at hammerdb.com for installation guides; it typically involves downloading binaries or building from source, depending on your distribution, since the README doesn't provide detailed steps.

HammerDB vs Sysbench for MySQL benchmarking?

HammerDB uses TPC standards for reliable cross-database comparisons, while Sysbench is more flexible for custom tests. Choose HammerDB for standardized benchmarks and Sysbench for ad-hoc performance checks.

What databases does HammerDB support?

HammerDB benchmarks Oracle, Microsoft SQL Server, IBM Db2, PostgreSQL, MySQL, and MariaDB, as explicitly listed in the README, covering most major relational systems.

How to run a TPC-C test with HammerDB?

After installation, configure your database connection in the HammerDB interface, set up the TPC-C workload parameters, and initiate the test via the GUI or scripts, following the external documentation for precise steps.

Is HammerDB free for commercial use?

Yes, HammerDB is open-source under GPL v3.0, allowing free commercial use, but ensure compliance with the license terms, as mentioned in the README's license section.

Can HammerDB benchmark cloud databases?

Yes, as long as the cloud database is a supported relational system like Amazon RDS for PostgreSQL, but network configuration and latency must be carefully managed for accurate results.

HammerDB

GPL-3.0Tclv5.0

Open-source benchmarking and load testing software for popular databases including Oracle, SQL Server, PostgreSQL, MySQL, and MariaDB.

Visit Website

What is HammerDB?

HammerDB is an open-source database benchmarking and load testing software that implements industry-standard TPC-C and TPC-H benchmarks. It allows users to measure and compare the performance of popular databases including Oracle, SQL Server, PostgreSQL, MySQL, and MariaDB under realistic workloads. The tool helps identify performance bottlenecks and optimize database configurations.

Target Audience

Database administrators, system architects, and developers who need to evaluate database performance, compare different database systems, or optimize existing database configurations for production workloads.

Value Proposition

HammerDB provides standardized, reproducible benchmarking methodology that enables fair performance comparisons across different database platforms. As open-source software, it offers professional-grade benchmarking capabilities without licensing costs, making it accessible for organizations of all sizes.

Overview

HammerDB: The industry standard open-source database benchmark

Use Cases

Best For

Comparing performance between different database systems before migration

Related Projects

Community-curated · Updated weekly · 100% open source

Found a gem we're missing?

Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.

Submit a project Star on GitHub

GitHub

760 stars147 forks0 contributors

Load testing database configurations under production-like workloads

Identifying performance bottlenecks in database setups

Validating database hardware and software optimizations

Conducting TPC-C and TPC-H compliant benchmark tests

Performance testing for database upgrade planning

Not Ideal For

Projects needing to benchmark NoSQL databases like MongoDB or Cassandra
Teams requiring highly customized, non-standard workload simulations outside TPC specifications
Environments where quick, ad-hoc performance checks are prioritized over full benchmark setups

Pros & Cons

Pros

Industry Standard Methodology

Implements TPC-C and TPC-H benchmarks, providing reliable and reproducible performance comparisons across database systems, as highlighted in the README's focus on standardized benchmarking.

Wide Database Support

Benchmarks major relational databases including Oracle, SQL Server, PostgreSQL, MySQL, and MariaDB, enabling fair cross-platform evaluations, as listed in the README's supported databases.

Open-Source Accessibility

Licensed under GPL v3.0, it offers professional benchmarking tools at no cost, making it accessible for organizations of all sizes, per the README's license information.

Realistic Load Testing

Generates production-like workloads to simulate stress conditions and accurately identify performance bottlenecks, as described in the key features for load testing capabilities.

Cons

No NoSQL Benchmarking

Limited to relational databases, excluding support for popular NoSQL systems like MongoDB or Redis, which restricts its use in modern polyglot persistence environments.

Complex Configuration

Requires in-depth knowledge of database settings and TPC methodologies, making initial setup and tuning challenging, especially without integrated step-by-step guides in the README.

External Documentation Dependency

Relies on an external website (hammerdb.com) for documentation, which may be less accessible or up-to-date compared to community-driven or integrated resources, as noted in the README's support section.

Frequently Asked Questions

Home

MySQL

Sysbench

Scriptable database and system performance benchmark

Stars6,743

Forks1,144

Last commit1 year ago

TPCC-MySQL

tpcc-mysql is an open-source port of the TPC-C benchmark specifically for MySQL databases. It simulates a wholesale parts supplier's online transaction processing (OLTP) workload to evaluate database performance, scalability, and consistency under realistic conditions. ## Key Features - **TPC-C Compliance** — Implements the standard TPC-C benchmark specification for MySQL environments - **Parallel Data Loading** — Supports loading test data in parallel to speed up benchmark setup - **Configurable Workload** — Allows adjustment of warehouses, connections, warmup time, and benchmark duration - **Detailed Metrics** — Reports throughput, 95th/99th percentile response times, and maximum response times per interval - **Transaction Mix** — Simulates multiple transaction types (New Orders, Payments, etc.) as per TPC-C specification ## Philosophy The project follows the TPC-C benchmark philosophy of providing a standardized, repeatable method for evaluating database performance under realistic OLTP workloads, enabling fair comparisons between different MySQL configurations.

Stars488

Forks183

Last commit8 years ago

go-tpc

A toolbox to benchmark TPC workloads in Go

Stars211

Forks115

Last commit4 months ago

#load-testing

#performance-testing

#oracle

#database-performance

#benchmarks

#database-administration

#database-benchmarking

#benchmark

#sql

MySQL2.6k