This topic provides the test results of online transaction processing (OLTP) performance of PolarDB for MySQL 8.0.2Cluster

In PolarDB for MySQL 8.0.2, parallel query and hash join capabilities are enhanced.
  • Parallel query: Parallel query 2.0 in PolarDB for MySQL 8.0.2 provides comprehensive support for complex analytic queries.
    • A multi-phase execution framework can parse SQL statements into multiple computing operators. Each operator can be distributed to multiple workers for parallel execution. The operators in a worker are efficiently executed in a pipelined manner.
    • Parallelism of all operators is supported.
    • Multiple operator parallelism methods are supported, such as shuffle join, one-phase group aggregation, and cost-based parallelism selection. For more information, see Parallel query.
  • Hash Join: The following hash joins are supported in parallel queries: simple parallel hash joins, parallel hash joins, and shuffle hash joins. For more information, see Hash joins in parallel queries.
Note For more information about the test, see OLTP performance tests.

Dedicated instance family

  • Primary node and a single read-only node
    • Test results of read-only performance of different specificationsRead-only performance of the dedicated instance family
      Note In the preceding test, the range_selects parameter is set to 0 and queries on all the ranges are disabled. Therefore, the performance may be higher than expected.
    • Test results of write-only performance of different specificationsWrite performance of the dedicated instance family
    • Test results of read and write performance of different specificationsRead/write performance of the dedicated instance family
  • Primary node and multiple read-only nodes
    Test results of read-only performancePrimary node and multiple read-only nodes
    Note
    • The preceding figure shows the test results of read-only QPS when the clusters that are connected by using cluster endpoints are tested.
    • In the preceding test, the range_selects parameter is not specified. This indicates that queries on all the ranges are enabled by default.
    • In the preceding test, the specifications of each node are 4 cores and 16 GB.

General-purpose instance family

Primary node and a single read-only node

  • Test results of read-only performance of different specificationsRead-only performance
  • Test results of write-only performance of different specificationsShared write
  • Test results of read and write performance of different specificationsRead/write performance