@ MySQL view the maximum number of opened processes @

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|tailmysqld    16089    mysql   38u      REG                8,1     1024    3997735 /var/lib/mysql/mysql/time_zone.MYImysqld    16089    mysql   39u      REG                8,1        0    3997736 /var/lib/mysql/mysql/time_zone.MYDmysqld    16089    mysql   40u      REG                8,1     1024    3997744 /var/lib/mysql/mysql/time_zone_leap_second.MYImysqld    16089     mysql   41u      REG                8,1        0    3997745 /var/lib/mysql/mysql/time_zone_leap_second.MYDmysqld    16089     mysql   42u      REG                8,1     1024    3997732 /var/lib/mysql/mysql/time_zone_name.MYImysqld    16089     mysql   43u      REG                8,1        0    3997733 /var/lib/mysql/mysql/time_zone_name.MYDmysqld    16089     mysql   44u      REG                8,1     1024    3997738 /var/lib/mysql/mysql/time_zone_transition.MYImysqld    16089     mysql   45u      REG                8,1        0    3997739 /var/lib/mysql/mysql/time_zone_transition.MYDmysqld    16089     mysql   46u      REG                8,1     1024    3997741 /var/lib/mysql/mysql/time_zone_transition_type.MYImysqld    16089     mysql   47u      REG                8,1        0    3997742 /var/lib/mysql/mysql/time_zone_transition_type.MYD

See 16089. This is the existing process ~

Or usePS-Ef | grep MySQL Command~

[Root @ sor-sys ~] # Cat/proc/16089/limits | grep files
Max open files 2048 65536 files