Hi All,
I’m pretty much new in MySQL so hope you guys can guide me. I would like to know what will be the ideal value to be set for open table and open files in mysql. I believe the default value would be 470 for open tables. What criteria do i need to look upon before modifying this value? Basically, the normal open table range in MySQL server would be in the range of 150-200. But last week we receive a high amount of open table in the range of 450- 480. What would be the cause/reason that trigger this scenario. There is no lock or any error in mysql log file. Anyone encounter this scenario what is root cause for the trigger and how can i avoid it.