You are here
Table open cache too small
Wed, 2015-07-15 06:04 — Shinguz
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.
You can check whether you need to increase the Table Open Cache by checking Open_tables
and Opened_tables
. If the value of Opened_tables
is large and you do not use FLUSH TABLES
often (which just forces all tables to be closed and reopened), then you should increase the value of the table_open_cache
variable.
For further information consult MariaDB and MySQL documentation or the following article.