In this blog, we’ll look at a mystery around setting the open_file_limit variable in MySQL and Percona Server for MySQL.
MySQL Server needs file descriptors to run. It uses them to open new connections, store tables in the cache, create temporary tables to resolve complicated queries and access persistent ones. If mysqld is not able to open new files when needed, it can stop functioning correctly. A common symptom of this issue is error 24: “Too many open files.”
The number of file descriptors
can open simultaneously is defined by the configuration
option. You would expect it to work like any other MySQL Server option: set in the configuration file, …[Read more]