Too many open files mysql

In order to make use of partitioning, mysql requires to be able to have a lot of files open at the same time.

Edit /etc/systemd/system/mysqld.service and increase the limit to whatever you need

# Number of files limit. previously [mysqld_safe] open-file-limit
#LimitNOFILE=16364
LimitNOFILE=99999

comments powered by Disqus

Back to the index

Blog roll

R-bloggers, Debian Weekly

---

Last modified: juli 8, 2020