TPCC-MySQL
A port of the TPC-C benchmark for MySQL to measure database performance under OLTP workloads.
What is TPCC-MySQL?
tpcc-mysql is an open-source implementation of the TPC-C benchmark specifically adapted for MySQL databases. It simulates a complex online transaction processing (OLTP) workload to measure database performance, scalability, and response times under realistic conditions. The tool helps database administrators and developers evaluate how their MySQL configurations handle concurrent transactions.
Database administrators, performance engineers, and developers working with MySQL who need to benchmark database performance, compare hardware/configuration changes, or validate scalability for OLTP applications.
It provides a standardized, industry-recognized benchmark specifically ported for MySQL, offering reproducible performance measurements and detailed transaction metrics that help identify database bottlenecks and optimization opportunities.
Overview
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.
Related Projects
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.
