Performance Test Report

Release Notes

Product Announcements

Release Notes and Announcements

Beginner's Guide

Overview

Strengths

Architecture

Product Specifications

Product Feature List

Instance Types

Database Versions

Regions and AZs

Use Cases

Common Concepts

Use Limits

SQL Usage Specifications

Database Permissions and Index Specifications

Suggestions on Usage Specifications

Product Introduction

Kernel Overview

TXSQL Engine Kernel Version Release Notes 

LibraDB Engine Core Version Release Notes

Database Proxy Version Release Notes

Kernel Version Release Notes

Compilation Optimization High-Performance Version

Optimized Kernel Version

Query Cache

Parallel Copy DDL

COS External Table

Column Compression

Exchange Subpartition Template

Buffer Pool Isolation

Nonblocking DDL

Subpartitioning

Automatic Killing of Idle Transactions

Dynamic Thread Pool

NOWAIT

RETURNING

Flashback Query

Functionality Features

Columns Syntax

Correlated Subquery Result Cache

Global Index

Binlog Write Optimization

Large Transaction Binlog Optimization

Binlog Purging Performance Optimization

Optimization of Plan Caching Point Query

Auto-Increment Column Persistence

invisible index

Computation Pushdown

Parallel Initialization of InnoDB Buffer Pool

Performance Features

Database Audit

Security Features

Statement Outline

Hotspot Update Protection

SQL Traffic Throttling

Stability Feature

LibraDB Engine Features

ETL Writeback Acceleration

Ordered Pagination Feature

Database/Table Merge Capability

Analysis Engine Features

Summary of Critical Issues Related to Kernel

purge/rollback of Dual blob Fields Causes Corruption in the Not-Full list of the fseg in the Tablespace

Instant add column Causes rollback Failure After Upgrading to a Later Version When Page Data Occupancy Exceeds 50%

Using Instant Add Column to add beyond the 1024th column causes the system to crash

Performing Instant add column and Online DDL Operations Sequentially on a Table Triggering a crash

Performing Instant drop Followed by Instant add Column for a Column with the Same Name Causes a crash

Instant change column redo Flaw in Buffer Calculation Causes crash

Parallel Replay of Spatial Index redo Logs Causes Instance crash and Failure to Provide Write Services

Inspection and Repair of Kernel Issues

Kernel Features

Billing Overview

Product Pricing

Creating Cluster

Specification Adjustment Description

Renewal

Payment Overdue

Refund

Change from Pay-as-You-Go to Monthly Subscription

Change from Pay-as-You-Go to Serverless Billing

Database Audit Billing Overview

Value-Added Services Billing Overview

Viewing Billing Statements

Purchase Guide

Getting Started

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

Viewing Rule Template List

Creating Rule Template

Modifying Rule Template

Deleting Rule Template

Audit Rule Template

Viewing Audit Task

Authorizing Sub-User to Use Database Audit

Service Features

Elastic Anti-Jitter Capabilities

Notes on Arrears

Serverless Introduction

Creating Serverless Cluster

Creating and Managing a Read-Only Instance

Setting Automatic or Manual Start/Stop

Creating and Managing a Serverless Cluster

Resource Pack Overview

Purchasing Resource Pack

Compute Resource Pack

Storage Resource Pack

Binding and Unbinding Resource Pack

Adjusting Consumption Priority Order

Viewing Resource Pack Usage

Resource Pack Reminder Policy

Modifying Resource Pack Name

Requesting Refund for Resource Pack

Serverless Resource Pack

Overview of Multi-AZ Deployment

Operations Related to Multi-AZ Deployment

Multi-AZ Deployment

Compute Unit

Adjusting Configurations

Configuration Change

Serverless FAQs

Resource Package FAQs

FAQs

Serverless Cost Estimator

Serverless Service

Operation Overview

Switching Cluster Page View in Console

Configuring Server

Configuring Network Address

Connecting to Cluster

Database Connection

Renaming Instance

Modifying Character Set

Modifying the Instance Maintenance Time

Restarting Instance

Deleting Instance

Restoring Instance

Task List

Instance Management

Adjusting Compute Configuration

Adjusting Storage Space

Upgrading Kernel Minor Version

Configuration Adjustment

Overview of Instance Modes

Enabling or Disabling Serverless for a Provisioned Resource Cluster

Converting Provisioned Resource Instances to Serverless Instances

Instance Mode Management

Renaming Cluster

Modifying Cluster Project

Deleting Cluster

Restoring Cluster

Cluster Management

Read-Only Instance Overview

Creating Read-Only Instance

Scaling Instance

Database Proxy Overview

Database Proxy Kernel Features

Managing Database Proxy

Automatic Read/Write Separation

Connection Pool Feature

Other Features

Database Proxy

Account Overview

Console Account

Database Account

Account Management

Creating Database

Modifying Database Account Permission

Deleting Database

Database Management

DMC Overview

DMC Management

Database Management Tool

Introduction

Utilization of Columnar Storage Indexes

Columnar Storage Index (CSI)

Feature Limits and Compatibility

Read-Only Analysis Engine Management

Data Loading

Analysis Cluster Management

Executing Queries

Exclusive Features

Performance Optimization

System Tables

Performance White Paper

Ops Management

Analysis Engine

Parameter Overview

Setting Instance Parameters

Applying Parameter Template

Suggestions on Parameter Configuration

Parameter Formula

Parameter Configuration

Operation Guide

TDSQL-C for MySQL

Query	Non-Parallel Execution Time (s)	16-Thread Parallel Query Time (s)	Acceleration Ratio
Q1	1,376.96	197.25	12.84
Q3	366.33	37.64	9.73
Q4	92.81	6.58	14.1
Q6	283.83	26.05	10.9
Q9	673.87	45.96	14.66
Q12	361.2	35.7	10.12
Q14	65.02	5.7	11.41
Q19	20.55	1.87	11.0

tencent cloud

Standard performance test report