<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="thread-information">
      </a>
      10.14 Examining Server Thread (Process) Information
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="processlist-access.html">
       10.14.1 Accessing the Process List
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="thread-commands.html">
       10.14.2 Thread Command Values
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="general-thread-states.html">
       10.14.3 General Thread States
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="source-thread-states.html">
       10.14.4 Replication Source Thread States
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replica-io-thread-states.html">
       10.14.5 Replication I/O (Receiver) Thread States
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replica-sql-thread-states.html">
       10.14.6 Replication SQL Thread States
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="replica-connection-thread-states.html">
       10.14.7 Replication Connection Thread States
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="mysql-cluster-thread-states.html">
       10.14.8 NDB Cluster Thread States
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="event-scheduler-thread-states.html">
       10.14.9 Event Scheduler Thread States
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045222055360">
  </a>
  <a class="indexterm" name="idm46045222053904">
  </a>
  <a class="indexterm" name="idm46045222052416">
  </a>
  <a class="indexterm" name="idm46045222050928">
  </a>
  <p>
   To ascertain what your MySQL server is doing, it can be helpful to
      examine the process list, which indicates the operations currently
      being performed by the set of threads executing within the server.
      For example:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa84389418"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">PROCESSLIST</span>\G
<span class="token output"><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
     Id<span class="token punctuation">:</span> 5
   User<span class="token punctuation">:</span> event_scheduler
   Host<span class="token punctuation">:</span> localhost
     db<span class="token punctuation">:</span> NULL
Command<span class="token punctuation">:</span> Daemon
   Time<span class="token punctuation">:</span> 2756681
  State<span class="token punctuation">:</span> Waiting on empty queue
   Info<span class="token punctuation">:</span> NULL
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 2. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
     Id<span class="token punctuation">:</span> 20
   User<span class="token punctuation">:</span> me
   Host<span class="token punctuation">:</span> localhost<span class="token punctuation">:</span>52943
     db<span class="token punctuation">:</span> test
Command<span class="token punctuation">:</span> Query
   Time<span class="token punctuation">:</span> 0
  State<span class="token punctuation">:</span> starting
   Info<span class="token punctuation">:</span> SHOW PROCESSLIST</span></code></pre>
  </div>
  <p>
   Threads can be killed with the
   <a class="link" href="kill.html" title="15.7.8.4 KILL Statement">
    <code class="literal">
     KILL
    </code>
   </a>
   statement. See
   <a class="xref" href="kill.html" title="15.7.8.4 KILL Statement">
    Section 15.7.8.4, “KILL Statement”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
