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:
After that you have to add below lines of code in your my.cnf file:
Now run below command to restart MariaDB.
First you have to create file and you can check command for that:
Code:
/etc/systemd/system/mariadb.service.d/limits.conf
Code:
[Service]
LimitNOFILE=40000
Code:
systemctl daemon-reload
/scripts/restartsrv_mysql