Percona pstress
github.com
- Free plan
- Linux
- Self-hosted
What Percona pstress is
Percona pstress is a free, open-source tool for concurrent database workload and crash-recovery testing. It creates randomized transactions from user-supplied options and generates load on a single server or cluster. Documented uses include testing database features, regressions, and crash recovery for MySQL, Percona Server, and Percona XtraDB Cluster. A multithreaded C++ workload generator works with a Bash driver that coordinates concurrency and recovery steps. The driver can stop and restart a server between steps, change server variables, and continue using the preceding step’s data directory. Command-line options set thread count, tables, records, transaction size, and SQL-operation probabilities. By default, each trial directory stores the data directory, server error logs, thread logs, mysqld binaries, and test configuration. pstress runs self-hosted on Linux and is licensed GPL-2.0. Building requires CMake 2.6 or later, a C++ compiler 4.7 or later, and development files for the selected MySQL version or fork. Percona notes that successful query results are not verified and data checks are limited.
Who it suits
It suits database engineers testing MySQL-family features, regressions, concurrency, and crash recovery in self-hosted Linux environments.
Good to know, and what to watch
- Generates randomized concurrent transactions
- Tests features, regressions, and crash recovery
- Supports MySQL and Percona variants
- Configurable workload probabilities and sizes
- Preserves detailed trial diagnostics
- Does not verify successful query results
- Data checks are limited
- Requires local build dependencies
- Self-hosted Linux operation
Plans
Every plan and pricepstress
Free plan
The verdict
pstress provides configurable concurrent and recovery workloads for MySQL-family databases, with saved diagnostics for each trial. Its limited result validation means it should complement, not replace, correctness checks.
What the maker publishes
- Architecture
- pstress has a multithreaded C++ workload generator and a Bash driver script for concurrency and crash recovery testing. source
- Build requirements
- The README lists CMake 2.6 or later, a C++ compiler 4.7 or later, and development files for the target MySQL version or fork as build requirements. source
- Crash recovery
- The driver can stop and restart the server between test steps, vary server variables, and continue the workload using the previous step's data directory. source
- Diagnostics
- By default, pstress saves each trial directory with the data directory, server error logs, thread logs, mysqld binaries, and the test configuration. source
- Founded
- 2006 source
- Intended users
- Percona's article describes regression, feature, and crash recovery testing as pstress use cases. source
- License
- The repository identifies its license as GPL-2.0. source
- Limit
- Percona's article says pstress does not verify that successful queries return correct data, and its data checks are limited. source
- Purpose
- pstress is a probability-based open-source tool for concurrent database testing and crash recovery testing. source
- Server support
- The README gives build options for MySQL, Percona Server, and Percona XtraDB Cluster. source
- Testing uses
- The README says users can use it to test database features, regressions, and crash recovery. source
- Workload controls
- Command-line options control workload details such as thread count, tables, records, transaction size, and SQL operation probabilities. source
- Workload generation
- It generates random transactions based on user-provided options and can create concurrent load on a cluster or a single server. source
Checked against the maker's pages on 7 Oct 2026.