The configuration community:
table_cache
Information
The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. You can check whether you need to increase the table cache by checking the Opened_tables status variable. If the value of Opened_tables is large and you do not do FLUSH TABLES often (which just forces all tables to be closed and reopened) then you should increase the value of the table_cache variable. For more information about the table cache see Section
Syntax
Example


