Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Dan Nelson (dnelsonallantgroup.com)
Date: Sun Jan 10 2010 - 22:03:41 CST
In the last episode (Jan 11), Sathish said:
> We have been using MYSQL in our dedicated server for long time without
> problem, Suddenly we noticed an error stating " Can't open file error
> number 24".
> When we rebooted the machine , MYSQL started working again fine. We have
> to fix this problem not to happen again,
> We have
> Opened tables: 18,500
> maximum connection :160
> table_catche : 320
> When I checked for open_files_limit in mysql administrator , it seems to
> be disabled...Do I need to enable that and set the value? or Will it take
> default value 0 and use max connetion* 5 or max connection+table_cache*2 ?
If open_files_limit is currently 0, then your OS won't let you change the
value, and you will have to lower the table_open_cache variable to stay
under whatever the OS limit is. Since Windows is the only OS where
open_files_limit is 0, you might want to try upgrading to MySQL 5.5 which
uses a different method of opening files (5.4 and older could only open 2048
files at once on Windows).
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql