Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Percona pstress

github.com

  • Free plan
  • Linux
  • Self-hosted
6.7 Club score Visit github.com

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

pstress

Free

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.