<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="performance-schema-consumer-filtering">
      </a>
      29.4.7 Pre-Filtering by Consumer
     </h3>
    </div>
   </div>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-setup-consumers-table.html" title="29.12.2.2 The setup_consumers Table">
    <code class="literal">
     setup_consumers
    </code>
   </a>
   table lists the
        available consumer types and which are enabled:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa59654124"><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>setup_consumers<span class="token punctuation">;</span>
<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><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>
<span class="token output"><span class="token punctuation">|</span> NAME                             <span class="token punctuation">|</span> ENABLED <span class="token punctuation">|</span></span>
<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><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>
<span class="token output"><span class="token punctuation">|</span> events_stages_current            <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_stages_history            <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_stages_history_long       <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_statements_cpu            <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_statements_current        <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_statements_history        <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_statements_history_long   <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_transactions_current      <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_transactions_history      <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_transactions_history_long <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_waits_current             <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_waits_history             <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> events_waits_history_long        <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> global_instrumentation           <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> thread_instrumentation           <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> statements_digest                <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span></span>
<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><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></code></pre>
  </div>
  <p>
   Modify the
   <a class="link" href="performance-schema-setup-consumers-table.html" title="29.12.2.2 The setup_consumers Table">
    <code class="literal">
     setup_consumers
    </code>
   </a>
   table to
        affect pre-filtering at the consumer stage and determine the
        destinations to which events are sent. To enable or disable a
        consumer, set its
   <code class="literal">
    ENABLED
   </code>
   value to
   <code class="literal">
    YES
   </code>
   or
   <code class="literal">
    NO
   </code>
   .
  </p>
  <p>
   Modifications to the
   <a class="link" href="performance-schema-setup-consumers-table.html" title="29.12.2.2 The setup_consumers Table">
    <code class="literal">
     setup_consumers
    </code>
   </a>
   table affect
        monitoring immediately.
  </p>
  <p>
   If you disable a consumer, the server does not spend time
        maintaining destinations for that consumer. For example, if you
        do not care about historical event information, disable the
        history consumers:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa84309282"><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">UPDATE</span> performance_schema<span class="token punctuation">.</span>setup_consumers
<span class="token keyword">SET</span> ENABLED <span class="token operator">=</span> <span class="token string">'NO'</span>
<span class="token keyword">WHERE</span> <span class="token keyword">NAME</span> <span class="token operator">LIKE</span> <span class="token string">'%history%'</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   The consumer settings in the
   <a class="link" href="performance-schema-setup-consumers-table.html" title="29.12.2.2 The setup_consumers Table">
    <code class="literal">
     setup_consumers
    </code>
   </a>
   table form a
        hierarchy from higher levels to lower. The following principles
        apply:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Destinations associated with a consumer receive no events
            unless the Performance Schema checks the consumer and the
            consumer is enabled.
     </p>
    </li>
    <li class="listitem">
     <p>
      A consumer is checked only if all consumers it depends on
            (if any) are enabled.
     </p>
    </li>
    <li class="listitem">
     <p>
      If a consumer is not checked, or is checked but is disabled,
            other consumers that depend on it are not checked.
     </p>
    </li>
    <li class="listitem">
     <p>
      Dependent consumers may have their own dependent consumers.
     </p>
    </li>
    <li class="listitem">
     <p>
      If an event would not be sent to any destination, the
            Performance Schema does not produce it.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The following lists describe the available consumer values. For
        discussion of several representative consumer configurations and
        their effect on instrumentation, see
   <a class="xref" href="performance-schema-consumer-configurations.html" title="29.4.8 Example Consumer Configurations">
    Section 29.4.8, “Example Consumer Configurations”
   </a>
   .
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="xref" href="performance-schema-consumer-filtering.html#performance-schema-consumer-filtering-global-thread" title="Global and Thread Consumers">
       Global and Thread Consumers
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="performance-schema-consumer-filtering.html#performance-schema-consumer-filtering-wait-event" title="Wait Event Consumers">
       Wait Event Consumers
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="performance-schema-consumer-filtering.html#performance-schema-consumer-filtering-stage-event" title="Stage Event Consumers">
       Stage Event Consumers
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="performance-schema-consumer-filtering.html#performance-schema-consumer-filtering-statement-event" title="Statement Event Consumers">
       Statement Event Consumers
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="performance-schema-consumer-filtering.html#performance-schema-consumer-filtering-transaction-event" title="Transaction Event Consumers">
       Transaction Event Consumers
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="performance-schema-consumer-filtering.html#performance-schema-consumer-filtering-statement-digest" title="Statement Digest Consumer">
       Statement Digest Consumer
      </a>
     </p>
    </li>
   </ul>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="performance-schema-consumer-filtering-global-thread">
       </a>
       Global and Thread Consumers
      </h4>
     </div>
    </div>
   </div>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <code class="literal">
        global_instrumentation
       </code>
       is the highest
              level consumer. If
       <code class="literal">
        global_instrumentation
       </code>
       is
       <code class="literal">
        NO
       </code>
       , it disables global instrumentation.
              All other settings are lower level and are not checked; it
              does not matter what they are set to. No global or per
              thread information is maintained and no individual events
              are collected in the current-events or event-history
              tables. If
       <code class="literal">
        global_instrumentation
       </code>
       is
       <code class="literal">
        YES
       </code>
       , the Performance Schema maintains
              information for global states and also checks the
       <code class="literal">
        thread_instrumentation
       </code>
       consumer.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        thread_instrumentation
       </code>
       is checked only
              if
       <code class="literal">
        global_instrumentation
       </code>
       is
       <code class="literal">
        YES
       </code>
       . Otherwise, if
       <code class="literal">
        thread_instrumentation
       </code>
       is
       <code class="literal">
        NO
       </code>
       , it disables thread-specific
              instrumentation and all lower-level settings are ignored.
              No information is maintained per thread and no individual
              events are collected in the current-events or
              event-history tables. If
       <code class="literal">
        thread_instrumentation
       </code>
       is
       <code class="literal">
        YES
       </code>
       , the Performance Schema maintains
              thread-specific information and also checks
       <code class="literal">
        events_
        <em class="replaceable">
         <code>
          xxx
         </code>
        </em>
        _current
       </code>
       consumers.
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="performance-schema-consumer-filtering-wait-event">
       </a>
       Wait Event Consumers
      </h4>
     </div>
    </div>
   </div>
   <p>
    These consumers require both
    <code class="literal">
     global_instrumentation
    </code>
    and
    <code class="literal">
     thread_instrumentation
    </code>
    to be
    <code class="literal">
     YES
    </code>
    or they are not checked. If checked,
          they act as follows:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <code class="literal">
        events_waits_current
       </code>
       , if
       <code class="literal">
        NO
       </code>
       , disables collection of individual
              wait events in the
       <a class="link" href="performance-schema-events-waits-current-table.html" title="29.12.4.1 The events_waits_current Table">
        <code class="literal">
         events_waits_current
        </code>
       </a>
       table.
              If
       <code class="literal">
        YES
       </code>
       , it enables wait event
              collection and the Performance Schema checks the
       <code class="literal">
        events_waits_history
       </code>
       and
       <code class="literal">
        events_waits_history_long
       </code>
       consumers.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        events_waits_history
       </code>
       is not checked if
       <code class="literal">
        event_waits_current
       </code>
       is
       <code class="literal">
        NO
       </code>
       . Otherwise, an
       <code class="literal">
        events_waits_history
       </code>
       value of
       <code class="literal">
        NO
       </code>
       or
       <code class="literal">
        YES
       </code>
       disables
              or enables collection of wait events in the
       <a class="link" href="performance-schema-events-waits-history-table.html" title="29.12.4.2 The events_waits_history Table">
        <code class="literal">
         events_waits_history
        </code>
       </a>
       table.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        events_waits_history_long
       </code>
       is not
              checked if
       <code class="literal">
        event_waits_current
       </code>
       is
       <code class="literal">
        NO
       </code>
       . Otherwise, an
       <code class="literal">
        events_waits_history_long
       </code>
       value of
       <code class="literal">
        NO
       </code>
       or
       <code class="literal">
        YES
       </code>
       disables
              or enables collection of wait events in the
       <a class="link" href="performance-schema-events-waits-history-long-table.html" title="29.12.4.3 The events_waits_history_long Table">
        <code class="literal">
         events_waits_history_long
        </code>
       </a>
       table.
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="performance-schema-consumer-filtering-stage-event">
       </a>
       Stage Event Consumers
      </h4>
     </div>
    </div>
   </div>
   <p>
    These consumers require both
    <code class="literal">
     global_instrumentation
    </code>
    and
    <code class="literal">
     thread_instrumentation
    </code>
    to be
    <code class="literal">
     YES
    </code>
    or they are not checked. If checked,
          they act as follows:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <code class="literal">
        events_stages_current
       </code>
       , if
       <code class="literal">
        NO
       </code>
       , disables collection of individual
              stage events in the
       <a class="link" href="performance-schema-events-stages-current-table.html" title="29.12.5.1 The events_stages_current Table">
        <code class="literal">
         events_stages_current
        </code>
       </a>
       table.
              If
       <code class="literal">
        YES
       </code>
       , it enables stage event
              collection and the Performance Schema checks the
       <code class="literal">
        events_stages_history
       </code>
       and
       <code class="literal">
        events_stages_history_long
       </code>
       consumers.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        events_stages_history
       </code>
       is not checked if
       <code class="literal">
        event_stages_current
       </code>
       is
       <code class="literal">
        NO
       </code>
       . Otherwise, an
       <code class="literal">
        events_stages_history
       </code>
       value of
       <code class="literal">
        NO
       </code>
       or
       <code class="literal">
        YES
       </code>
       disables
              or enables collection of stage events in the
       <a class="link" href="performance-schema-events-stages-history-table.html" title="29.12.5.2 The events_stages_history Table">
        <code class="literal">
         events_stages_history
        </code>
       </a>
       table.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        events_stages_history_long
       </code>
       is not
              checked if
       <code class="literal">
        event_stages_current
       </code>
       is
       <code class="literal">
        NO
       </code>
       . Otherwise, an
       <code class="literal">
        events_stages_history_long
       </code>
       value of
       <code class="literal">
        NO
       </code>
       or
       <code class="literal">
        YES
       </code>
       disables
              or enables collection of stage events in the
       <a class="link" href="performance-schema-events-stages-history-long-table.html" title="29.12.5.3 The events_stages_history_long Table">
        <code class="literal">
         events_stages_history_long
        </code>
       </a>
       table.
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="performance-schema-consumer-filtering-statement-event">
       </a>
       Statement Event Consumers
      </h4>
     </div>
    </div>
   </div>
   <p>
    These consumers require both
    <code class="literal">
     global_instrumentation
    </code>
    and
    <code class="literal">
     thread_instrumentation
    </code>
    to be
    <code class="literal">
     YES
    </code>
    or they are not checked. If checked,
          they act as follows:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <code class="literal">
        events_statements_cpu
       </code>
       , if
       <code class="literal">
        NO
       </code>
       , disables measurement of
       <code class="literal">
        CPU_TIME
       </code>
       . If
       <code class="literal">
        YES
       </code>
       ,
              and the instrumentation is enabled and timed,
       <code class="literal">
        CPU_TIME
       </code>
       is measured.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        events_statements_current
       </code>
       , if
       <code class="literal">
        NO
       </code>
       , disables collection of individual
              statement events in the
       <a class="link" href="performance-schema-events-statements-current-table.html" title="29.12.6.1 The events_statements_current Table">
        <code class="literal">
         events_statements_current
        </code>
       </a>
       table. If
       <code class="literal">
        YES
       </code>
       , it enables statement
              event collection and the Performance Schema checks the
       <code class="literal">
        events_statements_history
       </code>
       and
       <code class="literal">
        events_statements_history_long
       </code>
       consumers.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        events_statements_history
       </code>
       is not
              checked if
       <code class="literal">
        events_statements_current
       </code>
       is
       <code class="literal">
        NO
       </code>
       . Otherwise, an
       <code class="literal">
        events_statements_history
       </code>
       value of
       <code class="literal">
        NO
       </code>
       or
       <code class="literal">
        YES
       </code>
       disables
              or enables collection of statement events in the
       <a class="link" href="performance-schema-events-statements-history-table.html" title="29.12.6.2 The events_statements_history Table">
        <code class="literal">
         events_statements_history
        </code>
       </a>
       table.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        events_statements_history_long
       </code>
       is not
              checked if
       <code class="literal">
        events_statements_current
       </code>
       is
       <code class="literal">
        NO
       </code>
       . Otherwise, an
       <code class="literal">
        events_statements_history_long
       </code>
       value of
       <code class="literal">
        NO
       </code>
       or
       <code class="literal">
        YES
       </code>
       disables
              or enables collection of statement events in the
       <a class="link" href="performance-schema-events-statements-history-long-table.html" title="29.12.6.3 The events_statements_history_long Table">
        <code class="literal">
         events_statements_history_long
        </code>
       </a>
       table.
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="performance-schema-consumer-filtering-transaction-event">
       </a>
       Transaction Event Consumers
      </h4>
     </div>
    </div>
   </div>
   <p>
    These consumers require both
    <code class="literal">
     global_instrumentation
    </code>
    and
    <code class="literal">
     thread_instrumentation
    </code>
    to be
    <code class="literal">
     YES
    </code>
    or they are not checked. If checked,
          they act as follows:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <code class="literal">
        events_transactions_current
       </code>
       , if
       <code class="literal">
        NO
       </code>
       , disables collection of individual
              transaction events in the
       <a class="link" href="performance-schema-events-transactions-current-table.html" title="29.12.7.1 The events_transactions_current Table">
        <code class="literal">
         events_transactions_current
        </code>
       </a>
       table. If
       <code class="literal">
        YES
       </code>
       , it enables transaction
              event collection and the Performance Schema checks the
       <code class="literal">
        events_transactions_history
       </code>
       and
       <code class="literal">
        events_transactions_history_long
       </code>
       consumers.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        events_transactions_history
       </code>
       is not
              checked if
       <code class="literal">
        events_transactions_current
       </code>
       is
       <code class="literal">
        NO
       </code>
       . Otherwise, an
       <code class="literal">
        events_transactions_history
       </code>
       value of
       <code class="literal">
        NO
       </code>
       or
       <code class="literal">
        YES
       </code>
       disables
              or enables collection of transaction events in the
       <a class="link" href="performance-schema-events-transactions-history-table.html" title="29.12.7.2 The events_transactions_history Table">
        <code class="literal">
         events_transactions_history
        </code>
       </a>
       table.
      </p>
     </li>
     <li class="listitem">
      <p>
       <code class="literal">
        events_transactions_history_long
       </code>
       is not
              checked if
       <code class="literal">
        events_transactions_current
       </code>
       is
       <code class="literal">
        NO
       </code>
       . Otherwise, an
       <code class="literal">
        events_transactions_history_long
       </code>
       value
              of
       <code class="literal">
        NO
       </code>
       or
       <code class="literal">
        YES
       </code>
       disables or enables collection of transaction events in
              the
       <a class="link" href="performance-schema-events-transactions-history-long-table.html" title="29.12.7.3 The events_transactions_history_long Table">
        <code class="literal">
         events_transactions_history_long
        </code>
       </a>
       table.
      </p>
     </li>
    </ul>
   </div>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="performance-schema-consumer-filtering-statement-digest">
       </a>
       Statement Digest Consumer
      </h4>
     </div>
    </div>
   </div>
   <p>
    The
    <code class="literal">
     statements_digest
    </code>
    consumer requires
    <code class="literal">
     global_instrumentation
    </code>
    to be
    <code class="literal">
     YES
    </code>
    or it is not checked. There is no
          dependency on the statement event consumers, so you can obtain
          statistics per digest without having to collect statistics in
    <a class="link" href="performance-schema-events-statements-current-table.html" title="29.12.6.1 The events_statements_current Table">
     <code class="literal">
      events_statements_current
     </code>
    </a>
    , which
          is advantageous in terms of overhead. Conversely, you can get
          detailed statements in
    <a class="link" href="performance-schema-events-statements-current-table.html" title="29.12.6.1 The events_statements_current Table">
     <code class="literal">
      events_statements_current
     </code>
    </a>
    without
          digests (the
    <code class="literal">
     DIGEST
    </code>
    and
    <code class="literal">
     DIGEST_TEXT
    </code>
    columns are
    <code class="literal">
     NULL
    </code>
    in this case).
   </p>
   <p>
    For more information about statement digesting, see
    <a class="xref" href="performance-schema-statement-digests.html" title="29.10 Performance Schema Statement Digests and Sampling">
     Section 29.10, “Performance Schema Statement Digests and Sampling”
    </a>
    .
   </p>
  </div>
 </div>
 <br/>
</div>
