This topic compares the online transaction processing (OLTP) performance between Archive Database Cluster Edition (X-Engine engine) and Cluster Edition (InnoDB engine) in PolarDB for MySQL 8.0.1.

PolarDB for MySQL Archive Database Cluster Edition uses the storage engine X-Engine that is developed by Alibaba Cloud. X-Engine provides high data compression capabilities. This allows you to store a large amount of archived data at a low cost. Based on the internal best practices of Archive Database, when you store the same amount of data, Archive Database Cluster Edition consumes only one-fifth to one-third of the storage of the InnoDB engine. For more information, see Archive Database Cluster Edition.

  • Archive Database Cluster Edition and Cluster Edition use different engines. To make sure that both engines can achieve the highest performance, different numbers of threads are used to test nodes with the same specifications.
  • For more information about the test, see OLTP performance test tools and methods.

Read-only performance comparison of different specifications

Read-only performance
Note In the preceding test, the range_selects parameter is set to 0 and queries on all the data generated by SysBench are disabled. Therefore, the performance is high.

Write-only performance comparison of different specifications

Write-only performance

Read and write performance comparison of different specifications

Read and write performance