How to set max_open_files in MariaDB / MySQL in CentOS 7
Set the system wide open file limit:
vi /etc/security/limits.conf
Change/Add the following:
* soft nofile 1024000 * hard nofile 1024000 * soft nproc 10240 * hard nproc 10240
Now do this for /etc/sysctl
vi /etc/sysctl
Add the following
fs.file-max = 1024000
Set the changes
sysctl -w fs.file-max=1024000 sysctl -p # check changes cat /proc/sys/fs/file-max
Set the mysqld.service limit (as settings here will override *.cnf ones)
Set both /etc/systemd/system.conf and /etc/systemd/user.conf
vi /etc/systemd/system.conf vi /etc/systemd/user.conf
Add the following under [Manager] for both: