Max number of opened processes in mysql _ MySQL

View the maximum number of opened processes in mysql bitsCN.com. today, I am in the group and just know the command for viewing the maximum number of opened processes in mysql. 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

BitsCN.com