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!