<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-processlist-table">
      </a>
      29.12.22.7 The processlist Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045067377648">
  </a>
  <a class="indexterm" name="idm46045067376160">
  </a>
  <a class="indexterm" name="idm46045067374672">
  </a>
  <p>
   The MySQL process list indicates the operations currently
          being performed by the set of threads executing within the
          server. The
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   table is
          one source of process information. For a comparison of this
          table with other sources, see
   <a class="xref" href="processlist-access.html#processlist-sources" title="Sources of Process Information">
    Sources of Process Information
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   table can be
          queried directly. If you have the
   <a class="link" href="privileges-provided.html#priv_process">
    <code class="literal">
     PROCESS
    </code>
   </a>
   privilege, you can see
          all threads, even those belonging to other users. Otherwise
          (without the
   <a class="link" href="privileges-provided.html#priv_process">
    <code class="literal">
     PROCESS
    </code>
   </a>
   privilege), nonanonymous users have access to information
          about their own threads but not threads for other users, and
          anonymous users have no access to thread information.
  </p>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    If the
    <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_show_processlist">
     <code class="literal">
      performance_schema_show_processlist
     </code>
    </a>
    system variable is enabled, the
    <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
     <code class="literal">
      processlist
     </code>
    </a>
    table also serves
            as the basis for an alternative implementation underlying
            the
    <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
     <code class="literal">
      SHOW PROCESSLIST
     </code>
    </a>
    statement. For details, see later in this section.
   </p>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   table contains a
          row for each server process:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa57296847"><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">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> performance_schema<span class="token punctuation">.</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> 137
  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> 9
   USER<span class="token punctuation">:</span> me
   HOST<span class="token punctuation">:</span> localhost<span class="token punctuation">:</span>58812
     DB<span class="token punctuation">:</span> NULL
COMMAND<span class="token punctuation">:</span> Sleep
   TIME<span class="token punctuation">:</span> 95
  STATE<span class="token punctuation">:</span>
   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> 3. 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> 10
   USER<span class="token punctuation">:</span> me
   HOST<span class="token punctuation">:</span> localhost<span class="token punctuation">:</span>58834
     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> executing
   INFO<span class="token punctuation">:</span> SELECT <span class="token punctuation">*</span> FROM performance_schema.processlist
...</span></code></pre>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   table has these
          columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       ID
      </code>
     </p>
     <p>
      The connection identifier. This is the same value
              displayed in the
      <code class="literal">
       Id
      </code>
      column of the
      <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       <code class="literal">
        SHOW PROCESSLIST
       </code>
      </a>
      statement,
              displayed in the
      <code class="literal">
       PROCESSLIST_ID
      </code>
      column
              of the Performance Schema
      <a class="link" href="performance-schema-threads-table.html" title="29.12.22.8 The threads Table">
       <code class="literal">
        threads
       </code>
      </a>
      table, and returned
              by the
      <a class="link" href="information-functions.html#function_connection-id">
       <code class="literal">
        CONNECTION_ID()
       </code>
      </a>
      function within the thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       USER
      </code>
     </p>
     <p>
      The MySQL user who issued the statement. A value of
      <code class="literal">
       system user
      </code>
      refers to a nonclient
              thread spawned by the server to handle tasks internally,
              for example, a delayed-row handler thread or an I/O or SQL
              thread used on replica hosts. For
      <code class="literal">
       system
              user
      </code>
      , there is no host specified in the
      <code class="literal">
       Host
      </code>
      column.
      <code class="literal">
       unauthenticated
              user
      </code>
      refers to a thread that has become
              associated with a client connection but for which
              authentication of the client user has not yet occurred.
      <code class="literal">
       event_scheduler
      </code>
      refers to the thread
              that monitors scheduled events (see
      <a class="xref" href="event-scheduler.html" title="27.4 Using the Event Scheduler">
       Section 27.4, “Using the Event Scheduler”
      </a>
      ).
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       A
       <code class="literal">
        USER
       </code>
       value of
       <code class="literal">
        system
                user
       </code>
       is distinct from the
       <a class="link" href="privileges-provided.html#priv_system-user">
        <code class="literal">
         SYSTEM_USER
        </code>
       </a>
       privilege.
                The former designates internal threads. The latter
                distinguishes the system user and regular user account
                categories (see
       <a class="xref" href="account-categories.html" title="8.2.11 Account Categories">
        Section 8.2.11, “Account Categories”
       </a>
       ).
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       HOST
      </code>
     </p>
     <p>
      The host name of the client issuing the statement (except
              for
      <code class="literal">
       system user
      </code>
      , for which there is no
              host). The host name for TCP/IP connections is reported in
      <code class="literal">
       <em class="replaceable">
        <code>
         host_name
        </code>
       </em>
       :
       <em class="replaceable">
        <code>
         client_port
        </code>
       </em>
      </code>
      format to make it easier to determine which client is
              doing what.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       DB
      </code>
     </p>
     <p>
      The default database for the thread, or
      <code class="literal">
       NULL
      </code>
      if none has been selected.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COMMAND
      </code>
     </p>
     <p>
      The type of command the thread is executing on behalf of
              the client, or
      <code class="literal">
       Sleep
      </code>
      if the session is
              idle. For descriptions of thread commands, see
      <a class="xref" href="thread-information.html" title="10.14 Examining Server Thread (Process) Information">
       Section 10.14, “Examining Server Thread (Process) Information”
      </a>
      . The value of this
              column corresponds to the
      <code class="literal">
       COM_
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
      commands of the client/server protocol and
      <code class="literal">
       Com_
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
      status variables. See
      <a class="xref" href="server-status-variables.html" title="7.1.10 Server Status Variables">
       Section 7.1.10, “Server Status Variables”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TIME
      </code>
     </p>
     <p>
      The time in seconds that the thread has been in its
              current state. For a replica SQL thread, the value is the
              number of seconds between the timestamp of the last
              replicated event and the real time of the replica host.
              See
      <a class="xref" href="replication-threads.html" title="19.2.3 Replication Threads">
       Section 19.2.3, “Replication Threads”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       STATE
      </code>
     </p>
     <p>
      An action, event, or state that indicates what the thread
              is doing. For descriptions of
      <code class="literal">
       STATE
      </code>
      values, see
      <a class="xref" href="thread-information.html" title="10.14 Examining Server Thread (Process) Information">
       Section 10.14, “Examining Server Thread (Process) Information”
      </a>
      .
     </p>
     <p>
      Most states correspond to very quick operations. If a
              thread stays in a given state for many seconds, there
              might be a problem that needs to be investigated.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INFO
      </code>
     </p>
     <p>
      The statement the thread is executing, or
      <code class="literal">
       NULL
      </code>
      if it is executing no statement.
              The statement might be the one sent to the server, or an
              innermost statement if the statement executes other
              statements. For example, if a
      <code class="literal">
       CALL
      </code>
      statement executes a stored procedure that is executing a
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
      statement, the
      <code class="literal">
       INFO
      </code>
      value shows the
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
      statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       EXECUTION_ENGINE
      </code>
     </p>
     <p>
      The query execution engine. The value is either
      <code class="literal">
       PRIMARY
      </code>
      or
      <code class="literal">
       SECONDARY
      </code>
      . For use with HeatWave Service and
              HeatWave, where the
      <code class="literal">
       PRIMARY
      </code>
      engine is
      <code class="literal">
       InnoDB
      </code>
      and the
      <code class="literal">
       SECONDARY
      </code>
      engine is HeatWave
              (
      <code class="literal">
       RAPID
      </code>
      ). For MySQL Community Edition Server, MySQL Enterprise Edition Server
              (on-premise), and HeatWave Service without HeatWave, the value is
              always
      <code class="literal">
       PRIMARY
      </code>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   table has these
          indexes:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Primary key on (
      <code class="literal">
       ID
      </code>
      )
     </p>
    </li>
   </ul>
  </div>
  <p>
   <a class="link" href="truncate-table.html" title="15.1.37 TRUNCATE TABLE Statement">
    <code class="literal">
     TRUNCATE TABLE
    </code>
   </a>
   is not permitted
          for the
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   table.
  </p>
  <p>
   As mentioned previously, if the
   <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_show_processlist">
    <code class="literal">
     performance_schema_show_processlist
    </code>
   </a>
   system variable is enabled, the
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   table serves as the
          basis for an alternative implementation of other process
          information sources:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      The
      <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       <code class="literal">
        SHOW PROCESSLIST
       </code>
      </a>
      statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      The
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin processlist
        </strong>
       </span>
      </a>
      command
              (which uses
      <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       <code class="literal">
        SHOW
              PROCESSLIST
       </code>
      </a>
      statement).
     </p>
    </li>
   </ul>
  </div>
  <p>
   The default
   <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
    <code class="literal">
     SHOW PROCESSLIST
    </code>
   </a>
   implementation iterates across active threads from within the
          thread manager while holding a global mutex. This has negative
          performance consequences, particularly on busy systems. The
          alternative
   <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
    <code class="literal">
     SHOW PROCESSLIST
    </code>
   </a>
   implementation is based on the Performance Schema
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   table. This
          implementation queries active thread data from the Performance
          Schema rather than the thread manager and does not require a
          mutex.
  </p>
  <p>
   MySQL configuration affects
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   table contents as
          follows:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Minimum required configuration:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         The MySQL server must be configured and built with
                  thread instrumentation enabled. This is true by
                  default; it is controlled using the
         <a class="link" href="source-configuration-options.html#option_cmake_disable_psi_thread">
          <code class="option">
           DISABLE_PSI_THREAD
          </code>
         </a>
         <span class="command">
          <strong>
           CMake
          </strong>
         </span>
         option.
        </p>
       </li>
       <li class="listitem">
        <p>
         The Performance Schema must be enabled at server
                  startup. This is true by default; it is controlled
                  using the
         <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema">
          <code class="literal">
           performance_schema
          </code>
         </a>
         system variable.
        </p>
       </li>
      </ul>
     </div>
     <p>
      With that configuration satisfied,
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_show_processlist">
       <code class="literal">
        performance_schema_show_processlist
       </code>
      </a>
      enables or disables the alternative
      <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       <code class="literal">
        SHOW PROCESSLIST
       </code>
      </a>
      implementation. If the minimum configuration is not
              satisfied, the
      <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
       <code class="literal">
        processlist
       </code>
      </a>
      table (and thus
      <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       <code class="literal">
        SHOW
              PROCESSLIST
       </code>
      </a>
      ) may not return all data.
     </p>
    </li>
    <li class="listitem">
     <p>
      Recommended configuration:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         To avoid having some threads ignored:
        </p>
        <div class="itemizedlist">
         <ul class="itemizedlist" style="list-style-type: square; ">
          <li class="listitem">
           <p>
            Leave the
            <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_thread_instances">
             <code class="literal">
              performance_schema_max_thread_instances
             </code>
            </a>
            system variable set to its default or set it at
                      least as great as the
            <a class="link" href="server-system-variables.html#sysvar_max_connections">
             <code class="literal">
              max_connections
             </code>
            </a>
            system variable.
           </p>
          </li>
          <li class="listitem">
           <p>
            Leave the
            <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_thread_classes">
             <code class="literal">
              performance_schema_max_thread_classes
             </code>
            </a>
            system variable set to its default.
           </p>
          </li>
         </ul>
        </div>
       </li>
       <li class="listitem">
        <p>
         To avoid having some
         <code class="literal">
          STATE
         </code>
         column
                  values be empty, leave the
         <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_stage_classes">
          <code class="literal">
           performance_schema_max_stage_classes
          </code>
         </a>
         system variable set to its default.
        </p>
       </li>
      </ul>
     </div>
     <p>
      The default for those configuration parameters is
      <code class="literal">
       -1
      </code>
      , which causes the Performance Schema
              to autosize them at server startup. With the parameters
              set as indicated, the
      <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
       <code class="literal">
        processlist
       </code>
      </a>
      table (and thus
      <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       <code class="literal">
        SHOW PROCESSLIST
       </code>
      </a>
      ) produce
              complete process information.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The preceding configuration parameters affect the contents of
          the
   <code class="literal">
    processlist
   </code>
   table. For a given
          configuration, however, the
   <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
    <code class="literal">
     processlist
    </code>
   </a>
   contents are
          unaffected by the
   <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_show_processlist">
    <code class="literal">
     performance_schema_show_processlist
    </code>
   </a>
   setting.
  </p>
  <p>
   The alternative process list implementation does not apply to
          the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   <a class="link" href="information-schema-processlist-table.html" title="28.3.23 The INFORMATION_SCHEMA PROCESSLIST Table">
    <code class="literal">
     PROCESSLIST
    </code>
   </a>
   table or the
   <code class="literal">
    COM_PROCESS_INFO
   </code>
   command of the MySQL
          client/server protocol.
  </p>
 </div>
 <br/>
</div>
