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
Performance Test Report
Last updated: 2023-12-12 14:40:17
This document is the Column Store Index (CSI) performance test report of TDSQL-C for MySQL.
Standard Performance Test Report
Data set: TPC-H.
Tested data volume: 100 GB.
Instance specification: 32 cores and 256 GB of memory.
Query: execution time speedup of Q1, Q3, Q6, Q7, Q8, Q9, Q11, Q12, Q14, Q15, and Q19.
Execution Time
Query | Non-CSI (s) | CSI (s) | Speedup |
Q1 | 1419.89 | 738.03 | 1.92 |
Q3 | 427.04 | 203.61 | 2.10 |
Q6 | 310.66 | 23.72 | 13.10 |
Q7 | 1246.7 | 390.99 | 3.19 |
Q8 | 661.36 | 162.96 | 4.06 |
Q9 | 1800 | 1131.23 | 1.59 |
Q11 | 436.65 | 33.93 | 12.87 |
Q12 | 357.25 | 211.42 | 1.69 |
Q14 | 329.48 | 48.19 | 6.84 |
Q15 | 709.06 | 99.90 | 7.10 |
Q19 | 561.56 | 269.04 | 2.09 |
Execution Time Speedup
Conclusion
CSI can improve the query performance by significantly reducing the time consumed by queries.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No