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:inan...@hotmail.com]
Sent: Wednesday, October 16, 2002 9:54 AM
To: mys...@lists.mysql.com
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
To request this thread, e-mail <mysq...@lists.mysql.com>
To unsubscribe, e-mail
<mysql-unsubscribe-r9374c=moto...@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3 messages in com.mysql.lists.mysqlRE: killing a hung thread
