This topic provides the results of online transaction processing (OLTP) performance tests on PolarDB for MySQL 5.6.

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.