Re: Server hangs on get_lock

2007-09-01 Thread Niklas Westerberg
The application is supposed to disregard any failure to acquire the lock. The return value isn't even checked inside the application. There is no loop in which we attempt the acquire the lock. The only intention is to wait for a maximum of 10 seconds for the lock to be relased, and if that fails, s

Server hangs on get_lock

2007-08-31 Thread Niklas Westerberg
Hello, We seem to have a problem with the usage of GET_LOCK on our mysql server. Is there anyone who has experienced similar behavior, or could provide some insight into what is going on? /Niklas Symptoms: * mysqld CPU-usage is 100% * Queries of the type GET_LOCK('lock_name', 10); seems to abound