Hello,
I need to kill a thread. I've issued a command which has locked a table
(delete from table where id = 9) was the command and it is taking a
very very long time.
Now I'd like to kill that thread. However, I can't read the the thread ID
because the ID scrolls out of view in my little
try using mysqladmin with a grep command, or redirect it's output to a
file. something like this should do it.
mysqladmin -u user -p processlist | grep delete deleteprocess.out
then less the file and you will be able to scroll thru the output.
hope this helps..
--shak
Karl J. Stubsjoen
I'd pipe the process list contents to a file, then look at the file via a
text editor
eg.
\T c:\processes.txt
show processlist;
\t
Kelly
try using mysqladmin with a grep command, or redirect it's output to a
file. something like this should do it.
mysqladmin -u user -p processlist | grep