[mdlug] mariadb open_files_limit

[Brian Brodsky]

At the meeting I mentioned the mariadb website had caused me grief. The
actual link is
https://mariadb.com/kb/en/mariadb/server-system-variables/#open_files_limit

Which contains the text:

open_files_limit

Description: The number of file descriptors available to mysqld.
Increase if you are getting the Too many open files error. If set to 0,
then mysqld will reserve max_connections*5 or max_connections +
table_open_cache*2 (whichever is larger) number of files. Note that
MariaDB cannot set this to exceed the hard limit imposed by the
operating system, and you may need to change this. For example, by
adding the following lines to /etc/security/limits.conf
mysql soft nofile 65535
mysql hard nofile 65535
rebooting, and then create
/etc/systemd/system/mysqld.service.d/filelimit.conf or
/etc/systemd/system/mariadb.service.d/filelimit.conf (corresponding to
the service name).

[service]
LimitNOFILE=infinity


The [service] needs to be [Service]

It was suggested that I tell them about the issue. I see at the bottom
the page comments, but no way to add any. I did follow the contact us
link and psent a message that way. Have no clue who will see it.

The only change I did was to create the file
/etc/systemd/system/mariadb.service.d/filelimit.conf with this content:

[Service]
LimitNOFILE=8192