ubuntu 16.04 mysql dump too many open files mysql?

20/02/201920/02/2019 paranoids Computer

In my case it was a process limitation of systemd. The mysql config my.cnf was correctly setup. (open_files_limit)
Just run the following commands:

systemctl edit mysql.service

[Service]
LimitNOFILE=infinity

systemctl daemon-reload

systemctl restart mysql

Have fun!