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
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@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@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@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@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@centos.org http://lists.centos.org/mailman/listinfo/centos
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@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@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@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@centos.org http://lists.centos.org/mailman/listinfo/centos
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@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@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@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@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@centos.org http://lists.centos.org/mailman/listinfo/centos
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
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@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@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@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@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@centos.org http://lists.centos.org/mailman/listinfo/centos
CentOS mailing list CentOS@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@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*.
<...>
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@filmakademie.de> wrote:
+1 Thanks! That was a little bit confusing at first.
Regards . GötzAm 30.04.15 um 04:21 schrieb carlh04426@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@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@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@mysql2 ~]# cat /etc/systemd/system/mariadb.service.d/limits.conf [Service] LimitNOFILE=10000 LimitMEMLOCK=10000
-
Carl E. Hartung -
carlh04426＠gmail.com
-
Götz Reinicke - IT Koordinator -
Jegadeesh Kumar -
Johan Kooijman -
Todor Petkov