table_definition_cache

Alarm Upgrade

Announcements

Overview

Strengths

TDStore Engine

InnoDB engine

Use Cases

Regions and AZs

Product Features

Instance Architecture

TDStore Engine ﻿

Basic Principles

Product Introduction

Billing Overview (InnoDB)

Product Pricing (InnoDB)

Product Pricing (TDStore)

Purchase and Upgrade

Refund

Payment Overdue

Backup Space Billing

Purchase Guide

Creating an Instance

Connecting to an Instance

Creating Instance

Connecting to Instance

Managing Sharded Table

InnoDB Engine

Getting Started

Renaming Database Instance

Specifying Project for Instance

Isolating/Restoring/Terminating Instances

Adjusting Deployed Node

Changing Instance Specification

Restarting Instance

Instance Management

Disaster Recovery Read-Only Instance

Changing Networks

Creating Account

Modifying Account Permissions

Cloning Account

Configuring Read/Write Separation

Resetting Account Password

Deleting Account

Account Management

Access Management

Security Group Configuration

Transparent Data Encryption (TDE)

Security Management

Slow Query Analysis

Backup Mode

Downloading Backup File

Backup Encryption

Rolling Back Database

Backup and Rollback

Data Migration

Enabling Database Audit

Viewing Audit Logs

Modifying Log Retention Period

Database Audit

Operation Guide（InnoDB）

Import from Standalone Instance to TDSQL Instance

Import Between TDSQL Instances

Selection of TDSQL Instance and Shard Configuration

Practical Tutorial

Platform Security Design

Tenant Security Features

Security White Paper

Usage Instructions

SQL Example

System Tables and System Views

Database Parameter Description

Error Code Information

Use Limits

Compatibility

Connecting Database

Join and Subquery

Sequence

Frequently Used DML Statements

Read/Write Separation

Distributed Transaction

Creating Table

Connection Protection

Globally Unique Field

Exporting/Importing Data

Database Management Statements

Passthrough SQL

Preprocessing

Subpartitioning

Error Codes and Messages

InnoDB

Development Guide

History

Introduction

API Category

AssociateSecurityGroups

DescribeDBSecurityGroups

DescribeProjectSecurityGroups

DisassociateSecurityGroups

ModifyDBInstanceSecurityGroups

Security Group APIs

DescribeBackupFiles

DescribeDBEncryptAttributes

KillSession

ModifyAccountPrivileges

ModifyInstanceNetwork

ModifyDBEncryptAttributes

CreateOnlineDDLJob

Other APIs

Request Structure

Common Params

Signature v3

Signature

Responses

Making API Requests

ActiveHourDCDBInstance

CancelDcnJob

CloneAccount

CloseDBExtranetAccess

CopyAccountPrivileges

CreateAccount

CreateDedicatedClusterDCDBInstance

DeleteAccount

DescribeAccountPrivileges

DescribeAccounts

DescribeDBLogFiles

DescribeDBParameters

DescribeDBSlowLogs

DescribeDBSyncMode

DescribeDBTmpInstances

DescribeDCDBInstanceNodeInfo

DescribeDCDBInstances

DescribeDCDBPrice

DescribeDCDBShards

DescribeDatabaseObjects

DescribeDatabaseTable

DescribeDatabases

DescribeDcnDetail

DescribeFileDownloadUrl

DescribeFlow

DescribeLogFileRetentionPeriod

DescribeOrders

DestroyDCDBInstance

DestroyHourDCDBInstance

GrantAccountPrivileges

InitDCDBInstances

IsolateDedicatedDBInstance

IsolateHourDCDBInstance

ModifyAccountDescription

ModifyDBInstanceName

ModifyDBInstancesProject

ModifyDBParameters

ModifyDBSyncMode

ModifyInstanceVip

ModifyInstanceVport

ResetAccountPassword

SwitchDBInstanceHA

TerminateDedicatedDBInstance

UpgradeDedicatedDCDBInstance

UpgradeHourDCDBInstance

CreateDCDBInstance

CreateHourDCDBInstance

DescribeDCDBInstanceDetail

ModifyAccountConfig

OpenDBExtranetAccess

IsolateDCDBInstance

TDSQL APIs

Data Types

Error Codes

API Documentation

TDStore Engine Related

General

Disk Overuse

IO Metric Exception

FAQs

Performance Comparison Data for Strong Sync

General References

TPC-C Test

Sysbench Test

Performance Test

Glossary

Contact Us

TDSQL for MySQL

 is used to set the number of cached table definition objects. The table definition cache stores metadata (such as column names and data types) of the tables in the database so that this information can be quickly accessed during query execution. When this limit is reached, the system disables the least recently used table definitions based on the least recently used (LRU) algorithm to free up space for new table definitions.

Attribute	Description
Parameter Type	Integer
Default Value	400
Value Range	400-524288
Applicable Scope	GLOBAL
Modifiable or not	Yes
Restart Required or Not	No

tencent cloud

Feature Description

Attribute Description