<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="performance-schema-runtime-configuration">
      </a>
      29.4 Performance Schema Runtime Configuration
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="performance-schema-timing.html">
       29.4.1 Performance Schema Event Timing
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-filtering.html">
       29.4.2 Performance Schema Event Filtering
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-pre-filtering.html">
       29.4.3 Event Pre-Filtering
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-instrument-filtering.html">
       29.4.4 Pre-Filtering by Instrument
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-object-filtering.html">
       29.4.5 Pre-Filtering by Object
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-thread-filtering.html">
       29.4.6 Pre-Filtering by Thread
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-consumer-filtering.html">
       29.4.7 Pre-Filtering by Consumer
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-consumer-configurations.html">
       29.4.8 Example Consumer Configurations
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-filtering-names.html">
       29.4.9 Naming Instruments or Consumers for Filtering Operations
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="performance-schema-instrumentation-checking.html">
       29.4.10 Determining What Is Instrumented
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <p>
   Specific Performance Schema features can be enabled at runtime to
      control which types of event collection occur.
  </p>
  <p>
   Performance Schema setup tables contain information about
      monitoring configuration:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa3495715"><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 keyword">TABLE_NAME</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span><span class="token keyword">TABLES</span>
       <span class="token keyword">WHERE</span> TABLE_SCHEMA <span class="token operator">=</span> <span class="token string">'performance_schema'</span>
       <span class="token operator">AND</span> <span class="token keyword">TABLE_NAME</span> <span class="token operator">LIKE</span> <span class="token string">'setup%'</span><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>
<span class="token output"><span class="token punctuation">|</span> TABLE_NAME        <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>
<span class="token output"><span class="token punctuation">|</span> setup_actors      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> setup_consumers   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> setup_instruments <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> setup_objects     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> setup_threads     <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></code></pre>
  </div>
  <p>
   You can examine the contents of these tables to obtain information
      about Performance Schema monitoring characteristics. If you have
      the
   <a class="link" href="privileges-provided.html#priv_update">
    <code class="literal">
     UPDATE
    </code>
   </a>
   privilege, you can
      change Performance Schema operation by modifying setup tables to
      affect how monitoring occurs. For additional details about these
      tables, see
   <a class="xref" href="performance-schema-setup-tables.html" title="29.12.2 Performance Schema Setup Tables">
    Section 29.12.2, “Performance Schema Setup Tables”
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="performance-schema-setup-instruments-table.html" title="29.12.2.3 The setup_instruments Table">
    <code class="literal">
     setup_instruments
    </code>
   </a>
   and
   <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>
   tables list the
      instruments for which events can be collected and the types of
      consumers for which event information actually is collected,
      respectively. Other setup tables enable further modification of
      the monitoring configuration.
   <a class="xref" href="performance-schema-filtering.html" title="29.4.2 Performance Schema Event Filtering">
    Section 29.4.2, “Performance Schema Event Filtering”
   </a>
   , discusses how you
      can modify these tables to affect event collection.
  </p>
  <p>
   If there are Performance Schema configuration changes that must be
      made at runtime using SQL statements and you would like these
      changes to take effect each time the server starts, put the
      statements in a file and start the server with the
   <a class="link" href="server-system-variables.html#sysvar_init_file">
    <code class="literal">
     init_file
    </code>
   </a>
   system variable set to
      name the file. This strategy can also be useful if you have
      multiple monitoring configurations, each tailored to produce a
      different kind of monitoring, such as casual server health
      monitoring, incident investigation, application behavior
      troubleshooting, and so forth. Put the statements for each
      monitoring configuration into their own file and specify the
      appropriate file as the
   <a class="link" href="server-system-variables.html#sysvar_init_file">
    <code class="literal">
     init_file
    </code>
   </a>
   value when you start the server.
  </p>
 </div>
 <br/>
</div>
