… 10240 mysql hard nofile 40960 mysql soft nproc 10240 mysql hard nproc 40960 I still get [root@security]# cat /proc/31715/limits Limit Soft Limit Hard Limit Units Max processes 1024 385850 processes I put file 91-mysql.conf contents into limits.conf and get…

… those limits aren’t getting picked up because they are set only for the mysql user. Add this to 90-nproc.conf (or some other file in /etc/security/limits.d): root soft nproc…

… the MySQL user, typically by adding a line like this to /etc/security/limits.conf: mysql soft nproc 4096 followed up by a restart of MySQL… /etc/security/limits.conf! So even if you’ve properly adjusted /etc/security/limits.conf and set an explicit limit for nproc greater than 1024 for the “mysql…

… when upgrading to Percona 5.1 – Oracle’s MySQL startup script (at least for MySQL 5.0) sources /etc/sysconfig/mysqld – which… MySQL 5.1 has a different startup script, which does *not* source that script. So then we put the limits in /etc/security/limits.d/99-nproc-mysql.conf, and we ensure via puppet that the file…