Test Environments
Last updated:2025-12-25 09:45:59
This document introduces the performance test environment for TDSQL-C for MySQL.
Test Regions
Chongqing.
Note:
The test Cloud Virtual Machine (CVM) and TDSQL-C for MySQL instances must be in the same Virtual Private Cloud (VPC) network and deployed in the same availability zone (AZ) in the same region, to ensure the validity of the performance test.
Client Information Used for the Test
Category | Description |
Client type | CVM. |
Client specifications | S5.4XLARGE32 (Standard S5; 16 cores and 32 GB). |
Client operating system (OS) | CentOS 7. |
Number of clients | 1 (1 client needs to be added when the number of concurrent threads exceeds 1000, and so on). |
Test Instance Information
Category | Description |
Instance mode | TDSQL-C for MySQL provisioned resource cluster. |
Compute instance configuration | A cluster with only 1 read-write instance is used for read-only, mixed read-write, and write-only performance tests. |
AZ deployment | Single AZ. |
Database version | MySQL 8.0. |
Parameters | 1. The default parameter template is created and used. Set the cluster type to general and the database version to TDSQL-C for MySQL 8.0. 2. After the default parameter template is created, the following parameters are adjusted. 2.1 Set log_bin to off. 2.2 Set thread_handling to pool-of-threads. 2.3 Set innodb_log_sync_method to async. Note: The parameters log_bin and innodb_log_sync_method cannot be directly modified currently. If you need to modify them, submit a ticket for modification. For operations about how to create a parameter template, see Using Parameter Templates. For operations about how to set instance parameters, see Setting Instance Parameters. |
VPC network latency | 0.6 ms. |
Test Instance Type/Specifications
In the case of full cache and large data sets, the test instance type and specifications are shown in the table below.
Instance Type | Instance Specifications |
Exclusive | 2 cores and 4 GB |
| 4 cores and 8 GB |
| 8 cores and 16 GB |
| 8 cores and 32 GB |
| 8 cores and 64 GB |
| 16 cores and 64 GB |
| 16 cores and 96 GB |
| 16 cores and 128 GB |
| 24 cores and 144 GB |
| 32 cores and 128 GB |
| 32 cores and 256 GB |
| 64 cores and 256 GB |
| 64 cores and 512 GB |
| 88 cores and 710 GB |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback