Contact MySQL
|
Login
|
Register
The world's most popular open source database
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 5.7 Reference Manual
Preface and Legal Notices
General Information
Installing and Upgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
SQL Statement Syntax
The InnoDB Storage Engine
Introduction to InnoDB
Benefits of Using InnoDB Tables
Best Practices for InnoDB Tables
Verifying that InnoDB is the Default Storage Engine
Testing and Benchmarking with InnoDB
Turning Off InnoDB
InnoDB and the ACID Model
InnoDB Multi-Versioning
InnoDB Architecture
InnoDB In-Memory Structures
Buffer Pool
Change Buffer
Adaptive Hash Index
Log Buffer
InnoDB On-Disk Structures
Tables
Creating InnoDB Tables
The Physical Row Structure of an InnoDB Table
Moving or Copying InnoDB Tables
Converting Tables from MyISAM to InnoDB
AUTO_INCREMENT Handling in InnoDB
InnoDB and FOREIGN KEY Constraints
Limits on InnoDB Tables
Indexes
Clustered and Secondary Indexes
The Physical Structure of an InnoDB Index
Sorted Index Builds
InnoDB FULLTEXT Indexes
Tablespaces
The System Tablespace
File-Per-Table Tablespaces
General Tablespaces
Undo Tablespaces
The Temporary Tablespace
Creating a Tablespace Outside of the Data Directory
Copying Tablespaces to Another Instance
InnoDB Tablespace Encryption
InnoDB Data Dictionary
Doublewrite Buffer
Redo Log
Undo Logs
InnoDB Locking and Transaction Model
InnoDB Locking
InnoDB Transaction Model
Transaction Isolation Levels
autocommit, Commit, and Rollback
Consistent Nonlocking Reads
Locking Reads
Locks Set by Different SQL Statements in InnoDB
Phantom Rows
Deadlocks in InnoDB
An InnoDB Deadlock Example
Deadlock Detection and Rollback
How to Minimize and Handle Deadlocks
InnoDB Configuration
InnoDB Startup Configuration
Configuring InnoDB for Read-Only Operation
InnoDB Buffer Pool Configuration
Configuring InnoDB Buffer Pool Size
Configuring Multiple Buffer Pool Instances
Making the Buffer Pool Scan Resistant
Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)
Configuring InnoDB Buffer Pool Flushing
Fine-tuning InnoDB Buffer Pool Flushing
Saving and Restoring the Buffer Pool State
Configuring the Memory Allocator for InnoDB
Configuring Thread Concurrency for InnoDB
Configuring the Number of Background InnoDB I/O Threads
Using Asynchronous I/O on Linux
Configuring the InnoDB Master Thread I/O Rate
Configuring Spin Lock Polling
Configuring InnoDB Purge Scheduling
Configuring Optimizer Statistics for InnoDB
Configuring Persistent Optimizer Statistics Parameters
Configuring Non-Persistent Optimizer Statistics Parameters
Estimating ANALYZE TABLE Complexity for InnoDB Tables
Configuring the Merge Threshold for Index Pages
InnoDB Table and Page Compression
InnoDB Table Compression
Overview of Table Compression
Creating Compressed Tables
Tuning Compression for InnoDB Tables
Monitoring InnoDB Table Compression at Runtime
How Compression Works for InnoDB Tables
Compression for OLTP Workloads
SQL Compression Syntax Warnings and Errors
InnoDB Page Compression
InnoDB File-Format Management
Enabling File Formats
Verifying File Format Compatibility
Compatibility Check When InnoDB Is Started
Compatibility Check When a Table Is Opened
Identifying the File Format in Use
Modifying the File Format
InnoDB Row Storage and Row Formats
Overview of InnoDB Row Storage
Specifying the Row Format for a Table
DYNAMIC and COMPRESSED Row Formats
COMPACT and REDUNDANT Row Formats
InnoDB Disk I/O and File Space Management
InnoDB Disk I/O
File Space Management
InnoDB Checkpoints
Defragmenting a Table
Reclaiming Disk Space with TRUNCATE TABLE
InnoDB and Online DDL
Online DDL Operations
Online DDL Performance and Concurrency
Online DDL Space Requirements
Simplifying DDL Statements with Online DDL
Online DDL Failure Conditions
Online DDL Limitations
InnoDB Startup Options and System Variables
InnoDB INFORMATION_SCHEMA Tables
InnoDB INFORMATION_SCHEMA Tables about Compression
INNODB_CMP and INNODB_CMP_RESET
INNODB_CMPMEM and INNODB_CMPMEM_RESET
Using the Compression Information Schema Tables
InnoDB INFORMATION_SCHEMA Transaction and Locking Information
Using InnoDB Transaction and Locking Information
InnoDB Lock and Lock-Wait Information
Persistence and Consistency of InnoDB Transaction and Locking Information
InnoDB INFORMATION_SCHEMA System Tables
InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
InnoDB INFORMATION_SCHEMA Buffer Pool Tables
InnoDB INFORMATION_SCHEMA Metrics Table
InnoDB INFORMATION_SCHEMA Temporary Table Info Table
Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES
InnoDB Integration with MySQL Performance Schema
Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema
Monitoring InnoDB Mutex Waits Using Performance Schema
InnoDB Monitors
InnoDB Monitor Types
Enabling InnoDB Monitors
InnoDB Standard Monitor and Lock Monitor Output
InnoDB Backup and Recovery
InnoDB Backup
InnoDB Recovery
InnoDB and MySQL Replication
InnoDB memcached Plugin
Benefits of the InnoDB memcached Plugin
InnoDB memcached Architecture
Setting Up the InnoDB memcached Plugin
Security Considerations for the InnoDB memcached Plugin
Writing Applications for the InnoDB memcached Plugin
Adapting an Existing MySQL Schema for the InnoDB memcached Plugin
Adapting a memcached Application for the InnoDB memcached Plugin
Tuning InnoDB memcached Plugin Performance
Controlling Transactional Behavior of the InnoDB memcached Plugin
Adapting DML Statements to memcached Operations
Performing DML and DDL Statements on the Underlying InnoDB Table
The InnoDB memcached Plugin and Replication
InnoDB memcached Plugin Internals
Troubleshooting the InnoDB memcached Plugin
InnoDB Troubleshooting
Troubleshooting InnoDB I/O Problems
Forcing InnoDB Recovery
Troubleshooting InnoDB Data Dictionary Operations
InnoDB Error Handling
Alternative Storage Engines
Replication
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
MySQL NDB Cluster 7.5 and NDB Cluster 7.6
Partitioning
Stored Programs and Views
INFORMATION_SCHEMA Tables
MySQL Performance Schema
MySQL sys Schema
Connectors and APIs
Extending MySQL
MySQL Enterprise Edition
MySQL Workbench
MySQL 5.7 Frequently Asked Questions
Errors, Error Codes, and Common Problems
Restrictions and Limits
Indexes
MySQL Glossary
Related Documentation
MySQL 5.7 Release Notes
Download this Manual
PDF (US Ltr)
- 39.3Mb
PDF (A4)
- 39.3Mb
PDF (RPM)
- 38.6Mb
HTML Download (TGZ)
- 11.1Mb
HTML Download (Zip)
- 11.1Mb
HTML Download (RPM)
- 9.8Mb
Man Pages (TGZ)
- 212.5Kb
Man Pages (Zip)
- 321.6Kb
Info (Gzip)
- 3.6Mb
Info (Zip)
- 3.6Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5
MySQL Secure Deployment Guide
version 5.7
8.0 current
5.6
5.5
5.6 Japanese
MySQL 5.7 Reference Manual
/
The InnoDB Storage Engine
/ InnoDB On-Disk Structures
14.6 InnoDB On-Disk Structures
[
+/-
]
14.6.1 Tables
14.6.2 Indexes
14.6.3 Tablespaces
14.6.4 InnoDB Data Dictionary
14.6.5 Doublewrite Buffer
14.6.6 Redo Log
14.6.7 Undo Logs
This section describes
InnoDB
on-disk structures and related topics.
PREV
HOME
UP
NEXT
Related Documentation
MySQL 5.7 Release Notes
Download this Manual
PDF (US Ltr)
- 39.3Mb
PDF (A4)
- 39.3Mb
PDF (RPM)
- 38.6Mb
HTML Download (TGZ)
- 11.1Mb
HTML Download (Zip)
- 11.1Mb
HTML Download (RPM)
- 9.8Mb
Man Pages (TGZ)
- 212.5Kb
Man Pages (Zip)
- 321.6Kb
Info (Gzip)
- 3.6Mb
Info (Zip)
- 3.6Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and OS X
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5
MySQL Secure Deployment Guide
User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up
Login
You must be logged in to post a comment.