CentOS - Apr 2015 - Mysql 5.6, Centos 7 and errno: 24 - Too many open files

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
> >
> 
> 
>

+1 Thanks! That was a little bit confusing at first.

	Regards . G?tz

Am 30.04.15 um 04:21 schrieb carlh04426 at gmail.com:
> 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*.
<...>


-- 
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

we can set ulimt to limit the number of open files

On Thu, Apr 30, 2015 at 3:22 PM, G?tz Reinicke - IT Koordinator <
goetz.reinicke at filmakademie.de> wrote:
> +1 Thanks! That was a little bit confusing at first.
>
>         Regards . G?tz
>
> Am 30.04.15 um 04:21 schrieb carlh04426 at gmail.com:
> > 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*.
> <...>
>
>
> --
> 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
>
>