tencent cloud

Log In Sign Up Free

Detect AI Fraud with Tencent eKYC！Intercept 99%+ Deepfake Attacks!

TDSQL-C for MySQL

Release Notes and Announcements

Announcements

Announcement on Commercial Billing of the Read-Only Analysis Engine

Announcement on Release of New Upgrade Mechanism for Kernel Minor Version

Announcement on Optimization of Instance Storage Capacity, IOPS, and I/O Bandwidth

Announcement on Some APIs with CAM Authentication Integrated

Announcement on Sales Suspension of Some General Specifications

Announcement on Some APIs Integrated with CAM Authentication

Announcement on Some APIs with CAM Authentication Integrated

Announcement on Change of Part of Parameters

Announcement on Update of Database Audit Feature

Announcement on Authentication of a Newly Added API Interface of Database Audit

Announcement on Change of Public Network Linkage

TDSQL-C for MySQL Audit Service Update

Announcement on Supplementary Charge for Clusters with Pay-as-You-Go Storage Billing Mode

Announcement on New APIs Integrated with CAM Permissions

Announcement on the Release of New Version of Database Proxy

Emergency Fix for Certain Monitoring Metrics

Monitoring Metric Optimization

Change to Database Audit Resource ID

Storage Price Adjustment Notification

Beginner's Guide

Product Introduction

Product Specifications

Product Feature List

Database Versions

Regions and AZs

Common Concepts

Suggestions on Usage Specifications

SQL Usage Specifications

Database Permissions and Index Specifications

Kernel Features

Kernel Overview

Kernel Version Release Notes

TXSQL Engine Kernel Version Release Notes

LibraDB Engine Core Version Release Notes

Database Proxy Version Release Notes

Optimized Kernel Version

Compilation Optimization High-Performance Version

Functionality Features

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

Flashback Query

Performance Features

Correlated Subquery Result Cache

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

Security Features

Stability Feature

Statement Outline

Hotspot Update Protection

SQL Traffic Throttling

Analysis Engine Features

LibraDB Engine Features

ETL Writeback Acceleration

Ordered Pagination Feature

Purchase Guide

Billing Overview

Product Pricing

Creating Cluster

Specification Adjustment Description

Payment Overdue

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

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

Value-Added Services Billing Overview

Database Audit Billing Overview

Viewing Billing Statements

Getting Started

Database Audit

Viewing Audit Instance List

Enabling Audit Service

Viewing Audit Logs

Post-Event Alarm Configuration

Modifying Audit Rule

Modifying Audit Service

Disabling Audit Service

Audit Rule Template

Viewing Rule Template List

Creating Rule Template

Modifying Rule Template

Deleting Rule Template

Viewing Audit Task

Authorizing Sub-User to Use Database Audit

Serverless Service

Operation Guide

Operation Overview

Switching Cluster Page View in Console

Database Connection

Configuring Server

Quickly Configuring Linux CVM Instance

Quickly Configuring Windows CVM Instance

Configuring Network Address

Enabling/Disabling Public Network Address

Modifying Private Network Address

Changing Network

Connecting to Cluster

Using the DMC to Connect to the Cluster

Connecting to Cluster at Private or Public Network Address from Linux CVM Instance

Connecting to Cluster at Private or Public Network Address from Windows CVM Instance

Connecting Through CCN

Instance Management

Renaming Instance

Modifying Instance Maintenance Window

Modifying Character Set

Restarting Instance

Deleting Instance

Restoring Instance

Configuration Adjustment

Adjusting Compute Configuration

Adjusting Storage Space

Upgrading Kernel Minor Version

Instance Mode Management

Overview of Instance Modes

Enabling or Disabling Serverless for a Provisioned Resource Cluster

Converting Provisioned Resource Instances to Serverless Instances

Cluster Management

Renaming Cluster

Modifying Cluster Project

Deleting Cluster

Restoring Cluster

Scaling Instance

Read-Only Instance Overview

Creating Read-Only Instance

Database Proxy

Account Management

Account Overview

Console Account

Account Registration

Identity Verification

Database Account

Creating Account

Configuring Custom Password Strength

Granting Sub-User Feature Permissions

Enabling/Disabling Custom Password Strength Feature

Modifying Parameters and Configuring Parameter Sync

Resetting Password

Modifying Account Permission

Modifying Authorized Host Address

Modifying Account Connections

Modifying Account Remarks

Cloning Account

Deleting Account

Database Management

Creating Database

Modifying Database Account Permission

Deleting Database

Database Management Tool

Columnar Storage Index (CSI)

Introduction

Feature Overview

Supported Statements and Restrictions

