My Oracle Support Banner

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 SEPTEMBER 04, 2023

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:



To view full details, sign in with your My Oracle Support account.

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

In this Document
 Solution 1: Start mysqld_safe as root
 Solution 2: Manually Change the Open Files Limit

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.