RE: Killing a thread -- Urgent

2005-10-16 Thread Sujay Koduri
- 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

Killing a thread -- Urgent

2005-10-15 Thread Sujay Koduri
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)

Re: Killing a thread -- Urgent

2005-10-15 Thread Gleb Paharenko
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

Re: Killing a Thread

2002-05-02 Thread Jeremy Zawodny
On Mon, Apr 29, 2002 at 10:23:25PM -0500, Dave Losen wrote: Greetings, I'm new to the list and apologize if this question has already been answered. I'm trying to figure out how to make a thread die. From the processlist command of mysqladmin I get back a listing of unauthenticated

Killing a Thread

2002-04-29 Thread Dave Losen
Greetings, I'm new to the list and apologize if this question has already been answered. I'm trying to figure out how to make a thread die. From the processlist command of mysqladmin I get back a listing of unauthenticated user that I want to drop from their connection status. I issue

Killing a thread

2002-04-26 Thread Dave Losen
Greetings, I'm new to the list and apologize if this question has already been answered. I'm trying to figure out how to make a thread die. From the processlist command of mysqladmin I get back a listing of unauthenticated user that I want to drop from their connection status. I issue the