Fix MySQL "[ERROR] Error in accept: Too many open files" on start on Debian

fix_mysql_too_many_fiels.md

Fix MySQL "[ERROR] Error in accept: Too many open files" on start

Check system limtis

cat /proc/$(cat /var/run/mysqld/mysqld.pid)/limits

Update system limits

$ vim /etc/security/limits.conf

mysql soft nofile 65535
mysql hard nofile 65535

$ reboot

$ mkdir -p /etc/systemd/system/mysql.service.d/
$ vim /etc/systemd/system/mysql.service.d/limits.conf

[Service]
LimitNOFILE=infinity

$ systemctl daemon-reload
$ /etc/init.d/mysql restart

Check system limtis again

cat /proc/$(cat /var/run/mysqld/mysqld.pid)/limits

References

• https://talk.plesk.com/threads/debian-8-6-jessie-plesk-12-5-30-problem-mariadb-error-error-in-accept-too-many-open-files.339290/