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

Symptoms

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:

 

Cause

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
Symptoms
Cause
Solution
 Solution 1: Start mysqld_safe as root
 Solution 2: Manually Change the Open Files Limit
 /etc/security/limits.conf
 systemd
References


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