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

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

On 29/04/2015 09:31 AM, G?tz Reinicke - IT Koordinator
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
Hi,

can you do "lsof|grep mysql" and show us the output?

Regards,

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

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

Hi,

as that example is for maria db, teh oracle mysql rpm dose not ship with
something like

/etc/systemd/system/mysqld.service.d

Can I just create /etc/systemd/system/mysqld.service.d/limits.conf and
than I'm ready to go?

	Thanks for your patience and regards . G?tz

Am 29.04.15 um 14:58 schrieb Johan Kooijman:
> 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


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