Marco 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24) It seems The current process(mysqld?) can't read current environment. #define EMFILE 24 /* Too many open files */
you have to resolve the environment any of resource below.. CPU(dual core/quad core) memory(need more dimm) Disk(buy more disk) If your OS has registry/parameter of extending more open file, change it, or your query must reduce file because of your query is exceeding of file limit. Tsuyoshi Marco mangione さんは書きました: > Hello, > > i have a strange problems appeared 2 week ago'. > During the night with no apparently strange task mysql hang and if i try to > do some query i have as result: > > 1) big timeout... or directly no response > 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24) > to fix the problem i have to reboot the entire server. > > Anyone have some useful information? > > Thanks > Marco > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]