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