Percona pstress

What Percona pstress is

Percona pstress is a free, open-source tool for testing concurrent database workloads and crash recovery. It generates randomized transactions from options supplied by the user, creating load on either a single server or a cluster. Its documented uses include checking database features, regressions, and recovery behavior for MySQL, Percona Server, and Percona XtraDB Cluster. A multithreaded C++ workload generator works with a Bash driver that coordinates concurrency and recovery testing. The driver can stop and restart a server between steps, change server variables, and continue with the prior step’s data directory. Command-line controls include thread count, tables, records, transaction size, and SQL operation probabilities. By default, each trial directory saves the data directory, server error logs, thread logs, mysqld binaries, and test configuration. pstress runs on Linux in a self-hosted setup and is licensed under GPL-2.0. Building it requires CMake 2.6 or later, a C++ compiler 4.7 or later, and development files for the target MySQL version or fork. One limitation is that it does not verify whether successful queries return correct data, and its data checks are limited.