<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="performance-schema-options">
      </a>
      29.14 Performance Schema Command Options
     </h2>
    </div>
   </div>
  </div>
  <p>
   Performance Schema parameters can be specified at server startup
      on the command line or in option files to configure Performance
      Schema instruments and consumers. Runtime configuration is also
      possible in many cases (see
   <a class="xref" href="performance-schema-runtime-configuration.html" title="29.4 Performance Schema Runtime Configuration">
    Section 29.4, “Performance Schema Runtime Configuration”
   </a>
   ), but
      startup configuration must be used when runtime configuration is
      too late to affect instruments that have already been initialized
      during the startup process.
  </p>
  <p>
   Performance Schema consumers and instruments can be configured at
      startup using the following syntax. For additional details, see
   <a class="xref" href="performance-schema-startup-configuration.html" title="29.3 Performance Schema Startup Configuration">
    Section 29.3, “Performance Schema Startup Configuration”
   </a>
   .
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-xxx">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-xxx">
       <code class="option">
        --performance-schema-consumer-
        <em class="replaceable">
         <code>
          consumer_name
         </code>
        </em>
        =
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066283216">
     </a>
     <a class="indexterm" name="idm46045066281712">
     </a>
     <p>
      Configure a Performance Schema consumer. Consumer names 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 use
          underscores, but for consumers set at startup, dashes and
          underscores within the name are equivalent. Options for
          configuring individual consumers are detailed later in this
          section.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-instrument">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-instrument">
       <code class="option">
        --performance-schema-instrument=
        <em class="replaceable">
         <code>
          instrument_name
         </code>
        </em>
        =
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066275056">
     </a>
     <a class="indexterm" name="idm46045066273552">
     </a>
     <p>
      Configure a Performance Schema instrument. The name may be
          given as a pattern to configure instruments that match the
          pattern.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The following items configure individual consumers:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-stages-current">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-stages-current">
       <code class="option">
        --performance-schema-consumer-events-stages-current=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066267792">
     </a>
     <a class="indexterm" name="idm46045066266336">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-stages-current
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-stages-history">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-stages-history">
       <code class="option">
        --performance-schema-consumer-events-stages-history=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066260640">
     </a>
     <a class="indexterm" name="idm46045066259184">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-stages-history
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-stages-history-long">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-stages-history-long">
       <code class="option">
        --performance-schema-consumer-events-stages-history-long=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066253552">
     </a>
     <a class="indexterm" name="idm46045066252016">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-stages-history-long
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-statements-cpu">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-statements-cpu">
       <code class="option">
        --performance-schema-consumer-events-statements-cpu=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066246304">
     </a>
     <a class="indexterm" name="idm46045066244848">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-statements-cpu
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-statements-current">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-statements-current">
       <code class="option">
        --performance-schema-consumer-events-statements-current=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066239280">
     </a>
     <a class="indexterm" name="idm46045066237744">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-statements-current
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-statements-history">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-statements-history">
       <code class="option">
        --performance-schema-consumer-events-statements-history=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066232160">
     </a>
     <a class="indexterm" name="idm46045066230624">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-statements-history
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-statements-history-long">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-statements-history-long">
       <code class="option">
        --performance-schema-consumer-events-statements-history-long=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066224880">
     </a>
     <a class="indexterm" name="idm46045066223344">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-statements-history-long
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-transactions-current">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-transactions-current">
       <code class="option">
        --performance-schema-consumer-events-transactions-current=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066217776">
     </a>
     <a class="indexterm" name="idm46045066216240">
     </a>
     <p>
      Configure the Performance Schema
      <code class="literal">
       events-transactions-current
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-transactions-history">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-transactions-history">
       <code class="option">
        --performance-schema-consumer-events-transactions-history=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066210592">
     </a>
     <a class="indexterm" name="idm46045066209056">
     </a>
     <p>
      Configure the Performance Schema
      <code class="literal">
       events-transactions-history
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-transactions-history-long">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-transactions-history-long">
       <code class="option">
        --performance-schema-consumer-events-transactions-history-long=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066203408">
     </a>
     <a class="indexterm" name="idm46045066201872">
     </a>
     <p>
      Configure the Performance Schema
      <code class="literal">
       events-transactions-history-long
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-waits-current">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-waits-current">
       <code class="option">
        --performance-schema-consumer-events-waits-current=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066196224">
     </a>
     <a class="indexterm" name="idm46045066194704">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-waits-current
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-waits-history">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-waits-history">
       <code class="option">
        --performance-schema-consumer-events-waits-history=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066189168">
     </a>
     <a class="indexterm" name="idm46045066187648">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-waits-history
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-events-waits-history-long">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-events-waits-history-long">
       <code class="option">
        --performance-schema-consumer-events-waits-history-long=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066182112">
     </a>
     <a class="indexterm" name="idm46045066180576">
     </a>
     <p>
      Configure the
      <code class="literal">
       events-waits-history-long
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-global-instrumentation">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-global-instrumentation">
       <code class="option">
        --performance-schema-consumer-global-instrumentation=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066174928">
     </a>
     <a class="indexterm" name="idm46045066173472">
     </a>
     <p>
      Configure the
      <code class="literal">
       global-instrumentation
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-statements-digest">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-statements-digest">
       <code class="option">
        --performance-schema-consumer-statements-digest=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066167840">
     </a>
     <a class="indexterm" name="idm46045066166320">
     </a>
     <p>
      Configure the
      <code class="literal">
       statements-digest
      </code>
      consumer.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_mysqld_performance-schema-consumer-thread-instrumentation">
      </a>
      <a class="link" href="performance-schema-options.html#option_mysqld_performance-schema-consumer-thread-instrumentation">
       <code class="option">
        --performance-schema-consumer-thread-instrumentation=
        <code class="literal">
         value
        </code>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066160800">
     </a>
     <a class="indexterm" name="idm46045066159344">
     </a>
     <p>
      Configure the
      <code class="literal">
       thread-instrumentation
      </code>
      consumer.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
