may be somewon has a working solution and information on that:
I installed the most recent mysql community on a server and do get a lot of “errno: 24 – Too many open files”.
There are suggestions to increase the open_files_limit, change/add that to /etc/security/limits.conf and modify the systemd script by hand.
Depending on how you start mysql (restart, or at systemboot time …)
the limit get set or not.
Question: Is that may be a known bug or something?
And thats mit a question regarding mariadb or mysql.
Regards . Götz