Re: Server just hanging (Copying to tmp table)

[na wu]

I saw the same problem on our production line (Fedora 5 with mysql 5.0.22). While I am reading mysql reference manual about table locking issues(7.3.2), it mentions "Table locking causes problems in cases such as when a thread is waiting because the disk is full and free space needs to become available before the thread can proceed. In this case, all threads that want to access the problem table are also put in a waiting state until more disk space is made available." Although this is not disk full issue, I am wondering if it is possible that one of mysql client who gets mutex is waiting for certain resources, such as file descriptor to open table or other stuff, but can not get it, causing other thread to wait forever?