How to calculate the table_open_cache value in MySQL?
by Jason.nix from LinuxQuestions.org on (#6ESV0)
Hello,
According to the MySQL documents, the formula is:
Code:MAX(
(open_files_limit - 10 - max_connections) / 2,400
)What is the number of 400? The number in parentheses is divided by 2, but what is the role of the number 400 after that?
Thank you.
According to the MySQL documents, the formula is:
Code:MAX(
(open_files_limit - 10 - max_connections) / 2,400
)What is the number of 400? The number in parentheses is divided by 2, but what is the role of the number 400 after that?
Thank you.