From: Dan Nelson Date: August 18 2002 7:00pm Subject: Re: Displaying the real thread PIDs. List-Archive: http://lists.mysql.com/mysql/117486 Message-Id: <20020818190036.GI74231@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii In the last episode (Aug 18), Reid Sutherland said: > Hi everyone, > > 'processlist' displays the current list of mysql threads as seen by > mysql. I'm looking for that same list but in real thread PID form. > Right now I need to be able to tell which thread is which at a system > level. Then I'm able to send a SIGKILL to some problem threads. You cannot send signals to individual threads. Signals are delivered to the process as a whole rather than to a thread. The only way to kill a thread is from within the application itself. Mysql provides the "kill " command for this. -- Dan Nelson dnelson@stripped