tencent cloud

TDSQL-C for MySQL

Release Notes and Announcements
Release Notes
Product Announcements
Beginner's Guide
Product Introduction
Overview
Strengths
Use Cases
Architecture
Product Specifications
Instance Types
Product Feature List
Database Versions
Regions and AZs
Common Concepts
Use Limits
Suggestions on Usage Specifications
Kernel Features
Kernel Overview
Kernel Version Release Notes
Optimized Kernel Version
Functionality Features
Performance Features
Security Features
Stability Feature
Analysis Engine Features
Inspection and Repair of Kernel Issues
Purchase Guide
Billing Overview
Product Pricing
Creating Cluster
Specification Adjustment Description
Renewal
Payment Overdue
Refund
Change from Pay-as-You-Go to Yearly/Monthly Subscription
Change from Pay-as-You-Go to Serverless Billing
Value-Added Services Billing Overview
Viewing Billing Statements
Getting Started
Database Audit
Overview
Viewing Audit Instance List
Enabling Audit Service
Viewing Audit Logs
Log Shipping
Post-Event Alarm Configuration
Modifying Audit Rule
Modifying Audit Service
Disabling Audit Service
Audit Rule Template
Viewing Audit Task
Authorizing Sub-User to Use Database Audit
Serverless Service
Serverless Introduction
Creating and Managing a Serverless Cluster
Elastic Scaling Management Tool
Serverless Resource Pack
Multi-AZ Deployment
Configuration Change
FAQs
Serverless Cost Estimator
Operation Guide
Operation Overview
Switching Cluster Page View in Console
Database Connection
Instance Management
Configuration Adjustment
Instance Mode Management
Cluster Management
Scaling Instance
Database Proxy
Account Management
Database Management
Database Management Tool
Parameter Configuration
Multi-AZ Deployment
GD
Backup and Restoration
Operation Log
Data Migration
Parallel Query
Columnar Storage Index (CSI)
Analysis Engine
Database Security and Encryption
Monitoring and Alarms
Basic SQL Operations
Connecting to TDSQL-C for MySQL Through SCF
Tag
Practical Tutorial
Classified Protection Practice for Database Audit of TDSQL-C for MySQL
Upgrading Database Version from MySQL 5.7 to 8.0 Through DTS
Usage Instructions for TDSQL-C MySQL
New Version of Console
Implementing Multiple RO Groups with Multiple Database Proxy Connection Addresses
Strengths of Database Proxy
Selecting Billing Mode for Storage Space
Creating Remote Disaster Recovery by DTS
Creating VPC for Cluster
Data Rollback
Solution to High CPU Utilization
How to Authorize Sub-Users to View Monitoring Data
White Paper
Security White Paper
Performance White Paper
Troubleshooting
Connection Issues
Performance Issues
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Multi-Availability Zone APIs
Other APIs
Audit APIs
Database Proxy APIs
Backup and Recovery APIs
Parameter Management APIs
Billing APIs
serverless APIs
Resource Package APIs
Account APIs
Performance Analysis APIs
Data Types
Error Codes
FAQs
Basic Concepts
Purchase and Billing
Compatibility and Format
Connection and Network
Features
Console Operations
Database and Table
Performance and Log
Database Audit
Between TDSQL-C for MySQL and TencentDB for MySQL
Service Agreement
Service Level Agreement
Terms of Service
TDSQL-C Policy
Privacy Policy
Data Privacy and Security Agreement
General References
Standards and Certifications
Glossary
Contact Us
DocumentationTDSQL-C for MySQLWhite PaperPerformance White PaperTest ResultsTest Results for the Compilation-Optimized High-Performance VersionTest Results for Full Cache

Test Results for Full Cache

PDF
Focus Mode
Font Size
Last updated: 2025-12-25 09:45:59
This document introduces the performance test results for the compilation-optimized high-performance version of TDSQL-C for MySQL in read-only, mixed read-write, and write-only scenarios where the data set characteristic is full cache.

Definition of Full Cache

The full cache scenarios refer to the situations where all data can be stored in the cache, and disk read and write operations are not required during queries to update the cache.

Test Scenarios and Read Types for Full Cache

Data Set Characteristic
Test Scenario
Read Type
Full cache
Read-only
range select
point select
Mixed read-write
range select
point select
Write-Only
-

Test Results for Full Cache

Scenario 1: Read-Only (range select)


