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
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