I got the following problem:
A client connects to the MySQL server from a remote machine and
creates a lock using GET_LOCK() method. Then the client crashes or the
connection crashes (e.g.somebody pulls the cable) - whatever. The
point is that the client does not manage to send any disconnection
message to the server.
The process of the crashed user remains pretty long (I checked it by
calling SHOW PROCESSLIST) and holds the lock.
Is there any way to force the server to check periodically whether
clients are still present and active? Or is there a way to check
wether a client shown in the processes list is really connected and
then kill the invalid processes?
Thanks for help
Greg