The Blog

(Errcode: 24 – Too many open files) [23] – Plesk Onyx 17.5.3 and Ubuntu 16.04.2 LTS‬ Posted on

As of MySQL 5.7.7, this is what the documentation recommends for Red Hat Enterprise Linux 7, Oracle Linux 7, CentOS 7, SUSE Linux Enterprise Server 12, Fedora 24 and 25:

https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html

On Ubuntu 16.04 the service is called mysql, not mysqld, so this is what I did:

sudo mkdir /etc/systemd/system/mysql.service.d
sudo vi /etc/systemd/system/mysql.service.d/override.conf
Added this in the new file override.conf:

[Service]
LimitNOFILE=1024 4096

Then restarted the service:

sudo systemctl daemon-reload
sudo systemctl restart mysql

and test it with

cat /proc/$(pgrep mysql)/limits | grep files

This entry was posted in Linux, PLESK. Bookmark the permalink.

Please Post Your Comments & Reviews

Your email address will not be published. Required fields are marked *



CAPTCHA
Change the CAPTCHA codeSpeak the CAPTCHA code