<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="optimizer-tracing">
      </a>
      10.15 Tracing the Optimizer
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="optimizer-tracing-typical-usage.html">
       10.15.1 Typical Usage
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="system-variables-controlling-tracing.html">
       10.15.2 System Variables Controlling Tracing
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="traceable-statements.html">
       10.15.3 Traceable Statements
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="tuning-trace-purging.html">
       10.15.4 Tuning Trace Purging
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="tracing-memory-usage.html">
       10.15.5 Tracing Memory Usage
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="privilege-checking.html">
       10.15.6 Privilege Checking
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="interaction-with-debug-option.html">
       10.15.7 Interaction with the --debug Option
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="optimizer-trace-system-variable.html">
       10.15.8 The optimizer_trace System Variable
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="end-markers-in-json-system-variable.html">
       10.15.9 The end_markers_in_json System Variable
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="optimizer-features-to-trace.html">
       10.15.10 Selecting Optimizer Features to Trace
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="trace-general-structure.html">
       10.15.11 Trace General Structure
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="tracing-example.html">
       10.15.12 Example
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="displaying-traces.html">
       10.15.13 Displaying Traces in Other Applications
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="preventing-use-of-optimizer-trace.html">
       10.15.14 Preventing the Use of Optimizer Trace
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="optimizer-trace-testing.html">
       10.15.15 Testing Optimizer Trace
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="optimizer-trace-implementation.html">
       10.15.16 Optimizer Trace Implementation
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <p>
   The MySQL optimizer includes the capability to perform tracing; the
    interface is provided by a set of
   <code class="literal">
    optimizer_trace_xxx
   </code>
   system variables and the
   <a class="link" href="information-schema-optimizer-trace-table.html" title="28.3.19 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table">
    <code class="literal">
     INFORMATION_SCHEMA.OPTIMIZER_TRACE
    </code>
   </a>
   table.
  </p>
 </div>
 <br/>
</div>
