Applicable to:
- Plesk for Linux
Symptoms
-
The following error can be seen when checking MySQL/MariaDB status via the
systemctl status mariadbcommand:CONFIG_TEXT: [Warning] Could not increase number of max_open_files to more than 16384 (request: 32335).
-
MySQL/MariaDB performance is very slow.
Cause
Hard limit of the process exceeded the number set for open files limit (16384) in database server configuration files:
CONFIG_TEXT: #Number of files limit
LimitNOFILE=16384
Resolution
-
Connect to the server via SSH
- Find in which exact file the limit is set by executing the following commands:
# egrep -r LimitNOFILE /etc/systemd/system/m*
# egrep -r LimitNOFILE /lib/systemd/system/m*
Note: You are looking for a line that does not have a
#in its beginning. That line contains the configuration that is active. -
Once you find in which file the line
LimitNOFILEis active, edit that file with your favorite command-line text editor and adjust the value:CONFIG_TEXT: LimitNOFILE=32335
- Save the changes and close the file
-
Reload all daemons on the server:
# systemctl daemon-reload
-
Restart the
mariadbormysqlservice:# systemctl restart mariadb
Comments
1 comment
Step 3 is wrong. Founded files says “It's not recommended to modify this file in-place, because it will be overwritten during package upgrades.”
You must go to /etc/systemd/system/mariadb.service.d and create a new file like "custom_limits.conf" and put this in it:
and continue with step 4, 5 and 6.
Step 7: Check its working with:
Please sign in to leave a comment.