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

Hi,

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

Regards,