Thank you for clarifying this, Johan. Very much appreciated! On Wed, 29 Apr 2015 22:28:00 +0200 Johan Kooijman wrote: > Carl, > > By default my.cnf has to obey the OS limits, so in this case the > order is: systemd > /etc/security/limits* > /etc/my*. > > On Wed, Apr 29, 2015 at 3:22 PM, Carl E. Hartung > <carlh04426 at gmail.com> wrote: > > > Hi Johan, > > > > Does systemd also overrule /etc/my.conf? > > > > Thx! > > > > Carl > > > > On Wed, 29 Apr 2015 14:58:52 +0200 > > Johan Kooijman wrote: > > > > > 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 > > > > > > > > > > > > > > > > > > _______________________________________________ > > CentOS mailing list > > CentOS at centos.org > > http://lists.centos.org/mailman/listinfo/centos > > > > >