There should be an easy answer but this one had got me stumped. The mariadb.log files indicated mySQL is crashing because of a file limit. Nothing I have done has been able to change that limit. It looks like this: (errno: 24) mysqld: Can't open file I believe it is the 1024 file open limit that is the issue. Or so that is where I am right now on this.
Editing the /etc/security/limits.conf and/or the /etc/my.cnf does nothing. I have tried it all, except apparently the one thing that would work, of which I have no clue what it is. And if on a default install the 1024 limit is set, how come everyone else in the world is not breaking? It can't just be my mySQL servers that break with this file limit right? What am I missing? Am I really on the right track? As far as I can tell the error 24 always means your have a file open limit and it is not large enough.