maria-discuss team mailing list archive

Thread
Date

Re: nofile and nproc settings for mysql user in /etc/security/limits.conf

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: Reindl Harald <h.reindl@xxxxxxxxxxxxx>
Date: Fri, 30 Dec 2016 13:11:12 +0100
In-reply-to: <CAD7Ssm8ejX2E9PpnoaRe4+SwhqS3TL3m0uw1pq1xK_xqfs2_aw@mail.gmail.com>
Organization: the lounge interactive design
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.5.1



Am 30.12.2016 um 13:06 schrieb Kaushal Shriyan:

What should be the recommended nproc and nofile settings for mariadb or
mysql user in /etc/security/limits.conf or /etc/my.cnf? I am running
CentOS Linux version 6.8

Any help will be highly appreciable

unlimited - the last process you want to be killed on a machine is thedatabase server because it tears down all depending services too

on a modern OS a systemd-unit would have this params while the last oneis for OOM situations since the kernel oom-killer starts with theprocesses with the highets allocated memory which is in most cases thedatabase server


LimitNOFILE=infinity
LimitMEMLOCK=infinity
OOMScoreAdjust=-1000

References

nofile and nproc settings for mysql user in /etc/security/limits.conf
From: Kaushal Shriyan, 2016-12-30