MySQL Forums
Forum List  »  Newbie

Open table in MySQL
Posted by: viknesh velu
Date: October 17, 2011 12:39AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Open table in MySQL
October 17, 2011 12:39AM
October 18, 2011 09:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.