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 the database server because it tears down all depending services too
on a modern OS a systemd-unit would have this params while the last one is for OOM situations since the kernel oom-killer starts with the processes with the highets allocated memory which is in most cases the database server
LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
