<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="optimizing-innodb-many-tables">
      </a>
      10.5.10 Optimizing InnoDB for Systems with Many Tables
     </h3>
    </div>
   </div>
  </div>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      If you have configured
      <a class="link" href="innodb-statistics-estimation.html" title="17.8.10.2 Configuring Non-Persistent Optimizer Statistics Parameters">
       non-persistent
            optimizer statistics
      </a>
      (a non-default configuration),
      <code class="literal">
       InnoDB
      </code>
      computes index
      <a class="link" href="glossary.html#glos_cardinality" title="cardinality">
       cardinality
      </a>
      values
            for a table the first time that table is accessed after
            startup, instead of storing such values in the table. This
            step can take significant time on systems that partition the
            data into many tables. Since this overhead only applies to
            the initial table open operation, to
      <span class="quote">
       “
       <span class="quote">
        warm up
       </span>
       ”
      </span>
      a table for later use, access it immediately after startup
            by issuing a statement such as
      <code class="literal">
       SELECT 1 FROM
       <em class="replaceable">
        <code>
         tbl_name
        </code>
       </em>
       LIMIT 1
      </code>
      .
     </p>
     <p>
      Optimizer statistics are persisted to disk by default,
            enabled by the
      <a class="link" href="innodb-parameters.html#sysvar_innodb_stats_persistent">
       <code class="literal">
        innodb_stats_persistent
       </code>
      </a>
      configuration option. For information about persistent
            optimizer statistics, see
      <a class="xref" href="innodb-persistent-stats.html" title="17.8.10.1 Configuring Persistent Optimizer Statistics Parameters">
       Section 17.8.10.1, “Configuring Persistent Optimizer Statistics Parameters”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
