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 MySQLOperation GuideAnalysis EnginePerformance White PaperTPC-H Performance Results

TPC-H Performance Results

PDF
Focus Mode
Font Size
Last updated: 2025-10-23 20:50:32
This document describes the TPC-H performance test for the "read-only analysis engine" of TDSQL-C for MySQL.
Note:
The performance of read-only analysis engine instances varies according to different instance specifications. Test results in this document are for reference only. For the test method, refer to TPC-H Test Method.

TPC-H

Test Server
Test Data Set (GB)
M8.8XLARGE256
100

Total Execution Time of Each Version

Test Version
Total Execution Time (Seconds)
4.2506.x
21.1
3.2503.x
26.2
2.2410.x
32.4
1.2404.x
48.8

Performance Results

Version 4.2506.x
Version 3.2503.x
Version 2.2410.x
Version 1.2404.x
Query SQL
Execution Time (Seconds)
Q1
1.4835
Q2
0.1367
Q3
0.97
Q4
0.7345
Q5
0.8532
Q6
0.3157
Q7
0.9577
Q8
0.6849
Q9
3.2775
Q10
1.5327
Q11
0.2592
Q12
0.7715
Q13
1.5745
Q14
0.3711
Q15
0.6806
Q16
0.3806
Q17
0.6324
Q18
2.1682
Q19
0.4825
Q20
0.5684
Q21
2.004
Q22
0.3257
Total
21.1651
Query SQL
Execution Time (Seconds)
Q1
1.6709
Q2
0.1527
Q3
1.2515
Q4
0.9788
Q5
1.0737
Q6
0.3049
Q7
1.1951
Q8
0.8567
Q9
4.3268
Q10
1.5661
Q11
0.2335
Q12
0.8178
Q13
1.9259
Q14
0.4562
Q15
0.7116
Q16
0.3585
Q17
0.8066
Q18
2.8576
Q19
0.6209
Q20
0.8007
Q21
2.9172
Q22
0.3296
Total
26.2133​
Query SQL
Execution Time (Seconds)
Q1
2.7153
Q2
0.1833
Q3
1.725
Q4
1.279
Q5
1.3958
Q6
0.3105
Q7
1.4588
Q8
1.1674
Q9
5.4706
Q10
1.9342
Q11
0.3169
Q12
1.0144
Q13
2.0232
Q14
0.54
Q15
0.7387
Q16
0.4106
Q17
0.9051
Q18
3.078
Q19
0.8404
Q20
1.3684
Q21
3.0853
Q22
0.444
Total
32.4049
Query SQL
Execution Time (Seconds)
Q1
3.66
Q2
0.39
Q3
2.37
Q4
1.53
Q5
2.91
Q6
0.74
Q7
1.99
Q8
1.6
Q9
7.8
Q10
2.81
Q11
0.42
Q12
1.79
Q13
3.32
Q14
1.12
Q15
1.2
Q16
1.18
Q17
1.42
Q18
3.62
Q19
1.74
Q20
1.64
Q21
5.04
Q22
0.51
Total
48.8
Previous Topic: TPC-H Test MethodNext Topic: Monitoring Alarm Best Practices

Help and Support

Was this page helpful?

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

Feedback