3 messages in com.mysql.lists.mysqlre: killing a hung thread
FromSent OnAttachments
Inandjo TaurelOct 16, 2002 9:53 am 
Lopez David E-r9374cOct 16, 2002 1:25 pm 
Egor EgorovOct 19, 2002 3:34 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:re: killing a hung threadActions
From:Egor Egorov (egor@ensita.net)
Date:Oct 19, 2002 3:34:38 am
List:com.mysql.lists.mysql

Inandjo, Wednesday, October 16, 2002, 7:54:03 PM, you wrote:

IT> i'd like to know if there is a way to tell the mysqld to remove a thread IT> that has hang, without human intervention. IT> Let say an update query is fired to the engine, and the client just freezes IT> and we have to reboot the machine manually: how can i make sure that mysqld IT> will remove that thread from the process list thus freeing the table locked IT> during the update??

Take a look at KILL command: http://www.mysql.com/doc/en/KILL.html