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 delete > deleteprocess.out > >then less the file and you will be able to scroll thru the output. > >hope this helps.. > >--shak > >Karl J. Stubsjoen wrote: > >>Hello, >> >>I need to kill a thread. I've issued a command which has locked a table >>(delete from table where id <= 99999) 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 Win98 dos window when I >>issue: Show Processlist. >> >>So, any suggestions? >> >>We are running mysql on a linux server (ver 4.0???) and connect from a >>Win98 >>MySql emulation. >> >>Thanks >> >>Karl >>www.excelbus.com >>..opportunity knocking.. >> >> >>--------------------------------------------------------------------- >>Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail >><[EMAIL PROTECTED]> >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> > >-- > Shakeel Sorathia >Systems Administrator > (626) 660-3502 > > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
