Inandjo Try setting the variable "connection_timeout" to 300 seconds. That way, the mysqld will close the connection automatically.
Set the variable in file "my.cnf". David > -----Original Message----- > From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 16, 2002 9:54 AM > To: [EMAIL PROTECTED] > Subject: killing a hung thread > > > hi, > i'd like to know if there is a way to tell the mysqld to > remove a thread > that has hang, without human intervention. > Let say an update query is fired to the engine, and the > client just freezes > and we have to reboot the machine manually: how can i make > sure that mysqld > will remove that thread from the process list thus freeing > the table locked > during the update?? > > SQLSQL > > > > _________________________________________________________________ > Broadband? Dial-up? Get reliable MSN Internet Access. > http://resourcecenter.msn.com/access/plans/default.asp > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