Specifications
Concurrency
Data Volume of a Single Table (table_size)
Total Number of Tables (tables)
QPS
2 cores and 4 GB
64
25000
250
67157.12
4 cores and 8 GB
256
25000
250
81927.78
8 cores and 16 GB
128
25000
250
147508.78
8 cores and 32 GB
64
25000
250
134830.77
8 cores and 64 GB
256
25000
250
162284.55
16 cores and 64 GB
128
25000
250
253569.63
16 cores and 96 GB
64
25000
250
275680.14
16 cores and 128 GB
128
25000
250
279237.14
24 cores and 144 GB
128
25000
250
359549.06
32 cores and 128 GB
128
25000
250
469481.46
32 cores and 256 GB
128
25000
250
472481.46
64 cores and 256 GB
512
25000
250
705204.1
64 cores and 512 GB
512
25000
250
705300.08
88 cores and 710 GB
32
25000
250
1288237.1

Scenario 2: Read-Only (point select)


Specifications
Concurrency
Data Volume of a Single Table (table_size)
Total Number of Tables (tables)
QPS
2 cores and 4 GB
64
25000
250
103964.29
4 cores and 8 GB
64
25000
250
160432.69
8 cores and 16 GB
64
25000
250
313895.43
8 cores and 32 GB
128
25000
250
312152.46
8 cores and 64 GB
256
25000
250
307095.12
16 cores and 64 GB
128
25000
250
540219.2
16 cores and 96 GB
128
25000
250
553683.3
16 cores and 128 GB
128
25000
250
557387.48
24 cores and 144 GB
256
25000
250
710764.8
32 cores and 128 GB
256
25000
250
921266.52
32 cores and 256 GB
256
25000
250
931116.61
64 cores and 256 GB
512
25000
250
1309731.39
64 cores and 512 GB
512
25000
250
1312190.48
88 cores and 710 GB
1024
25000
250
2124814.89

Scenario 3: Mixed Read-Write (range select)


Specifications
Concurrency
Data Volume of a Single Table (table_size)
Total Number of Tables (tables)
QPS
2 cores and 4 GB
64
25000
250
37582.98
4 cores and 8 GB
128
25000
250
63166.51
8 cores and 16 GB
256
25000
250
130589.07
8 cores and 32 GB
512
25000
250
123553.3
8 cores and 64 GB
128
25000
250
121701.75
16 cores and 64 GB
128
25000
250
226725.64
16 cores and 96 GB
256
25000
250
243116.35
16 cores and 128 GB
128
25000
250
243274.76
24 cores and 144 GB
256
25000
250
333815.28
32 cores and 128 GB
256
25000
250
451024.89
32 cores and 256 GB
256
25000
250
451392.99
64 cores and 256 GB
256
25000
250
670782.75
64 cores and 512 GB
256
25000
250
674722.87
88 cores and 710 GB
256
25000
250
978395.67

Scenario 4: Mixed Read-Write (point select)


Specifications
Concurrency
Data Volume of a Single Table (table_size)
Total Number of Tables (tables)
QPS
2 cores and 4 GB
64
25000
250
50761.78
4 cores and 8 GB
64
25000
250
107002.71
8 cores and 16 GB
128
25000
250
207201.66
8 cores and 32 GB
256
25000
250
203370.75
8 cores and 64 GB
256
25000
250
203891.75
16 cores and 64 GB
256
25000
250
348399.43
16 cores and 96 GB
256
25000
250
360603.45
16 cores and 128 GB
128
25000
250
370570.5
24 cores and 144 GB
256
25000
250
460349.45
32 cores and 128 GB
256
25000
250
604026.95
32 cores and 256 GB
256
25000
250
610779.6
64 cores and 256 GB
256
25000
250
757522.73
64 cores and 512 GB
256
25000
250
787119.57
88 cores and 710 GB
512
25000
250
1090329.43

Scenario 5: Write-Only


Specifications
Concurrency
Data Volume of a Single Table (table_size)
Total Number of Tables (tables)
QPS
2 cores and 4 GB
128
25000
250
40182.79
4 cores and 8 GB
128
25000
250
85121.39
8 cores and 16 GB
128
25000
250
155333.32
8 cores and 32 GB
128
25000
250
159027.87
8 cores and 64 GB
128
25000
250
147361.41
16 cores and 64 GB
128
25000
250
261582.62
16 cores and 96 GB
128
25000
250
265005.32
16 cores and 128 GB
128
25000
250
333482.98
24 cores and 144 GB
1024
25000
250
338179.58
32 cores and 128 GB
1024
25000
250
430672.91
32 cores and 256 GB
1024
25000
250
434778.25
64 cores and 256 GB
1024
25000
250
551520.53
64 cores and 512 GB
1024
25000
250
558780.8
88 cores and 710 GB
1500
25000
250
643965.01
Previous Topic: Test Results for Large Data SetsNext Topic: Test Results for Large Data Sets

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback