<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="thread-commands">
      </a>
      10.14.2 Thread Command Values
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045221954704">
  </a>
  <p>
   A thread can have any of the following
   <code class="literal">
    Command
   </code>
   values:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221951680">
      </a>
      <a class="indexterm" name="idm46045221950192">
      </a>
      <code class="literal">
       Binlog Dump
      </code>
     </p>
     <p>
      This is a thread on a replication source for sending binary
            log contents to a replica.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221946720">
      </a>
      <a class="indexterm" name="idm46045221945232">
      </a>
      <code class="literal">
       Change user
      </code>
     </p>
     <p>
      The thread is executing a change user operation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221941808">
      </a>
      <a class="indexterm" name="idm46045221940320">
      </a>
      <code class="literal">
       Close stmt
      </code>
     </p>
     <p>
      The thread is closing a prepared statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221936912">
      </a>
      <a class="indexterm" name="idm46045221935424">
      </a>
      <code class="literal">
       Connect
      </code>
     </p>
     <p>
      Used by replication receiver threads connected to the
            source, and by replication worker threads.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221931952">
      </a>
      <a class="indexterm" name="idm46045221930464">
      </a>
      <code class="literal">
       Connect Out
      </code>
     </p>
     <p>
      A replica is connecting to its source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221927056">
      </a>
      <a class="indexterm" name="idm46045221925568">
      </a>
      <code class="literal">
       Create DB
      </code>
     </p>
     <p>
      The thread is executing a create database operation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221922144">
      </a>
      <a class="indexterm" name="idm46045221920656">
      </a>
      <code class="literal">
       Daemon
      </code>
     </p>
     <p>
      This thread is internal to the server, not a thread that
            services a client connection.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221917184">
      </a>
      <a class="indexterm" name="idm46045221915696">
      </a>
      <code class="literal">
       Debug
      </code>
     </p>
     <p>
      The thread is generating debugging information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221912288">
      </a>
      <a class="indexterm" name="idm46045221910800">
      </a>
      <code class="literal">
       Delayed insert
      </code>
     </p>
     <p>
      The thread is a delayed insert handler.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221907392">
      </a>
      <a class="indexterm" name="idm46045221905904">
      </a>
      <code class="literal">
       Drop DB
      </code>
     </p>
     <p>
      The thread is executing a drop database operation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221902480">
      </a>
      <a class="indexterm" name="idm46045221900992">
      </a>
      <code class="literal">
       Error
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221898048">
      </a>
      <a class="indexterm" name="idm46045221896560">
      </a>
      <code class="literal">
       Execute
      </code>
     </p>
     <p>
      The thread is executing a prepared statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221893152">
      </a>
      <a class="indexterm" name="idm46045221891664">
      </a>
      <code class="literal">
       Fetch
      </code>
     </p>
     <p>
      The thread is fetching the results from executing a prepared
            statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221888208">
      </a>
      <a class="indexterm" name="idm46045221886720">
      </a>
      <code class="literal">
       Field List
      </code>
     </p>
     <p>
      The thread is retrieving information for table columns.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221883296">
      </a>
      <a class="indexterm" name="idm46045221881808">
      </a>
      <code class="literal">
       Init DB
      </code>
     </p>
     <p>
      The thread is selecting a default database.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221878400">
      </a>
      <a class="indexterm" name="idm46045221876912">
      </a>
      <code class="literal">
       Kill
      </code>
     </p>
     <p>
      The thread is killing another thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221873504">
      </a>
      <a class="indexterm" name="idm46045221872016">
      </a>
      <code class="literal">
       Long Data
      </code>
     </p>
     <p>
      The thread is retrieving long data in the result of
            executing a prepared statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221868560">
      </a>
      <a class="indexterm" name="idm46045221867072">
      </a>
      <code class="literal">
       Ping
      </code>
     </p>
     <p>
      The thread is handling a server ping request.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221863664">
      </a>
      <a class="indexterm" name="idm46045221862176">
      </a>
      <code class="literal">
       Prepare
      </code>
     </p>
     <p>
      The thread is preparing a prepared statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221858768">
      </a>
      <a class="indexterm" name="idm46045221857280">
      </a>
      <code class="literal">
       Processlist
      </code>
     </p>
     <p>
      The thread is producing information about server threads.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221853856">
      </a>
      <a class="indexterm" name="idm46045221852368">
      </a>
      <code class="literal">
       Query
      </code>
     </p>
     <p>
      Employed for user clients while executing queries by
            single-threaded replication applier threads, as well as by
            the replication coordinator thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221848832">
      </a>
      <a class="indexterm" name="idm46045221847344">
      </a>
      <code class="literal">
       Quit
      </code>
     </p>
     <p>
      The thread is terminating.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221843952">
      </a>
      <a class="indexterm" name="idm46045221842464">
      </a>
      <code class="literal">
       Refresh
      </code>
     </p>
     <p>
      The thread is flushing table, logs, or caches, or resetting
            status variable or replication server information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221838976">
      </a>
      <a class="indexterm" name="idm46045221837488">
      </a>
      <code class="literal">
       Register Slave
      </code>
     </p>
     <p>
      The thread is registering a replica server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221834080">
      </a>
      <a class="indexterm" name="idm46045221832592">
      </a>
      <code class="literal">
       Reset stmt
      </code>
     </p>
     <p>
      The thread is resetting a prepared statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221829184">
      </a>
      <a class="indexterm" name="idm46045221827696">
      </a>
      <code class="literal">
       Set option
      </code>
     </p>
     <p>
      The thread is setting or resetting a client statement
            execution option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221824240">
      </a>
      <a class="indexterm" name="idm46045221822752">
      </a>
      <code class="literal">
       Shutdown
      </code>
     </p>
     <p>
      The thread is shutting down the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221819344">
      </a>
      <a class="indexterm" name="idm46045221817856">
      </a>
      <code class="literal">
       Sleep
      </code>
     </p>
     <p>
      The thread is waiting for the client to send a new statement
            to it.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221814416">
      </a>
      <a class="indexterm" name="idm46045221812928">
      </a>
      <code class="literal">
       Statistics
      </code>
     </p>
     <p>
      The thread is producing server status information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="indexterm" name="idm46045221809504">
      </a>
      <a class="indexterm" name="idm46045221808016">
      </a>
      <code class="literal">
       Time
      </code>
     </p>
     <p>
      Unused.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
