Re: Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

Am 01.12.2016 um 08:26 schrieb Götz Reinicke - IT Koordinator:
> it happend again and I can't fix it, may be someone has a working
> solution and information on that:

surely -> man systemd

LimitNOFILE=infinity
LimitMEMLOCK=infinity
OOMScoreAdjust=-1000


> I installed the most recent mysql 5.6 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

/etc/security/limits.conf don't matter
/etc/systemd/system/servicename.service.d/ is your friend

https://www.freedesktop.org/software/systemd/man/systemd-system.conf.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql