Killing Threads

The show processlist statement we looked at earlier in this chapter allows us to see what threads are running on a server. This command also tells you the id or unique identifier for each thread. If we have a problematic thread (for example, a query that is taking forever, or a problem user ), we can terminate the thread using

 kill  process_id  ;