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

2015-05-05 Thread Götz Reinicke - IT Koordinator
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

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

2015-04-30 Thread Götz Reinicke - IT Koordinator
+1 Thanks! That was a little bit confusing at first. Regards . Götz Am 30.04.15 um 04:21 schrieb carlh04...@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

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

2015-04-30 Thread Jegadeesh Kumar
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.reini...@filmakademie.de wrote: +1 Thanks! That was a little bit confusing at first. Regards . Götz Am 30.04.15 um 04:21 schrieb carlh04...@gmail.com: Thank

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

2015-04-29 Thread Todor Petkov
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

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

2015-04-29 Thread Götz Reinicke - IT Koordinator
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

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

2015-04-29 Thread 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=1 LimitMEMLOCK=1 On Wed, Apr 29, 2015 at 8:31 AM, Götz Reinicke - IT Koordinator

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

2015-04-29 Thread 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 carlh04...@gmail.com wrote: Hi Johan, Does systemd also overrule /etc/my.conf? Thx! Carl On Wed, 29 Apr 2015

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

2015-04-29 Thread Carl E. Hartung
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

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

2015-04-29 Thread carlh04426
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.