<div id="docs-body">
 <div class="chapter">
  <div class="titlepage">
   <div>
    <div>
     <h1 class="title">
      <a name="innodb-storage-engine">
      </a>
      Chapter 17 The InnoDB Storage Engine
     </h1>
    </div>
   </div>
  </div>
  <div class="toc">
   <p>
    <b>
     Table of Contents
    </b>
   </p>
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="innodb-introduction.html">
       17.1 Introduction to InnoDB
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-benefits.html">
         17.1.1 Benefits of Using InnoDB Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-best-practices.html">
         17.1.2 Best Practices for InnoDB Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-check-availability.html">
         17.1.3 Verifying that InnoDB is the Default Storage Engine
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-benchmarking.html">
         17.1.4 Testing and Benchmarking with InnoDB
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="mysql-acid.html">
       17.2 InnoDB and the ACID Model
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-multi-versioning.html">
       17.3 InnoDB Multi-Versioning
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-architecture.html">
       17.4 InnoDB Architecture
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-in-memory-structures.html">
       17.5 InnoDB In-Memory Structures
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-buffer-pool.html">
         17.5.1 Buffer Pool
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-change-buffer.html">
         17.5.2 Change Buffer
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-adaptive-hash.html">
         17.5.3 Adaptive Hash Index
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-redo-log-buffer.html">
         17.5.4 Log Buffer
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-on-disk-structures.html">
       17.6 InnoDB On-Disk Structures
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-tables.html">
         17.6.1 Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-indexes.html">
         17.6.2 Indexes
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-tablespace.html">
         17.6.3 Tablespaces
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-doublewrite-buffer.html">
         17.6.4 Doublewrite Buffer
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-redo-log.html">
         17.6.5 Redo Log
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-undo-logs.html">
         17.6.6 Undo Logs
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-locking-transaction-model.html">
       17.7 InnoDB Locking and Transaction Model
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-locking.html">
         17.7.1 InnoDB Locking
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-transaction-model.html">
         17.7.2 InnoDB Transaction Model
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-locks-set.html">
         17.7.3 Locks Set by Different SQL Statements in InnoDB
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-next-key-locking.html">
         17.7.4 Phantom Rows
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-deadlocks.html">
         17.7.5 Deadlocks in InnoDB
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-transaction-scheduling.html">
         17.7.6 Transaction Scheduling
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-configuration.html">
       17.8 InnoDB Configuration
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-init-startup-configuration.html">
         17.8.1 InnoDB Startup Configuration
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-read-only-instance.html">
         17.8.2 Configuring InnoDB for Read-Only Operation
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-performance-buffer-pool.html">
         17.8.3 InnoDB Buffer Pool Configuration
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-performance-thread_concurrency.html">
         17.8.4 Configuring Thread Concurrency for InnoDB
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-performance-multiple_io_threads.html">
         17.8.5 Configuring the Number of Background InnoDB I/O Threads
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-linux-native-aio.html">
         17.8.6 Using Asynchronous I/O on Linux
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-configuring-io-capacity.html">
         17.8.7 Configuring InnoDB I/O Capacity
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-performance-spin_lock_polling.html">
         17.8.8 Configuring Spin Lock Polling
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-purge-configuration.html">
         17.8.9 Purge Configuration
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-performance-optimizer-statistics.html">
         17.8.10 Configuring Optimizer Statistics for InnoDB
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="index-page-merge-threshold.html">
         17.8.11 Configuring the Merge Threshold for Index Pages
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-dedicated-server.html">
         17.8.12 Enabling Automatic InnoDB Configuration for a Dedicated MySQL Server
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-compression.html">
       17.9 InnoDB Table and Page Compression
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-table-compression.html">
         17.9.1 InnoDB Table Compression
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-page-compression.html">
         17.9.2 InnoDB Page Compression
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-row-format.html">
       17.10 InnoDB Row Formats
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-disk-management.html">
       17.11 InnoDB Disk I/O and File Space Management
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-disk-io.html">
         17.11.1 InnoDB Disk I/O
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-file-space.html">
         17.11.2 File Space Management
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-checkpoints.html">
         17.11.3 InnoDB Checkpoints
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-file-defragmenting.html">
         17.11.4 Defragmenting a Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-truncate-table-reclaim-space.html">
         17.11.5 Reclaiming Disk Space with TRUNCATE TABLE
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-online-ddl.html">
       17.12 InnoDB and Online DDL
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-online-ddl-operations.html">
         17.12.1 Online DDL Operations
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-online-ddl-performance.html">
         17.12.2 Online DDL Performance and Concurrency
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-online-ddl-space-requirements.html">
         17.12.3 Online DDL Space Requirements
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="online-ddl-memory-management.html">
         17.12.4 Online DDL Memory Management
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="online-ddl-parallel-thread-configuration.html">
         17.12.5 Configuring Parallel Threads for Online DDL Operations
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-online-ddl-single-multi.html">
         17.12.6 Simplifying DDL Statements with Online DDL
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-online-ddl-failure-conditions.html">
         17.12.7 Online DDL Failure Conditions
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-online-ddl-limitations.html">
         17.12.8 Online DDL Limitations
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-data-encryption.html">
       17.13 InnoDB Data-at-Rest Encryption
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-parameters.html">
       17.14 InnoDB Startup Options and System Variables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema.html">
       17.15 InnoDB INFORMATION_SCHEMA Tables
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-information-schema-compression-tables.html">
         17.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-information-schema-transactions.html">
         17.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-information-schema-system-tables.html">
         17.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-information-schema-fulltext_index-tables.html">
         17.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-information-schema-buffer-pool-tables.html">
         17.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-information-schema-metrics-table.html">
         17.15.6 InnoDB INFORMATION_SCHEMA Metrics Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-information-schema-temp-table-info.html">
         17.15.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-information-schema-files-table.html">
         17.15.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-performance-schema.html">
       17.16 InnoDB Integration with MySQL Performance Schema
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="monitor-alter-table-performance-schema.html">
         17.16.1 Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance
Schema
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="monitor-innodb-mutex-waits-performance-schema.html">
         17.16.2 Monitoring InnoDB Mutex Waits Using Performance Schema
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-monitors.html">
       17.17 InnoDB Monitors
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-monitor-types.html">
         17.17.1 InnoDB Monitor Types
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-enabling-monitors.html">
         17.17.2 Enabling InnoDB Monitors
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-standard-monitor.html">
         17.17.3 InnoDB Standard Monitor and Lock Monitor Output
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-backup-recovery.html">
       17.18 InnoDB Backup and Recovery
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="innodb-backup.html">
         17.18.1 InnoDB Backup
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-recovery.html">
         17.18.2 InnoDB Recovery
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-and-mysql-replication.html">
       17.19 InnoDB and MySQL Replication
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-troubleshooting.html">
       17.20 InnoDB Troubleshooting
      </a>
     </span>
    </dt>
    <dd>
     <dl>
      <dt>
       <span class="section">
        <a href="error-creating-innodb.html">
         17.20.1 Troubleshooting InnoDB I/O Problems
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-troubleshooting-recovery.html">
         17.20.2 Troubleshooting Recovery Failures
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="forcing-innodb-recovery.html">
         17.20.3 Forcing InnoDB Recovery
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-troubleshooting-datadict.html">
         17.20.4 Troubleshooting InnoDB Data Dictionary Operations
        </a>
       </span>
      </dt>
      <dt>
       <span class="section">
        <a href="innodb-error-handling.html">
         17.20.5 InnoDB Error Handling
        </a>
       </span>
      </dt>
     </dl>
    </dd>
    <dt>
     <span class="section">
      <a href="innodb-limits.html">
       17.21 InnoDB Limits
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-restrictions-limitations.html">
       17.22 InnoDB Restrictions and Limitations
      </a>
     </span>
    </dt>
   </dl>
  </div>
 </div>
 <br/>
</div>
