Max number of processes opened in mysql

Today, I just learned about the mysql command in the group to view the maximum number of processes opened. Let's take a look at it ~
 
Cat/proc/27095/limits | grep "Max open files"
 
Command to view the maximum number of processes opened in mysql
 
How should we know the pornographic process? Remember the command we just learned a few days ago. Right, it's lsof. This command can be used to view the opened file.
 
[Root @ sor-sys ~] # Lsof | grep mysql | tail
Mysqld 16089 mysql 38u REG 1024 3997735/var/lib/mysql/time_zone.MYI
Mysqld 16089 mysql 39u REG 8, 1 0 3997736/var/lib/mysql/time_zone.MYD
Mysqld 16089 mysql 40u REG 1024 3997744/var/lib/mysql/time_zone_leap_second.MYI
Mysqld 16089 mysql 41u REG 8, 1 0 3997745/var/lib/mysql/time_zone_leap_second.MYD
Mysqld 16089 mysql 42u REG 1024 3997732/var/lib/mysql/time_zone_name.MYI
Mysqld 16089 mysql 43u REG 3997733, 1 0/var/lib/mysql/time_zone_name.MYD
Mysqld 16089 mysql 44u REG 1024 3997738/var/lib/mysql/time_zone_transition.MYI
Mysqld 16089 mysql 45u REG 3997739, 1 0/var/lib/mysql/time_zone_transition.MYD
Mysqld 16089 mysql 46u REG 1024 3997741/var/lib/mysql/time_zone_transition_type.MYI
Mysqld 16089 mysql 47u REG 8, 1 0 3997742/var/lib/mysql/time_zone_transition_type.MYD
 
 
See the green icon. This is the existing process ~
 
Or use the ps-ef | grep mysql Command ~
 
[Root @ sor-sys ~] # Cat/proc/16089/limits | grep files
Max open files 2048 65536 files