MySQL Server: table_open_cache Value is Not the Same as the Value Set In my.cnf on Linux

(Doc ID 1501924.1)

Last updated on APRIL 17, 2018

Applies to:

MySQL Server - Version 4.0 and later
Generic Linux


With table_open_cache configured to a value larger than 400, the value is reduced to 400 after MySQL has been started.

table_open_cache was called table_cache in MySQL 5.0 and earlier.

For example using the following setting in the MySQL configuration file:



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms