The Table Open Cache (table_open_cache
or old name table_cache
) is a cache to store file handles for all threads. The actual value of cache entries can be seen with the global status of open tables (Open_tables
).
Increasing table_open_cache
increases the number of file descriptors (open_files_limit
) that MySQL requires.