This page provides OLTP (online transactional processing) peak performance data for PolarDB for MySQL 8.0.1 Cluster Edition across all available dedicated specifications. Use these results to estimate the right specification for your workload before provisioning a cluster.
For the test methodology, see OLTP performance testing.
Test setup
All results were collected from a cluster with one read/write node and one read-only node. Tests used Sysbench with an incremental concurrency ramp: starting at 1 thread and increasing through 8, 16, 32, 64, and 128. At each concurrency level, the test ran until QPS (queries per second) and TPS (transactions per second) stabilized, then continued for a sustained period. The reported values are averages from the stable window. The final result is the highest peak QPS and TPS recorded across all concurrency levels.
For large-scale specifications, endpoints were adjusted and key parameters were tuned to minimize link latency and fully use cluster resources.
Parameter tuning
Large-scale specification (120 cores, 920 GB)
DBNodeClassCPU is the number of CPU cores in the compute node.
| Parameter | Before modification | After modification | Effect |
|---|---|---|---|
loose_innodb_lock_sys_rec_partition | 1 | 120 | Sets lock system partitions to match CPU core count, reducing lock contention under high concurrency |
loose_thread_pool_size | {DBNodeClassCPU × 2} | {DBNodeClassCPU × 1} | Reduces thread pool size to prevent excessive thread competition and improve resource efficiency |
loose_innodb_csn_lockfree | OFF | ON | Enables the lock-free Commit Sequence Number (CSN) mechanism to improve transaction commit efficiency and reduce lock overhead |
Other specifications
| Parameter | Value | Effect |
|---|---|---|
loose_innodb_lock_sys_rec_partition | {DBNodeClassCPU} | Sets lock system partitions to match CPU core count, reducing lock contention under high concurrency |
Peak read-only performance
The read-only test uses --range-selects=0, which disables range queries and tests the oltp_point_selects scenario (point-select queries only).
| 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, 32 GB | 16 cores, 64 GB | 16 cores, 128 GB | 32 cores, 128 GB | 32 cores, 256 GB | 64 cores, 512 GB | 120 cores, 920 GB |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Read-only QPS | 123,234.31 | 128,407.45 | 261,992.95 | 263,557.53 | 518,849.56 | 514,733 | 919,903.31 | 968,769 | 922,508.84 | 1,435,099.19 | 1,431,018.25 | 1,975,797.41 | 3,805,887 |
| Read-only TPS | 12,323.43 | 12,840.74 | 26,199.30 | 26,355.75 | 51,884.96 | 51,473.30 | 91,990.33 | 96,876.90 | 92,250.88 | 143,509.91 | 143,101.84 | 197,579.74 | 380,588.70 |
Peak read-write performance
| 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, 32 GB | 16 cores, 64 GB | 16 cores, 128 GB | 32 cores, 128 GB | 32 cores, 256 GB | 64 cores, 512 GB | 120 cores, 920 GB |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Read-write QPS | 34,659.68 | 38,909.52 | 90,971.50 | 95,615.19 | 197,093.04 | 198,704.02 | 387,869.61 | 390,841.80 | 380,663.09 | 687,255 | 663,323.67 | 984,014.28 | 2,195,884 |
| Read-write TPS | 1,732.98 | 1,945.48 | 4,548.57 | 4,780.76 | 9,854.65 | 9,935.20 | 19,393.48 | 19,542.09 | 19,033.15 | 34,362.74 | 33,166.17 | 49,200.72 | 109,794.20 |
Peak write performance
| 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, 32 GB | 16 cores, 64 GB | 16 cores, 128 GB | 32 cores, 128 GB | 32 cores, 256 GB | 64 cores, 512 GB | 120 cores, 920 GB |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Write QPS | 23,914.56 | 25,353.92 | 65,187.37 | 63,711.64 | 135,037.31 | 127,477.78 | 231,777.32 | 237,859.68 | 232,331.81 | 381,489.46 | 377,614.51 | 608,817.22 | 879,742.76 |
| Write TPS | 3,985.76 | 4,225.65 | 10,864.56 | 10,618.61 | 22,506.22 | 21,246.30 | 38,629.56 | 39,643.28 | 38,721.97 | 63,581.58 | 62,935.76 | 101,469.57 | 146,623.80 |