ssage-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 16, 2005 12:53 AM
To: mysql@lists.mysql.com
Subject: Re: Killing a thread -- Urgent
Hello.
Do you have other queries which are running at this moment on the server?
The show-processlist.html says that thread could
Hello.
Do you have other queries which are running at this moment
on the server? The show-processlist.html says that thread
could be in Killed state if it is locked by another thread.
What version of MySQL do you use? What storage engine does your
table have?
Sujay Koduri <[EMAIL PRO
hi all..
I started a select count(1) command on a table in mysql, assuming it will
end soon within the off peak time..
But now the peak load time is about to start, so i tried to kill that
query..
logged into mysql as root.
show processlist for getting the thread id.
kill 85300 (thrad_id)
Aft
