This topic describes the performance test results of an online transactional processing (OLTP) workload for PolarDB for MySQL 5.7 Cluster Edition.
For more information, see Performance testing method (OLTP).
Dedicated specifications
Primary Node + One Read-only Node
This performance test uses a policy of incrementally increasing concurrent threads. The sysbench tool is used to apply a load to the cluster. The test starts with a low concurrency of one thread and increases the number of threads exponentially, such as 8, 16, 32, 64, and 128. At each concurrency level, the test runs until key performance indicators, such as queries per second (QPS) and transactions per second (TPS), reach a stable state. To ensure data reliability, after the performance curve stabilizes, the test continues to run for an additional period. The average value from this stable period is recorded as the performance data for that concurrency level. The test stops when the average QPS and TPS no longer increase with a subsequent increase in the number of concurrent threads. The highest peak QPS and TPS values recorded across all test rounds are used as the final performance results.
Read-only scenarios
The following are the read-only performance test results for each specification:
Specifications | 2 cores 8 GB | 2 cores 16 GB | 4 cores 16 GB | 4 cores 32 GB | 8 cores 32 GB | 8 cores 64 GB | 16 cores 64 GB | 16 cores 128 GB | 32 cores 128 GB | 32 cores 256 GB |
Read-only QPS | 165840.52 | 173046.39 | 392780.94 | 382355.97 | 806233.12 | 741394.52 | 1547135.97 | 2114557.62 | 1435099.19 | 2261291.44 |
Read-only TPS | 16584.05 | 17304.64 | 39278.09 | 38235.6 | 80623.31 | 74139.45 | 154713.59 | 148668.97 | 211455.77 | 226129.15 |
Read/write scenarios
The following are the read/write performance test results for each specification:
Specifications | 2 cores 8 GB | 2 cores 16 GB | 4 cores 16 GB | 4 cores 32 GB | 8 cores 32 GB | 8 cores 64 GB | 16 cores 64 GB | 16 cores 128 GB | 32 cores 128 GB | 32 cores 256 GB |
Read/write QPS | 45480.88 | 46959.59 | 104275.11 | 107435.21 | 229667.45 | 219998.09 | 435287.69 | 423693.91 | 682127.09 | 738963.88 |
Read/write TPS | 2274.04 | 2347.98 | 5213.76 | 5371.76 | 11483.37 | 10999.9 | 21764.38 | 21184.69 | 34106.36 | 36948.19 |
Write Scenario Peak Data
The following are the write-only performance test results for each specification:
Specifications | 2 cores 8 GB | 2 cores 16 GB | 4 cores 16 GB | 4 cores 32 GB | 8 cores 32 GB | 8 cores 64 GB | 16 cores 64 GB | 16 cores 128 GB | 32 cores 128 GB | 32 cores 256 GB |
Write QPS | 47489.27 | 44155.21 | 83972.5 | 82457.31 | 185734.36 | 178567.94 | 311276.84 | 312715.55 | 478153.21 | 483315.25 |
Write TPS | 7914.88 | 7359.2 | 13995.42 | 13742.88 | 30955.73 | 29761.33 | 51879.47 | 52119.26 | 79692.21 | 80552.55 |