tencent cloud

TDSQL Boundless

DokumentasiTDSQL BoundlessGeneral ReferenceDatabase Parameter Descriptiontable_open_cache

table_open_cache

Unduh
Mode fokus
Ukuran font
Terakhir diperbarui: 2026-05-26 16:30:20

Feature Description

table_open_cache specifies the number of open table objects to cache. 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 open simultaneously. When this limit is reached, the system closes the least recently used tables based on the LRU (Least Recently Used) algorithm to free up space for new tables.
When adjusting the table_open_cache parameter, consider the following factors:
Memory limit: Increasing the value of the table_open_cache parameter may consume 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.
Monitoring and tuning: Monitor server performance metrics, such as CPU utilization, memory utilization, and disk I/O, to determine whether to adjust the table_open_cache parameter. If a performance bottleneck is identified, you can try adjusting this 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