tencent cloud

TDSQL Boundless

Release Notes
Product Introduction
Overview
Scenarios
Product Architecture
Instance Types
Compatibility Notes
Usage specification recommendations
Kernel Features
Kernel Overview
Kernel Version Release Notes
Functionality Features
Performance Features
Billing
Billing Overview
Purchase Method
Pricing Details
Renewal
Overdue Payments
Refund
Getting Started
Creating an Instance
Connect to Instances
User Guide
Data Migration
Data Subscription
Instance Management
Parameter Configuration
Account Management
Security Group
Backup and Restoration
Database Auditing
Tag Management
Use Cases
Technical Evolution and Usage Practices of Online DDL
Lock Mechanism Analysis and Troubleshooting Practices
Data Intelligent Scheduling and Related Practices for Performance Optimization
TDSQL Boundless Selection Guide and Practical Tutorial
Developer Guide
Developer Guide (MySQL Compatibility Mode)
Developer Guide (HBase Compatibility Mode)
Performance Tuning
Performance Tuning Overview
SQL Tuning
DDL Tuning
Performance White Paper
Performance Overview
TPC-C Test
Sysbench Test
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Security Group APIs
Task APIs
Backup APIs
Rollback APIs
Parameter APIs
Database APIs
Data Types
Error Codes
General Reference
System Architecture
SQL Reference
Database Parameter Description
TPC-H benchmark data model reference
Error Code Information
Security and Compliance
FAQs
Agreements
Service Level Agreement
Terms of Service
Privacy Policy
Data Processing And Security Agreement
Contact Us
Glossary
DokumentasiTDSQL BoundlessGeneral ReferenceDatabase Parameter Descriptiontable_open_cache

table_open_cache

PDF
Mode fokus
Ukuran font
Terakhir diperbarui: 2026-03-27 17:55:49

Feature Description

table_open_cache is used to set the number of open cached table objects. When a table is opened, the system stores its structural information in the table cache for reuse in subsequent queries. The value of the table_open_cache parameter indicates the maximum number of tables that can be opened simultaneously. When this limit is reached, the system closes the LRU table based on the LRU algorithm to free up space for new tables.
When adjusting the table_open_cache parameter, you need to consider the following factors:
Memory limit: Increasing the value of the table_open_cache parameter may occupy more memory. Ensure that the server has sufficient memory to accommodate a larger table cache.
Number and frequency of use of tables: Adjust the table_open_cache parameter based on the number and frequency of use of tables in the database. If many tables are in the database and are frequently accessed, the value of the table_open_cache parameter can be increased appropriately.
Monitor and optimize: Monitor server performance metrics such as CPU utilization, memory utilization, and disk I/O to determine whether the table_open_cache parameter needs to be adjusted. If a performance bottleneck is identified, you can try to adjust the parameter to optimize performance.

Attribute Description

Required
Description
Parameter Type
ULONG
Default Value
4294967295
Value Range
1 ~ 4294967295
Effective Scope
GLOBAL
Restart Required
No
Topik sebelumnya: table_definition_cacheTopik selanjutnya: tdsql_auto_increment_batch_size

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan