This topic provides the results of online transaction processing (OLTP) performance tests on ApsaraDB PolarDB MySQL-compatible edition 5.7.

Note For more information about test procedures, see OLTP performance tests.

Test results of clusters that have the primary node and one read-only node

  • Figure 1. Read-only performance of different specifications
    1
  • Figure 2. Write-only performance of different specifications
    2
    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.

  • Figure 3. Read-write performance of different specifications
    3

Test results of clusters that have the primary node and multiple read-only nodes

Figure 4. Read-only performance
4
Note
  • 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.