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.
