[CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files

[Johan Kooijman]

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
>



-- 
Met vriendelijke groeten / With kind regards,
Johan Kooijman