Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
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 Statements
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
Creating Tables Externally
Importing InnoDB Tables
Moving or Copying InnoDB Tables
Converting Tables from MyISAM to InnoDB
AUTO_INCREMENT Handling in InnoDB
Indexes
Clustered and Secondary Indexes
The Physical Structure of an InnoDB Index
Sorted Index Builds
InnoDB Full-Text Indexes
Tablespaces
The System Tablespace
File-Per-Table Tablespaces
General Tablespaces
Undo Tablespaces
The Temporary Tablespace
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
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 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 InnoDB I/O Capacity
Configuring Spin Lock Polling
Purge Configuration
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 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 Data-at-Rest Encryption
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
InnoDB Limits
InnoDB Restrictions and Limitations
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 Objects
INFORMATION_SCHEMA Tables
MySQL Performance Schema
MySQL sys Schema
Connectors and APIs
MySQL Enterprise Edition
MySQL Workbench
MySQL 5.7 Frequently Asked Questions
Error Messages and Common Problems
Indexes
MySQL Glossary
Related Documentation
MySQL 5.7 Release Notes
Download this Manual
PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
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
version 5.7
9.1
9.0
8.4 current
8.0
8.0 Japanese
MySQL 5.7 Reference Manual
/
...
/
The InnoDB Storage Engine
/
InnoDB Configuration
/
InnoDB Buffer Pool Configuration
14.8.3 InnoDB Buffer Pool Configuration
14.8.3.1 Configuring InnoDB Buffer Pool Size
14.8.3.2 Configuring Multiple Buffer Pool Instances
14.8.3.3 Making the Buffer Pool Scan Resistant
14.8.3.4 Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)
14.8.3.5 Configuring Buffer Pool Flushing
14.8.3.6 Saving and Restoring the Buffer Pool State
This section provides configuration and tuning information for the
InnoDB
buffer pool.
PREV
HOME
UP
NEXT
Related Documentation
MySQL 5.7 Release Notes
Download this Manual
PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
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