Re: mysql/os stuck

2008-07-09 Thread Tsuyoshi Nagata
MarisR さんは書きました: >> 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24) >> to fix the problem i have to reboot the entire server. > > Maybe check out file system consistency, check logs. > Yes. create new partition, and move /var/lib/mysql/ to new partion. It may avoids OS dependent file pro

Re: mysql/os stuck

2008-07-09 Thread MarisR
Marco mangione wrote: 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

Re: mysql/os stuck

2008-07-09 Thread Tsuyoshi Nagata
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 d

mysql/os stuck

2008-07-08 Thread 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