<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-tp-thread-group-state-table">
      </a>
      28.5.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045076060800">
  </a>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    The
    <code class="literal">
     INFORMATION_SCHEMA
    </code>
    thread pool tables are
        deprecated, and subject to removal in a future version of MySQL.
        You should use the versions available as Performance Schema
        tables insted. See
    <a class="xref" href="performance-schema-thread-pool-tables.html" title="29.12.16 Performance Schema Thread Pool Tables">
     Section 29.12.16, “Performance Schema Thread Pool Tables”
    </a>
    .
        Applications should transition away from the old tables to the
        new tables. For example, if an application uses this query:
   </p>
   <div class="copytoclipboard-wrapper">
    <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa16908103"><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 keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>TP_THREAD_GROUP_STATE<span class="token punctuation">;</span></code></pre>
   </div>
   <p>
    The application should use this query instead:
   </p>
   <div class="copytoclipboard-wrapper">
    <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa3420930"><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 keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> performance_schema<span class="token punctuation">.</span>tp_thread_group_state<span class="token punctuation">;</span></code></pre>
   </div>
  </div>
  <p>
   The
   <code class="literal">
    TP_THREAD_GROUP_STATE
   </code>
   table has one row per
      thread group in the thread pool. Each row provides information
      about the current state of a group.
  </p>
  <p>
   For descriptions of the columns in the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   <code class="literal">
    TP_THREAD_GROUP_STATE
   </code>
   table, see
   <a class="xref" href="performance-schema-tp-thread-group-state-table.html" title="29.12.16.2 The tp_thread_group_state Table">
    Section 29.12.16.2, “The tp_thread_group_state Table”
   </a>
   .
      The Performance Schema
   <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>
   table has
      equivalent columns.
  </p>
 </div>
 <br/>
</div>
