Steps to increase open files limits for MariaDB

[kumkumsharma]

The open_files_limit setting can be set via system on CentOS 7 server, for that you have to edit my.cnf file.

First you have to create file and you can check command for that:

/etc/systemd/system/mariadb.service.d/limits.conf

After that you have to add below lines of code in your my.cnf file:

[Service]
LimitNOFILE=40000

Now run below command to restart MariaDB.

systemctl daemon-reload
/scripts/restartsrv_mysql