You are here
Table open cache too small
Wed, 2015-07-15 06:04 — Shinguz
Table Open Cache (table_open_cache
, old table_cache
) is the number of open tables (Open_tables
) for all threads. 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.
See also MySQL Documentation.
Taxonomy upgrade extras: