This article experimentally demonstrates how MySQL's table cache works, showing that it reduces file‑system reads of table definition files, operates per thread, and explains the recommended table_open_cache sizing formula based on concurrency and join complexity.
This article examines how MySQL's FLUSH TABLE WITH READ LOCK command can cause blocking, detailing two cases where global read locks or table cache flushes stall other operations, explaining the underlying MDL lock mechanisms, table cache handling, and providing code examples and debugging insights.
This article examines MySQL bug #89126, explains how creating many tables can overflow the InnoDB table definition cache and cause crashes, illustrates the underlying mechanism with diagrams, and provides configuration advice to prevent the issue.
This guide explains the meaning of MySQL's Open_tables and Opened_tables status variables, shows how to check them, and provides recommended ratios and steps to adjust the table_cache setting for better database performance.
