<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="innodb-buffer-pool-optimization">
      </a>
      10.10.1 InnoDB Buffer Pool Optimization
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045223115296">
  </a>
  <a class="indexterm" name="idm46045223114224">
  </a>
  <a class="indexterm" name="idm46045223113152">
  </a>
  <p>
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   maintains a storage area
        called the
   <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
    buffer pool
   </a>
   for caching data and indexes in memory. Knowing how the
   <code class="literal">
    InnoDB
   </code>
   buffer pool works, and taking
        advantage of it to keep frequently accessed data in memory, is
        an important aspect of MySQL tuning.
  </p>
  <p>
   For an explanation of the inner workings of the
   <code class="literal">
    InnoDB
   </code>
   buffer pool, an overview of its LRU
        replacement algorithm, and general configuration information,
        see
   <a class="xref" href="innodb-buffer-pool.html" title="17.5.1 Buffer Pool">
    Section 17.5.1, “Buffer Pool”
   </a>
   .
  </p>
  <p>
   For additional
   <code class="literal">
    InnoDB
   </code>
   buffer pool
        configuration and tuning information, see these sections:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="xref" href="innodb-performance-read_ahead.html" title="17.8.3.4 Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)">
       Section 17.8.3.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="innodb-buffer-pool-flushing.html" title="17.8.3.5 Configuring Buffer Pool Flushing">
       Section 17.8.3.5, “Configuring Buffer Pool Flushing”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="innodb-performance-midpoint_insertion.html" title="17.8.3.3 Making the Buffer Pool Scan Resistant">
       Section 17.8.3.3, “Making the Buffer Pool Scan Resistant”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="innodb-multiple-buffer-pools.html" title="17.8.3.2 Configuring Multiple Buffer Pool Instances">
       Section 17.8.3.2, “Configuring Multiple Buffer Pool Instances”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="innodb-preload-buffer-pool.html" title="17.8.3.6 Saving and Restoring the Buffer Pool State">
       Section 17.8.3.6, “Saving and Restoring the Buffer Pool State”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="xref" href="innodb-buffer-pool-resize.html" title="17.8.3.1 Configuring InnoDB Buffer Pool Size">
       Section 17.8.3.1, “Configuring InnoDB Buffer Pool Size”
      </a>
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
