Articles in this section

See more

MySQL error on the server with Plesk: Could not increase number of max_open_files to more than 16384

Avatar
Dinara Tsydenova
Updated
Follow
Plesk for Linux kb: technical ABT: Group B

Applicable to:

  • Plesk for Linux

Symptoms

  • The following error can be seen when checking MariaDB status:

    # systemctl status mariadb
    MySQL error: Could not increase number of max_open_files to more than 16384 (request: 32335).

  • MySQL/MariaDB performance is slow.

Cause

Hard limit of the process exceeded the number set for open files limit (16384) in /etc/systemd/system/mysqld.service:

CONFIG_TEXT: #Number of files limit
LimitNOFILE=16384

Resolution

  1. Connect to the server via SSH.

  2. Edit file /etc/systemd/system/mysqld.service :

  3. Change the line LimitNOFILE as follows:

    CONFIG_TEXT: LimitNOFILE=32335

  4. Reload daemons:

    # systemctl daemon-reload

  5. Restart mariadb service:

    # systemctl restart mariadb

Comments

2 comments

Sort by Date Votes
  • Avatar
    Curtis Maurand

    followed the procedure. file limit is still at 4185

    0
    Comment actions Permalink
  • Avatar
    Curtis Maurand

    I had to add to the [mysqld] section of the mariadb-server.cnf

    open_files_limit=<your desired limit>

    I used 8192 to be conservative.  the default is 4185.  systemd simply starts mysqld

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles