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 APRIL 17, 2018

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.