Gotz, This is due to systemd, it overrules your settings. Add a file to systemd config fixes it: [root at mysql2 ~]# cat /etc/systemd/system/mariadb.service.d/limits.conf [Service] LimitNOFILE=10000 LimitMEMLOCK=10000 On Wed, Apr 29, 2015 at 8:31 AM, Götz Reinicke - IT Koordinator < goetz.reinicke at filmakademie.de> wrote: > Hi, > > 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 > -- > Götz Reinicke > IT-Koordinator > > Tel. +49 7141 969 82 420 > E-Mail goetz.reinicke at filmakademie.de > > Filmakademie Baden-Württemberg GmbH > Akademiehof 10 > 71638 Ludwigsburg > www.filmakademie.de > > Eintragung Amtsgericht Stuttgart HRB 205016 > > Vorsitzender des Aufsichtsrats: Jürgen Walter MdL > Staatssekretär im Ministerium für Wissenschaft, > Forschung und Kunst Baden-Württemberg > > Geschäftsführer: Prof. Thomas Schadt > > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos > > -- Met vriendelijke groeten / With kind regards, Johan Kooijman