On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at Plesk 360 (formerly known as My Plesk) please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

MySQL on the server with Plesk shows the error: Too many open files

Follow

Comments

9 comments

  • Avatar
    Marcio Nunes

    Dont Work! Ubuntu 16

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    @Marcio Nunes

    Hello!
    Please, could you share the details of the issue?
    Did you have trouble with particular step?
    For deeper investigation, I can suggest contacting Plesk Technical Support.

    0
    Comment actions Permalink
  • Avatar
    Arvind Kumar Madhukar

    Dear Respective !

    I'm very glad to say that, the steps you have shared us with on the URL > https://support.plesk.com/hc/en-us/articles/213393029-MySQL-values-open-files-limit-and-max-connections-are-not-applied is perfect.
    But same steps, if i follow on CloudLinux OS it is not giving any error not we are able to see the changes regarding the open_files_limit, it would be very thankful if you could work on this and let us know the way to get resolve this issue.

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Arvind,

    This issue will be investigated in the scope of a ticket.

    0
    Comment actions Permalink
  • Avatar
    Akshay

    Hello Team !

    @Plesk Suport Reply as below.

    I have noticed that the MySQL service changes were not loaded by systemd and therefore not applied:

    # systemctl status mariadb >/dev/null
    Warning: mysqld.service changed on disk. Run 'systemctl daemon-reload' to reload units.

    They were also not synced when the systemctl daemon-reload command was executed. Most likely it is due to the fact that the MariaDB service is a symlink to the MySQL:

    # ls -la /usr/lib/systemd/system/mariadb.service
    lrwxrwxrwx 1 root root 38 Sep 16 01:02 /usr/lib/systemd/system/mariadb.service -> /usr/lib/systemd/system/mysqld.service

    Therefore, I have moved the /usr/lib/systemd/system/mariadb.service.d and /etc/systemd/system/mariadb.service.d directories to /root and created an override using systemctl edit mysql.service command.

    After the override was created, limits were applied and after the MySQL server was restarted, proper limits were active:

    # plesk db "SHOW GLOBAL VARIABLES LIKE 'open_files_limit' \G"
    *************************** 1. row ***************************
    Variable_name: open_files_limit
            Value: 8192
    0
    Comment actions Permalink
  • Avatar
    Akshay

    Our issue was resolved.

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello @Arvind,

    Glad to hear that now it is resolved.

    The resolution may be useful for other Pleskians.

    0
    Comment actions Permalink
  • Avatar
    MarkC (Edited )

    Obsidian 18.0.28 and Debian 8.11 here. Command "systemctl edit" doesn't work:

    systemctl edit mariadb
    Unknown operation 'edit'.

    Probably I need a dist-upgrade.

    0
    Comment actions Permalink
  • Avatar
    Kuzma Ivanov

    Hi MarkC,

    You are right, Debian 8 does not support this option. It has also reached its end-of-life and is no longer supported.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request