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

2016-12-01 Thread Reindl Harald



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



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

2016-11-30 Thread Götz Reinicke - IT Koordinator
Hi,

it happend again and I can't fix it, may be someone has a working
solution and information on that:

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.

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?

the old topic is here:
http://grokbase.com/t/centos/centos/154x78377b/mysql-5-6-centos-7-and-errno-24-too-many-open-files

Regards . Götz




smime.p7s
Description: S/MIME Cryptographic Signature