Utilization of Columnar Storage Indexes

Parameter Configuration and Monitoring Metrics

Performance Test Report

Read-Only Analysis Engine

Feature Limits and Compatibility

Compatibility and Use Limits

Data Loading Limitations

Description of Functions and Operators

Description of Supported Bitwise Operations

Description of Supported Arithmetic

Description of Supported Comparison Operations

Description of Supported Logical Operations

Description of Supported String Functions

Description of Supported Mathematical Operation Functions

Description of Supported Date Functions

Description of Supported Aggregation Functions

Description of Supported Type Conversion Functions

Read-Only Analysis Engine Management

Enabling Read-Only Analysis Engine

Basic Operations Management

Data Loading

Loading Data into the Read-Only Analysis Engine

Viewing the Data Loading Status

Cancelling Data Loading

Executing Queries

Collecting Statistics

SELECT Statement Instructions

CTE Syntax Use Instructions

Window Function Use Instructions

Executing SQL and Viewing Execution Plans

Exclusive Features

ETL Writeback Acceleration

Ordered Pagination Feature

Performance Optimization

Lazy Materialization

Optimizing SQL Execution Through HINT

Runtime Filter Use Instructions

System Variables

Performance White Paper

TPC-H Test Method

TPC-H Performance Results

Parameter Configuration

Parameter Overview

Setting Instance Parameters

Applying Parameter Template

Suggestions on Parameter Configuration

Parameter Formula

Multi-AZ Deployment

Setting Multi-AZ Deployment

Modifying AZ Deployment

Backup and Restoration

Backup and Rollback Overview

Backup and Rollback Fees

Performing Backup

Automatic Backup

Cross-Region Backup

Managing Backup

Downloading and Decompressing Backup

Deleting Backup

Viewing Backup List

Setting Backup Retention Period

Rollback

Restoring Data from Logical Backups

Restoring Data Through Linux

Restoring Data Through the Console

Database/Table-Level Rollback to the Original Cluster

Entire Cluster Rollback to a New Cluster

Restoring Data from Snapshot Backup

Table-level rollback to the original cluster

Database/Table-Level Rollback to a New Cluster

Restoring Entire Cluster to New Cluster

Operation Log

Slow Log Overview

Querying and Downloading Slow Log Details

Data Migration

Migrating with DTS

Migrating with Command Line Tool

Parallel Query

Overview

Supported Statement Scenarios and Restricted Scenarios

Setting Parallel Query

Enabling/Disabling Parallel Query

HINT Statement Control

Viewing Parallel Query

Parallel Query Metrics

Performance Test Report

Database Security and Encryption

Access and Authorization

Authorization Policy Syntax

Authorizable Resource Types

Security Group Management

TencentDB Security Group Management

Creating and Managing TencentDB Security Groups

Modifying/Adding Security Group Rules

Matching Security Group for TencentDB

Encryption

Setting SSL Encryption

Transparent Data Encryption

Monitoring and Alarms

Monitoring

Supported Monitoring Metrics

Viewing Monitoring Data

Viewing Monitoring Data in the Console

Creating Dashboard to View Monitoring Data

Pulling Monitoring Data via TencentCloud API

Alarms

Monitoring Metric Alarm

Alarm Configuration Overview

Setting Alarm Policy

Setting Alarm Notification

Viewing Alarm Records

Event Alarm

Supported Event Types

Setting Event Alarms

Basic SQL Operations

Connecting to TDSQL-C for MySQL Through SCF

Tag

Creating Tag and Binding Resource

Editing and Deleting 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

Database/Table-Level Rollback

Database/Table Rollback by Time Point

Database/Table Rollback by Backup Set

Rolling back Entire Cluster

Solution to High CPU Utilization

How to Authorize Sub-Users to View Monitoring Data

White Paper

Security White Paper

Data Storage Security

Data Communication Security

Disaster Recovery

Performance White Paper

Performance Overview

Test Methods

Test Environment

Test Results

Full Cache Scenario Test Results

Big Dataset Scenario Test Results

1 TB Single Table Scenario Test Results

Troubleshooting

Connection Issues

DMC Console Connection Failure

Private Network Connection Failure

Public Network Connection Failure

CCN Connection Failure

Performance Issues

High CPU Utilization

High Memory Utilization

Excessive Number of Slow Queries

API Documentation

Making API Requests

Request Structure

Billing APIs

InquirePriceCreate

DescribeResourcesByDealName

InquirePriceRenew

Instance APIs

Multi-AZ APIs

SwitchClusterZone

RemoveClusterSlaveZone

ModifyClusterSlaveZone

AddClusterSlaveZone

Account APIs

DescribeAccountPrivileges

ModifyAccountDescription

ModifyAccountHost

ModifyAccountPrivileges

DescribeAccounts

ResetAccountPassword

Audit APIs

OpenAuditService

ModifyAuditService

ModifyAuditRuleTemplates

DescribeAuditRuleWithInstanceIds

DescribeAuditRuleTemplates

DeleteAuditRuleTemplates

CreateAuditRuleTemplate

CloseAuditService

Database Proxy APIs

DescribeProxyNodes

DescribeProxySpecs

DescribeProxies

DescribeSupportProxyVersion

ModifyProxyDesc

ReloadBalanceProxyNode

UpgradeProxyVersion

CreateProxyEndPoint

ModifyProxyRwSplit

Backup and Restoration APIs

ModifyBinlogSaveDays

ModifyBackupConfig

DescribeRollbackTimeRange

DescribeBackupList

DescribeBackupConfig

ModifyBackupName

DescribeBinlogs

DescribeBinlogSaveDays

DescribeBinlogDownloadUrl

DescribeBackupDownloadUrl

Parameter Management APIs

CreateParamTemplate

DeleteParamTemplate

DescribeInstanceParams

DescribeParamTemplateDetail

ModifyInstanceParam

ModifyParamTemplate

ModifyClusterParam

DescribeParamTemplates

DescribeClusterParams

Performance Analysis APIs

DescribeInstanceErrorLogs

ExportInstanceErrorLogs

ExportInstanceSlowQueries

DescribeInstanceSlowQueries

Serverless APIs

ResumeServerless

PauseServerless

ResourcePackage APIs

BindClusterResourcePackages

CreateResourcePackage

DescribeResourcePackageDetail

DescribeResourcePackageSaleSpec

ModifyResourcePackageName

RefundResourcePackage

UnbindClusterResourcePackages

DescribeResourcePackageList

ModifyResourcePackageClusters

Other APIs

CreateClusterDatabase

DeleteClusterDatabase

DescribeClusterDetailDatabases

ModifyClusterDatabase

SwitchClusterVpc

OpenReadOnlyInstanceExclusiveAccess

OpenClusterReadOnlyInstanceGroupAccess

ModifyDBInstanceSecurityGroups

DescribeProjectSecurityGroups

DescribeDBSecurityGroups

FAQs

Purchase and Billing

Compatibility and Format

Connection and Network

Console Operations

Database and Table

Performance and Log

Between TDSQL-C for MySQL and TDSQL for MySQL

Between TDSQL-C for MySQL and TencentDB for MySQL

Service Agreement

Service Level Agreement

Terms of Service

TDSQL-C Policy

Data Privacy and Security Agreement

General References

Standards and Certifications

DocumentationTDSQL-C for MySQLOperation GuideRead-Only Analysis EngineFeature Limits and CompatibilityDescription of Functions and OperatorsDescription of Supported Aggregation Functions

Description of Supported Aggregation Functions

Last updated: 2025-01-09 14:24:58

Description of Supported Aggregation Functions

Last updated: 2025-01-09 14:24:58

Currently, the read-only analysis engine supports most of MySQL's aggregation functions, but there are still limitations and incompatibilities in certain scenarios. This document introduces the list of supported aggregation functions in the read-only analysis engine, and enumerates type restrictions on input parameters. Input parameters and functions not mentioned in the document are not supported.
Supported Aggregation Function Types
count Function
Syntax: count(val)
Supported value types for val: int, bigint, double, decimal, varchar, and char.
sum Function
Syntax: sum(val)
Supported value types for val: int, bigint, double, decimal, varchar, and char.
avg Function
Syntax: avg(val)
Supported value types for val: int, bigint, double, decimal, varchar, and char.
max Function
Syntax: max(val)
Supported value types for val: int, bigint, double, decimal, varchar, and char.
min Function
Syntax: min(val)
Supported value types for val: int, bigint, double, decimal, varchar, and char.
group_concat Function
Syntax: group_concat(val)
Supported value types for val: int, bigint, double, decimal, varchar, and char.
any_value(arg) Function
Syntax: any_value(val)
Supported value types for val: int, bigint, double, decimal, varchar, and char.

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

No

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support

Hong Kong, China

+852 800 906 020 (Toll Free)

United States

+1 844 606 0804 (Toll Free)

United Kingdom

+44 808 196 4551 (Toll Free)

Canada

+1 888 605 7930 (Toll Free)

Australia

+61 1300 986 386 (Toll Free)

EdgeOne hotline

+852 300 80699

More local hotlines coming soon