"David T. Ashley" <com> wrote:
Table locks are released automatically if the connection terminates.
A client connection will be terminated by the following events:
1. when the client closes the connection explicitly
2. when the TCP connection to the server is closed
3. after connect_timeout seconds without any client action
(connect_timeout is configurable in my.cnf, default: 12 hours)
4. when somebody explicitly kills the thread in the MySQL server
In *most* cases the operating system will close the TCP connection(s)
for dying processes. In fact I haven't witnessed other behaviour.
But this may be pure luck.
Axel Schwenke, Senior Software Developer, MySQL AB
Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/