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 9.4 Reference Manual
Preface and Legal Notices
General Information
Installing MySQL
Upgrading MySQL
Downgrading 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
MySQL Data Dictionary
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
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
Temporary Tablespaces
Moving Tablespace Files While the Server is Offline
Disabling Tablespace Path Validation
Optimizing Tablespace Space Allocation on Linux
Tablespace AUTOEXTEND_SIZE Configuration
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
Transaction Scheduling
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
Excluding or Including Buffer Pool Pages from Core Files
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
Container Detection and Configuration
Enabling Automatic InnoDB Configuration for a Dedicated MySQL Server
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 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
Online DDL Memory Management
Configuring Parallel Threads for Online DDL Operations
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 Schema Object 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 Troubleshooting
Troubleshooting InnoDB I/O Problems
Troubleshooting Recovery Failures
Forcing InnoDB Recovery
Troubleshooting InnoDB Data Dictionary Operations
InnoDB Error Handling
InnoDB Limits
InnoDB Restrictions and Limitations
Alternative Storage Engines
Replication
Group Replication