TDSQL-C for MySQL
- Release Notes and Announcements
- Announcements
- Product Introduction
- Suggestions on Usage Specifications
- Kernel Features
- Kernel Version Release Notes
- Optimized Kernel Version
- Functionality Features
- Performance Features
- Security Features
- Stability Feature
- Analysis Engine Features
- Purchase Guide
- Value-Added Services Billing Overview
- Database Audit
- Audit Rule Template
- Serverless Service
- Serverless Introduction
- Serverless Resource Pack
- Configuration Change
- Operation Guide
- Database Connection
- Configuring Network Address
- Instance Management
- Configuration Adjustment
- Instance Mode Management
- Cluster Management
- Scaling Instance
- Database Proxy
- Database Proxy Kernel Features
- Managing Database Proxy
- Automatic Read/Write Separation
- Connection Pool Feature
- Other Features
- Account Management
- Console Account
- Database Account
- Configuring Custom Password Strength
- Database Management
- Database Management Tool
- Columnar Storage Index (CSI)
- Utilization of Columnar Storage Indexes
- Read-Only Analysis Engine
- Feature Limits and Compatibility
- Description of Functions and Operators
- Read-Only Analysis Engine Management
- Data Loading
- Executing Queries
- Exclusive Features
- Performance Optimization
- Performance White Paper
- Parameter Configuration
- Multi-AZ Deployment
- Backup and Restoration
- Performing Backup
- Managing Backup
- Rollback
- Restoring Data from Logical Backups
- Restoring Data Through the Console
- Restoring Data from Snapshot Backup
- Data Migration
- Parallel Query
- Setting Parallel Query
- Database Security and Encryption
- Access and Authorization
- Security Group Management
- TencentDB Security Group Management
- Monitoring and Alarms
- Monitoring
- Alarms
- Monitoring Metric Alarm
- Practical Tutorial
- Data Rollback
- Database/Table-Level Rollback
- Rolling back Entire Cluster
- White Paper
- Security White Paper
- Performance White Paper
- Troubleshooting
- Connection Issues
- API Documentation
- Making API Requests
- Instance APIs
- Account APIs
- Audit APIs
- Database Proxy APIs
- Backup and Restoration APIs
- Parameter Management APIs
- Performance Analysis APIs
- Serverless APIs
- ResourcePackage APIs
- Other APIs
- FAQs
- Service Agreement
- TDSQL-C Policy
- General References
Test Environment
Last updated: 2023-11-01 17:28:05
This document describes the environment used for the TDSQL-C for MySQL performance test.
Test Object: TDSQL-C for MySQL
Region/AZ: Beijing - Beijing Zone 6
Client
Client type: CVM
Client specification: S5.4XLARGE32 (Standard S5 with 16 CPU cores and 32 GB memory)
Client operating system: CentOS 7
Number of clients: 2 (one more client is added after the concurrency exceeds 1,000, and so on)
Information of the tested TDSQL-C for MySQL instance:
AZ deployment: Single-AZ
Database version: MySQL 5.7
Parameter template: The default template is used, with the following parameters adjusted:
log_bin=off
thread_handling=pool-of-threads
innodb_log_sync_method=async
Note：
You can't modify the
log_bin and innodb_log_sync_method` parameters. To do so, submit a ticket for assistance.VPC network latency: 0.6 ms
Instance type/specification:
Instance type | Instance specification |
Dedicated | 2-core, 16 GB MEM |
| 4-core, 16 GB MEM |
| 4-core, 32 GB MEM |
| 8-core, 32 GB MEM |
| 8-core, 64 GB MEM |
| 16-core, 64 GB MEM |
| 16-core, 96 GB MEM |
| 16-core, 128 GB MEM |
| 32-core, 128 GB MEM |
| 32-core, 256 GB MEM |
| 64-core, 256 GB MEM |
Test Object: TencentDB for MySQL
Region/AZ: Guangzhou - Guangzhou Zone 6
Client
Client type: CVM
Client specification: S5.4XLARGE32 (Standard S5 with 16 CPU cores and 32 GB memory)
Client operating system: CentOS 7
Number of clients: 2 (one more client is added after the concurrency exceeds 1,000, and so on)
The information of the tested TencentDB for MySQL instance is as follows:
Storage type: Local SSD
AZ deployment: Single-AZ
Database version: MySQL 5.7
Architecture: Two-node
Replication mode: Async replication
Parameter template: High-performance parameter template
VPC network latency: 0.5 ms
Instance type/specification: Same as above
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No