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
When we rebooted the machine , MYSQL started working again fine. We have to
fix this problem not to happen again,
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 <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.