Comment 1 for bug 1378657

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

Able to reproduce the same.

[root@centos65 ~]# ps -ef | grep mysql
root 2621 1 0 15:02 pts/1 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/centos65.pid
mysql 2785 2621 4 15:02 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/centos65.pid --socket=/var/lib/mysql/mysql.sock
root 2811 2562 0 15:02 pts/1 00:00:00 grep mysql
[root@centos65 ~]#
[root@centos65 ~]# cat /proc/2785/limits |grep processes
Max processes 7809 unlimited processes
[root@centos65 ~]#

[root@centos65 ~]# cat /etc/security/limits.d/90-nproc.conf | grep nproc
* soft nproc 1024
root soft nproc 3000
root hard nproc unlimited
[root@centos65 ~]#

From another session:

[root@centos65 ~]# service mysql restart
Shutting down MySQL (Percona Server)... SUCCESS!
Starting MySQL (Percona Server). SUCCESS!
[root@centos65 ~]#
[root@centos65 ~]# ps -ef | grep mysql
root 3147 1 0 15:07 pts/2 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/centos65.pid
mysql 3311 3147 3 15:07 pts/2 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/centos65.pid --socket=/var/lib/mysql/mysql.sock
root 3337 3089 0 15:07 pts/2 00:00:00 grep mysql
[root@centos65 ~]#
[root@centos65 ~]#
[root@centos65 ~]# cat /proc/3311/limits |grep processes
Max processes 7809 unlimited processes
[root@centos65 ~]#
[root@centos65 ~]# cat /proc/3147/limits |grep processes
Max processes 3000 unlimited processes
[root@centos65 ~]#

After reboot the server,
[root@centos65 ~]# ps -ef | grep mysql
root 1417 1 0 15:09 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/centos65.pid
mysql 1581 1417 0 15:09 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/centos65.pid --socket=/var/lib/mysql/mysql.sock
root 1903 1885 0 15:11 pts/0 00:00:00 grep mysql
[root@centos65 ~]#
[root@centos65 ~]# cat /proc/1581/limits |grep processes
Max processes 7809 7809 processes
[root@centos65 ~]#
[root@centos65 ~]# cat /proc/1417/limits |grep processes
Max processes 7809 7809 processes
[root@centos65 ~]#