tencent cloud

This document lists the performance comparison test results between TDSQL-C for MySQL and TencentDB for MySQL in the big dataset scenario.

Big Dataset Scenario Overview

In the big dataset scenario, the entire volume of data cannot be all stored in the cache (the data volume is twice the memory size), and the disk needs to be read and written to update the cache during queries.

Big Dataset Scenario Test Conclusion

• In the read scenario, TDSQL-C for MySQL can achieve a CPU utilization of above 90% on compute nodes. The test shows that the resource utilization of TDSQL-C for MySQL is better than that of TencentDB for MySQL.
• In the write scenario, TDSQL-C for MySQL outperforms TencentDB for MySQL under lower specifications, and as the specifications and data volume increase, its performance advantage gets much greater.

Big Dataset Scenario Test Results

Scenario 1: Write

Scenario 2: Read (POINT SELECT)

Scenario 3: Read (RANGE SELECT)

Scenario 4: Read-write (POINT SELECT)

Scenario 5: Read-write (RANGE SELECT)