The configuration community:
Search the Site:

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

728x90