Starting on October 19, 2021, we will enable 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.
To be prepared for this change and to avoid the need to register during your next ticket submission after the change, we encourage you to create an account here before October 19 using the same email address as your current 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. You will continue to use ZenDesk authentication until we switch over to single-sign-on on October 19th.

MySQL values open_files_limit and max_connections are not applied

Follow

Comments

3 comments

  • Avatar
    nisamudeen plackal

    Ubuntu has moved from Upstart to Systemd  from version 15.04 and no longer respects the limits in /etc/security/limits.conf for system services. These limits now apply only to user sessions.

    The limits for the MySQL service are defined in the Systemd configuration file, which you should copy from its default location into /etc/systemd and then edit the copy.

    sudo cp /lib/systemd/system/mysql.service /etc/systemd/system/
    sudo vim /etc/systemd/system/mysql.service # or your editor of choice

    Add the following lines to the bottom of the file:

    LimitNOFILE=infinity
    LimitMEMLOCK=infinity

    You could also set a numeric limit, eg LimitNOFILE=4096

    Now reload the Systemd configuration with:

    sudo systemctl daemon-reload

    Restart MySQL and it should now obey the max_connections directive.

    0
    Comment actions Permalink
  • Avatar
    Andrey Ivanov

    Hello nisamudeen,

    Thank you for your reply! A section regarding systemd systems was added accordingly.

    0
    Comment actions Permalink
  • Avatar
    sanel kape

    Yes it work,after setting params in /etc/systemd/system/mysql.service ,this is for newer ubuntu versions

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request