<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="performance-schema-thread-pool-tables">
      </a>
      29.12.16 Performance Schema Thread Pool Tables
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="performance-schema-tp-connections-table.html">
       29.12.16.1 The tp_connections Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-tp-thread-group-state-table.html">
       29.12.16.2 The tp_thread_group_state Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-tp-thread-group-stats-table.html">
       29.12.16.3 The tp_thread_group_stats Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-tp-thread-state-table.html">
       29.12.16.4 The tp_thread_state Table
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045069922240">
  </a>
  <p>
   The following sections describe the Performance Schema tables
        associated with the thread pool plugin (see
   <a class="xref" href="thread-pool.html" title="7.6.3 MySQL Enterprise Thread Pool">
    Section 7.6.3, “MySQL Enterprise Thread Pool”
   </a>
   ). They provide information about
        thread pool operation:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="performance-schema-tp-connections-table.html" title="29.12.16.1 The tp_connections Table">
       <code class="literal">
        tp_connections
       </code>
      </a>
      : Information
            about thread pool connections.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="performance-schema-tp-thread-group-state-table.html" title="29.12.16.2 The tp_thread_group_state Table">
       <code class="literal">
        tp_thread_group_state
       </code>
      </a>
      :
            Information about thread pool thread group states.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="performance-schema-tp-thread-group-stats-table.html" title="29.12.16.3 The tp_thread_group_stats Table">
       <code class="literal">
        tp_thread_group_stats
       </code>
      </a>
      : Thread
            group statistics.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="performance-schema-tp-thread-state-table.html" title="29.12.16.4 The tp_thread_state Table">
       <code class="literal">
        tp_thread_state
       </code>
      </a>
      : Information
            about thread pool thread states.
     </p>
    </li>
   </ul>
  </div>
  <p>
   Rows in these tables represent snapshots in time. In the case of
   <a class="link" href="performance-schema-tp-thread-state-table.html" title="29.12.16.4 The tp_thread_state Table">
    <code class="literal">
     tp_thread_state
    </code>
   </a>
   , all rows for a
        thread group comprise a snapshot in time. Thus, the MySQL server
        holds the mutex of the thread group while producing the
        snapshot. But it does not hold mutexes on all thread groups at
        the same time, to prevent a statement against
   <a class="link" href="performance-schema-tp-thread-state-table.html" title="29.12.16.4 The tp_thread_state Table">
    <code class="literal">
     tp_thread_state
    </code>
   </a>
   from blocking the
        entire MySQL server.
  </p>
  <p>
   The Performance Schema thread pool tables are implemented by the
        thread pool plugin and are loaded and unloaded when that plugin
        is loaded and unloaded (see
   <a class="xref" href="thread-pool-installation.html" title="7.6.3.2 Thread Pool Installation">
    Section 7.6.3.2, “Thread Pool Installation”
   </a>
   ). No special
        configuration step for the tables is needed. However, the tables
        depend on the thread pool plugin being enabled. If the thread
        pool plugin is loaded but disabled, the tables are not created.
  </p>
 </div>
 <br/>
</div>
