<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="performance-schema-object-filtering">
      </a>
      29.4.5 Pre-Filtering by Object
     </h3>
    </div>
   </div>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   table controls
        whether the Performance Schema monitors particular table and
        stored program objects. The initial
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   contents look like
        this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa86391689"><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_objects<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 class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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> OBJECT_TYPE <span class="token punctuation">|</span> OBJECT_SCHEMA      <span class="token punctuation">|</span> OBJECT_NAME <span class="token punctuation">|</span> ENABLED <span class="token punctuation">|</span> TIMED <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 class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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> EVENT       <span class="token punctuation">|</span> mysql              <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> EVENT       <span class="token punctuation">|</span> performance_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> EVENT       <span class="token punctuation">|</span> information_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> EVENT       <span class="token punctuation">|</span> %                  <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> YES   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> FUNCTION    <span class="token punctuation">|</span> mysql              <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> FUNCTION    <span class="token punctuation">|</span> performance_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> FUNCTION    <span class="token punctuation">|</span> information_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> FUNCTION    <span class="token punctuation">|</span> %                  <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> YES   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> PROCEDURE   <span class="token punctuation">|</span> mysql              <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> PROCEDURE   <span class="token punctuation">|</span> performance_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> PROCEDURE   <span class="token punctuation">|</span> information_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> PROCEDURE   <span class="token punctuation">|</span> %                  <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> YES   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE       <span class="token punctuation">|</span> mysql              <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE       <span class="token punctuation">|</span> performance_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE       <span class="token punctuation">|</span> information_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE       <span class="token punctuation">|</span> %                  <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> YES   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TRIGGER     <span class="token punctuation">|</span> mysql              <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TRIGGER     <span class="token punctuation">|</span> performance_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TRIGGER     <span class="token punctuation">|</span> information_schema <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TRIGGER     <span class="token punctuation">|</span> %                  <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> YES     <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 class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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>
   Modifications to the
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   table affect object monitoring immediately.
  </p>
  <p>
   The
   <code class="literal">
    OBJECT_TYPE
   </code>
   column indicates the type of
        object to which a row applies.
   <code class="literal">
    TABLE
   </code>
   filtering affects table I/O events
        (
   <code class="literal">
    wait/io/table/sql/handler
   </code>
   instrument) and
        table lock events
        (
   <code class="literal">
    wait/lock/table/sql/handler
   </code>
   instrument).
  </p>
  <p>
   The
   <code class="literal">
    OBJECT_SCHEMA
   </code>
   and
   <code class="literal">
    OBJECT_NAME
   </code>
   columns should contain a literal
        schema or object name, or
   <code class="literal">
    '%'
   </code>
   to match any
        name.
  </p>
  <p>
   The
   <code class="literal">
    ENABLED
   </code>
   column indicates whether matching
        objects are monitored, and
   <code class="literal">
    TIMED
   </code>
   indicates
        whether to collect timing information. Setting the
   <code class="literal">
    TIMED
   </code>
   column affects Performance Schema table
        contents as described in
   <a class="xref" href="performance-schema-timing.html" title="29.4.1 Performance Schema Event Timing">
    Section 29.4.1, “Performance Schema Event Timing”
   </a>
   .
  </p>
  <p>
   The effect of the default object configuration is to instrument
        all objects except those in the
   <code class="literal">
    mysql
   </code>
   ,
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   , and
   <code class="literal">
    performance_schema
   </code>
   databases. (Tables in the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   database are not
        instrumented regardless of the contents of
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   ; the row for
   <code class="literal">
    information_schema.%
   </code>
   simply makes this
        default explicit.)
  </p>
  <p>
   When the Performance Schema checks for a match in
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   , it tries to find
        more specific matches first. For rows that match a given
   <code class="literal">
    OBJECT_TYPE
   </code>
   , the Performance Schema checks
        rows in this order:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Rows with
      <code class="literal">
       OBJECT_SCHEMA='
       <em class="replaceable">
        <code>
         literal
        </code>
       </em>
       '
      </code>
      and
      <code class="literal">
       OBJECT_NAME='
       <em class="replaceable">
        <code>
         literal
        </code>
       </em>
       '
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Rows with
      <code class="literal">
       OBJECT_SCHEMA='
       <em class="replaceable">
        <code>
         literal
        </code>
       </em>
       '
      </code>
      and
      <code class="literal">
       OBJECT_NAME='%'
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Rows with
      <code class="literal">
       OBJECT_SCHEMA='%'
      </code>
      and
      <code class="literal">
       OBJECT_NAME='%'
      </code>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   For example, with a table
   <code class="literal">
    db1.t1
   </code>
   , the
        Performance Schema looks in
   <code class="literal">
    TABLE
   </code>
   rows for a
        match for
   <code class="literal">
    'db1'
   </code>
   and
   <code class="literal">
    't1'
   </code>
   ,
        then for
   <code class="literal">
    'db1'
   </code>
   and
   <code class="literal">
    '%'
   </code>
   ,
        then for
   <code class="literal">
    '%'
   </code>
   and
   <code class="literal">
    '%'
   </code>
   . The
        order in which matching occurs matters because different
        matching
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   rows can
        have different
   <code class="literal">
    ENABLED
   </code>
   and
   <code class="literal">
    TIMED
   </code>
   values.
  </p>
  <p>
   For table-related events, the Performance Schema combines the
        contents of
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   with
   <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>
   to determine
        whether to enable instruments and whether to time enabled
        instruments:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      For tables that match a row in
      <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
       <code class="literal">
        setup_objects
       </code>
      </a>
      , table
            instruments produce events only if
      <code class="literal">
       ENABLED
      </code>
      is
      <code class="literal">
       YES
      </code>
      in both
      <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-objects-table.html" title="29.12.2.4 The setup_objects Table">
       <code class="literal">
        setup_objects
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      The
      <code class="literal">
       TIMED
      </code>
      values in the two tables are
            combined, so that timing information is collected only when
            both values are
      <code class="literal">
       YES
      </code>
      .
     </p>
    </li>
   </ul>
  </div>
  <p>
   For stored program objects, the Performance Schema takes the
   <code class="literal">
    ENABLED
   </code>
   and
   <code class="literal">
    TIMED
   </code>
   columns
        directly from the
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   row. There is no combining of values with
   <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>
   .
  </p>
  <p>
   Suppose that
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   contains
        the following
   <code class="literal">
    TABLE
   </code>
   rows that apply to
   <code class="literal">
    db1
   </code>
   ,
   <code class="literal">
    db2
   </code>
   , and
   <code class="literal">
    db3
   </code>
   :
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa51963214"><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 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 class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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> OBJECT_TYPE <span class="token punctuation">|</span> OBJECT_SCHEMA <span class="token punctuation">|</span> OBJECT_NAME <span class="token punctuation">|</span> ENABLED <span class="token punctuation">|</span> TIMED <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 class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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       <span class="token punctuation">|</span> db1           <span class="token punctuation">|</span> t1          <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> YES   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE       <span class="token punctuation">|</span> db1           <span class="token punctuation">|</span> t2          <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE       <span class="token punctuation">|</span> db2           <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> YES     <span class="token punctuation">|</span> YES   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE       <span class="token punctuation">|</span> db3           <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> NO      <span class="token punctuation">|</span> NO    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE       <span class="token punctuation">|</span> %             <span class="token punctuation">|</span> %           <span class="token punctuation">|</span> YES     <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 class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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>
   If an object-related instrument in
   <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>
   has an
   <code class="literal">
    ENABLED
   </code>
   value of
   <code class="literal">
    NO
   </code>
   ,
        events for the object are not monitored. If the
   <code class="literal">
    ENABLED
   </code>
   value is
   <code class="literal">
    YES
   </code>
   ,
        event monitoring occurs according to the
   <code class="literal">
    ENABLED
   </code>
   value in the relevant
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   row:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       db1.t1
      </code>
      events are monitored
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       db1.t2
      </code>
      events are not monitored
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       db2.t3
      </code>
      events are monitored
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       db3.t4
      </code>
      events are not monitored
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       db4.t5
      </code>
      events are monitored
     </p>
    </li>
   </ul>
  </div>
  <p>
   Similar logic applies for combining the
   <code class="literal">
    TIMED
   </code>
   columns from 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-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   tables to
        determine whether to collect event timing information.
  </p>
  <p>
   If a persistent table and a temporary table have the same name,
        matching against
   <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
    <code class="literal">
     setup_objects
    </code>
   </a>
   rows
        occurs the same way for both. It is not possible to enable
        monitoring for one table but not the other. However, each table
        is instrumented separately.
  </p>
 </div>
 <br/>
</div>
