open-files-limit / innodb_open_files What is the right setting

This is what I do to get an idea:

sudo yum install lsof

for innodb you should count the *.ibd files

sudo lsof | grep -c “\.ibd$”

for myisam you should count the *.MYD

 

 

Posted in MySQL

Leave a Reply