PolarDB:Performance of PolarDB for MySQL 5.7 (Cluster Edition)

Dedicated specifications

Scope: Primary node + one read-only node

Tests use sysbench with an incrementally increasing concurrency policy. The load starts at 1 concurrent thread and scales exponentially — 8, 16, 32, 64, 128 — until QPS and TPS stop increasing. At each concurrency level, the test runs until QPS and TPS reach a stable state, then continues for an additional period. The average from that stable period is recorded. The highest peak QPS and TPS across all concurrency levels are the final results.

Read-only scenario

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 scenario

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-only scenario

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