BestHub
Sign in
Tag

table_open_cache

1 views collected around this technical thread.

Java Tech Enthusiast
Java Tech Enthusiast
Feb 15, 2025 · Databases

Understanding MySQL table_open_cache and Its Impact on DTS Performance

table_open_cache limits the total simultaneously opened tables in MySQL, using a global cache complemented by per‑thread Table_cache instances to reduce lock contention; mis‑sizing this cache—especially when DTS forces many full‑table scans on key‑less tables—can cause latency, memory bloat, and LRU evictions, so monitor Opened_tables and adjust the setting judiciously.

DTSDatabaseMySQL
0 likes · 10 min read
Understanding MySQL table_open_cache and Its Impact on DTS Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 2, 2021 · Databases

How MySQL Adjusts open_files_limit, max_connections, and table_open_cache When System Resources Are Insufficient

This article explains how MySQL, when run by a non‑root user with limited system resources, automatically adjusts the open_files_limit, max_connections, and table_open_cache parameters by calculating required file descriptors, comparing them to system limits, and correcting the configuration values accordingly.

ConfigurationDatabase TuningMySQL
0 likes · 6 min read
How MySQL Adjusts open_files_limit, max_connections, and table_open_cache When System Resources Are Insufficient