List:General Discussion« Previous MessageNext Message »
From:Sathish Date:January 11 2010 1:42am
Subject:Can't open file error number 24
View as plain text  
Hi,
 
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 ?
 
Please advise us,
 
Regards
Sathish

  _____  

I am using the Free version of SPAMfighter <http://www.spamfighter.com/len>
.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 757 of my spam emails to date.
The Professional version does not have this message.


Thread
Can't open file error number 24Sathish11 Jan
  • RE: Can't open file error number 24Neil Aggarwal11 Jan
  • Re: Can't open file error number 24Dan Nelson11 Jan