<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="locking-issues">
      </a>
      10.11 Optimizing Locking Operations
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="internal-locking.html">
       10.11.1 Internal Locking Methods
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="table-locking.html">
       10.11.2 Table Locking Issues
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="concurrent-inserts.html">
       10.11.3 Concurrent Inserts
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="metadata-locking.html">
       10.11.4 Metadata Locking
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="external-locking.html">
       10.11.5 External Locking
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <p>
   MySQL manages contention for table contents using
   <a class="link" href="glossary.html#glos_locking" title="locking">
    locking
   </a>
   :
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Internal locking is performed within the MySQL server itself
          to manage contention for table contents by multiple threads.
          This type of locking is internal because it is performed
          entirely by the server and involves no other programs. See
      <a class="xref" href="internal-locking.html" title="10.11.1 Internal Locking Methods">
       Section 10.11.1, “Internal Locking Methods”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      External locking occurs when the server and other programs
          lock
      <a class="link" href="myisam-storage-engine.html" title="18.2 The MyISAM Storage Engine">
       <code class="literal">
        MyISAM
       </code>
      </a>
      table files to
          coordinate among themselves which program can access the
          tables at which time. See
      <a class="xref" href="external-locking.html" title="10.11.5 External Locking">
       Section 10.11.5, “External Locking”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
