<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-innodb-buffer-stats-by-schema">
      </a>
      30.4.3.7 The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema
Views
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045063195600">
  </a>
  <a class="indexterm" name="idm46045063194144">
  </a>
  <a class="indexterm" name="idm46045063192640">
  </a>
  <a class="indexterm" name="idm46045063191136">
  </a>
  <p>
   These views summarize the information in the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   <a class="link" href="information-schema-innodb-buffer-page-table.html" title="28.4.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table">
    <code class="literal">
     INNODB_BUFFER_PAGE
    </code>
   </a>
   table, grouped
          by schema. By default, rows are sorted by descending buffer
          size.
  </p>
  <div class="warning" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Warning
   </div>
   <p>
    Querying views that access the
    <a class="link" href="information-schema-innodb-buffer-page-table.html" title="28.4.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table">
     <code class="literal">
      INNODB_BUFFER_PAGE
     </code>
    </a>
    table can
            affect performance. Do not query these views on a production
            system unless you are aware of the performance impact and
            have determined it to be acceptable. To avoid impacting
            performance on a production system, reproduce the issue you
            want to investigate and query buffer pool statistics on a
            test instance.
   </p>
  </div>
  <p>
   The
   <a class="link" href="sys-innodb-buffer-stats-by-schema.html" title="30.4.3.7 The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views">
    <code class="literal">
     innodb_buffer_stats_by_schema
    </code>
   </a>
   and
   <a class="link" href="sys-innodb-buffer-stats-by-schema.html" title="30.4.3.7 The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views">
    <code class="literal">
     x$innodb_buffer_stats_by_schema
    </code>
   </a>
   views have these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       object_schema
      </code>
     </p>
     <p>
      The schema name for the object, or
      <code class="literal">
       InnoDB
              System
      </code>
      if the table belongs to the
      <code class="literal">
       InnoDB
      </code>
      storage engine.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       allocated
      </code>
     </p>
     <p>
      The total number of bytes allocated for the schema.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       data
      </code>
     </p>
     <p>
      The total number of data bytes allocated for the schema.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       pages
      </code>
     </p>
     <p>
      The total number of pages allocated for the schema.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       pages_hashed
      </code>
     </p>
     <p>
      The total number of hashed pages allocated for the schema.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       pages_old
      </code>
     </p>
     <p>
      The total number of old pages allocated for the schema.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       rows_cached
      </code>
     </p>
     <p>
      The total number of cached rows for the schema.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
