Götz Reinicke - IT Koordinator
2015-Apr-29 06:31 UTC
[CentOS] 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
Todor Petkov
2015-Apr-29 10:28 UTC
[CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files
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 SchadtHi, can you do "lsof|grep mysql" and show us the output? Regards,
Johan Kooijman
2015-Apr-29 12:58 UTC
[CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files
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
Carl E. Hartung
2015-Apr-29 13:22 UTC
[CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files
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 > > > > > >
Götz Reinicke - IT Koordinator
2015-May-05 12:49 UTC
[CentOS] Mysql 5.6, Centos 7 and errno: 24 - Too many open files
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