MySQL Bugs: #71643: Mysql automatic unlocking after certain time

Bug #71643	Mysql automatic unlocking after certain time
Submitted:	10 Feb 2014 5:33	Modified:	14 Mar 2014 7:09
Reporter:	Anupam Gupta	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Connection Handling	Severity:	S1 (Critical)
Version:	5.5	OS:	Windows (window server 2008,2003)
Assigned to:		CPU Architecture:	Any
Tags:	locking, MySQL, setting variables

Description:
i am facing issue in client-server communication as the client is locking the server mysql table with write lock.if Due to any network issues the connection breaks, the table remains in locked state. when we try to unlock it from server via"unlock tables" its not working. i have to kill the process id of the connection to resume work.i have to deal with almost 200 client and in this situation all the production is held up.

i want to design a solution for the purpose such that whenever the mysql find the table locked for more than 5 minutes, it automatically unlock the tables.
kindly advice me some server variable setting to solve the purpose

How to repeat:
 server communication as the client is locking the server mysql table and due to any network issues the connection breaks, hence the table is in locked state. when we try to unlock it from server via"unlock tables" its not working. i have to kill the process id of the connection to resume work

Please see if the following help you:

http://dev.mysql.com/doc/refman/5.5/en/bug-reports.html
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_wait_timeout
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_interactive_tim...

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".