Test Environment
Last updated: 2025-12-10 14:30:52
This article introduces the environment used for TDSQL-C for MySQL performance testing.
Test Region
Chongqing.
Note:
The tested CVM and TDSQL-C for MySQL must be in the same region, same AZ, and same VPC network to ensure the validity of the performance test.
Client Information Used in the Test
Category | Description |
Client type | CVM. |
Client Specifications | S5.4XLARGE32 (Standard S5, 16 cores 32GB). |
Client Operating System | CentOS 7. |
Number of clients | One (when concurrent connections exceed 1000, add one client, and so on). |
Information of the Test Instance
Category | Description |
Instance Mode | TDSQL-C for MySQL pre-configured cluster of resources. |
Configuration of the compute instance | Read-only, mixed read-write, and write-only performance tests use a cluster with only one read-write instance. |
status of AZ deployment | Single AZ. |
Database version | MySQL 8.0 |
Parameter configuration | 1. Create and use the default parameter template: select the cluster type as General, select the database version as TDSQL-C for MySQL 8.0. 2. After default creation, adjust the following parameters. 2.1 Set log_bin=off. 2.2 Set thread_handling=pool-of-threads. 2.3 innodb_log_sync_method=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 to have them modified. For the operation of creating a parameter template, see Using Parameter Templates. For the procedure to set instance parameters, see Setting Instance Parameters. |
latency of the VPC network | 0.6ms. |
Testing the Instance Type/Specification
In the case of full caching and large datasets, the instance types and specifications used in the tests are shown in the table below.
Instance Type | Instance Specification |
Exclusive | 2-core 4 GB |
| 4-core 8 GB |
| 8-core 16 GB |
| 8-core 32 GB |
| 8-core 64 GB |
| 16-core 64 GB |
| 16-core 96 GB |
| 16-core 128 GB |
| 24-core 144 GB |
| 32-core 128 GB |
| 32-core 256 GB |
| 64-core 256 GB |
| 64-core 512 GB |
| 88-core 710 GB |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback