ubuntu 16.04 mysql dump too many open files mysql?

Hi

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!