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  
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,


I am using the Free version of SPAMfighter <>
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.

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