<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-objects-summary-global-by-type-table">
      </a>
      29.12.20.6 Object Wait Summary Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045068553888">
  </a>
  <a class="indexterm" name="idm46045068552384">
  </a>
  <p>
   The Performance Schema maintains the
   <a class="link" href="performance-schema-objects-summary-global-by-type-table.html" title="29.12.20.6 Object Wait Summary Table">
    <code class="literal">
     objects_summary_global_by_type
    </code>
   </a>
   table for aggregating object wait events.
  </p>
  <p>
   Example object wait event summary information:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa83877157"><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>objects_summary_global_by_type\G
<span class="token punctuation">.</span><span class="token punctuation">.</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 class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 3. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
   OBJECT_TYPE<span class="token punctuation">:</span> TABLE
 OBJECT_SCHEMA<span class="token punctuation">:</span> test
   OBJECT_NAME<span class="token punctuation">:</span> t
    COUNT_STAR<span class="token punctuation">:</span> 3
SUM_TIMER_WAIT<span class="token punctuation">:</span> 263126976
MIN_TIMER_WAIT<span class="token punctuation">:</span> 1522272
AVG_TIMER_WAIT<span class="token punctuation">:</span> 87708678
MAX_TIMER_WAIT<span class="token punctuation">:</span> 258428280
...
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 10. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
   OBJECT_TYPE<span class="token punctuation">:</span> TABLE
 OBJECT_SCHEMA<span class="token punctuation">:</span> mysql
   OBJECT_NAME<span class="token punctuation">:</span> user
    COUNT_STAR<span class="token punctuation">:</span> 14
SUM_TIMER_WAIT<span class="token punctuation">:</span> 365567592
MIN_TIMER_WAIT<span class="token punctuation">:</span> 1141704
AVG_TIMER_WAIT<span class="token punctuation">:</span> 26111769
MAX_TIMER_WAIT<span class="token punctuation">:</span> 334783032
...</span></code></pre>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-objects-summary-global-by-type-table.html" title="29.12.20.6 Object Wait Summary Table">
    <code class="literal">
     objects_summary_global_by_type
    </code>
   </a>
   table has these grouping columns to indicate how the table
          aggregates events:
   <code class="literal">
    OBJECT_TYPE
   </code>
   ,
   <code class="literal">
    OBJECT_SCHEMA
   </code>
   , and
   <code class="literal">
    OBJECT_NAME
   </code>
   . Each row summarizes events for
          the given object.
  </p>
  <p>
   <a class="link" href="performance-schema-objects-summary-global-by-type-table.html" title="29.12.20.6 Object Wait Summary Table">
    <code class="literal">
     objects_summary_global_by_type
    </code>
   </a>
   has the same summary columns as the
   <code class="literal">
    events_waits_summary_by_
    <em class="replaceable">
     <code>
      xxx
     </code>
    </em>
   </code>
   tables. See
   <a class="xref" href="performance-schema-wait-summary-tables.html" title="29.12.20.1 Wait Event Summary Tables">
    Section 29.12.20.1, “Wait Event Summary Tables”
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="performance-schema-objects-summary-global-by-type-table.html" title="29.12.20.6 Object Wait Summary Table">
    <code class="literal">
     objects_summary_global_by_type
    </code>
   </a>
   table has these indexes:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Primary key on (
      <code class="literal">
       OBJECT_TYPE
      </code>
      ,
      <code class="literal">
       OBJECT_SCHEMA
      </code>
      ,
      <code class="literal">
       OBJECT_NAME
      </code>
      )
     </p>
    </li>
   </ul>
  </div>
  <p>
   <a class="link" href="truncate-table.html" title="15.1.37 TRUNCATE TABLE Statement">
    <code class="literal">
     TRUNCATE TABLE
    </code>
   </a>
   is permitted for
          the object summary table. It resets the summary columns to
          zero rather than removing rows.
  </p>
 </div>
 <br/>
</div>
