This topic provides the results of online transaction processing (OLTP) performance tests on PolarDB for MySQL 5.7.
Test results of clusters that have the primary node and one read-only node
Note In the preceding query:
- Write QPS indicates the number of SQL requests (including BEGIN, COMMIT, INSERT, UPDATE, and DELETE) that are executed by the database per second.
- Write TPS indicates the number of transactions that are executed by the database per second. A transaction is executed only after it is committed.
For more information about how to test write QPS and write TPS, see Use SysBench to test the write performance.
Test results of clusters that have the primary node and multiple read-only nodes
- The preceding figure shows the test result of read-only queries per second (QPS) when the clusters that are connected by using cluster endpoints are tested.
- The preceding test uses clusters whose node specifications are 4 cores and 16 GB.