Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 28.9Mb
PDF (A4) - 28.9Mb
PDF (RPM) - 27.9Mb
HTML Download (TGZ) - 7.0Mb
HTML Download (Zip) - 7.1Mb
HTML Download (RPM) - 6.1Mb
Man Pages (TGZ) - 180.3Kb
Man Pages (Zip) - 290.2Kb
Info (Gzip) - 2.8Mb
Info (Zip) - 2.8Mb
Excerpts from this Manual

MySQL 5.6 Reference Manual  /  The InnoDB Storage Engine

Chapter 14 The InnoDB Storage Engine

Table of Contents

14.1 Introduction to InnoDB
14.1.1 Benefits of Using InnoDB Tables
14.1.2 Best Practices for InnoDB Tables
14.1.3 Checking InnoDB Availability
14.1.4 Testing and Benchmarking with InnoDB
14.1.5 Turning Off InnoDB
14.2 InnoDB and the ACID Model
14.3 InnoDB Multi-Versioning
14.4 InnoDB Architecture
14.5 InnoDB In-Memory Structures
14.5.1 Buffer Pool
14.5.2 Change Buffer
14.5.3 Adaptive Hash Index
14.5.4 Log Buffer
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
14.7 InnoDB Locking and Transaction Model
14.7.1 InnoDB Locking
14.7.2 InnoDB Transaction Model
14.7.3 Locks Set by Different SQL Statements in InnoDB
14.7.4 Phantom Rows
14.7.5 Deadlocks in InnoDB
14.8 InnoDB Configuration
14.8.1 InnoDB Startup Configuration
14.8.2 Configuring InnoDB for Read-Only Operation
14.8.3 InnoDB Buffer Pool Configuration
14.8.4 Configuring the Memory Allocator for InnoDB
14.8.5 Configuring Thread Concurrency for InnoDB
14.8.6 Configuring the Number of Background InnoDB I/O Threads
14.8.7 Using Asynchronous I/O on Linux
14.8.8 Configuring InnoDB I/O Capacity
14.8.9 Configuring Spin Lock Polling
14.8.10 Purge Configuration
14.8.11 Configuring Optimizer Statistics for InnoDB
14.8.12 Configuring the Merge Threshold for Index Pages
14.9 InnoDB Table Compression
14.9.1 Overview of Table Compression
14.9.2 Enabling Compression for a Table
14.9.3 Tuning Compression for InnoDB Tables
14.9.4 Monitoring InnoDB Table Compression at Runtime
14.9.5 How Compression Works for InnoDB Tables
14.9.6 Compression for OLTP Workloads
14.9.7 SQL Compression Syntax Warnings and Errors
14.10 InnoDB File-Format Management
14.10.1 Enabling File Formats
14.10.2 Verifying File Format Compatibility
14.10.3 Identifying the File Format in Use
14.10.4 Modifying the File Format
14.11 InnoDB Row Formats
14.12 InnoDB Disk I/O and File Space Management
14.12.1 InnoDB Disk I/O
14.12.2 File Space Management
14.12.3 InnoDB Checkpoints
14.12.4 Defragmenting a Table
14.12.5 Reclaiming Disk Space with TRUNCATE TABLE
14.13 InnoDB and Online DDL
14.13.1 Online DDL Operations
14.13.2 Online DDL Performance and Concurrency
14.13.3 Online DDL Space Requirements
14.13.4 Simplifying DDL Statements with Online DDL
14.13.5 Online DDL Failure Conditions
14.13.6 Online DDL Limitations
14.14 InnoDB Startup Options and System Variables
14.15 InnoDB INFORMATION_SCHEMA Tables
14.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression
14.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information
14.15.3 InnoDB INFORMATION_SCHEMA System Tables
14.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
14.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
14.15.6 InnoDB INFORMATION_SCHEMA Metrics Table
14.16 InnoDB Integration with MySQL Performance Schema
14.16.1 Monitoring InnoDB Mutex Waits Using Performance Schema
14.17 InnoDB Monitors
14.17.1 InnoDB Monitor Types
14.17.2 Enabling InnoDB Monitors
14.17.3 InnoDB Standard Monitor and Lock Monitor Output
14.17.4 InnoDB Tablespace Monitor Output
14.17.5 InnoDB Table Monitor Output
14.18 InnoDB Backup and Recovery
14.18.1 InnoDB Backup
14.18.2 InnoDB Recovery
14.19 InnoDB and MySQL Replication
14.20 InnoDB memcached Plugin
14.20.1 Benefits of the InnoDB memcached Plugin
14.20.2 InnoDB memcached Architecture
14.20.3 Setting Up the InnoDB memcached Plugin
14.20.4 Security Considerations for the InnoDB memcached Plugin
14.20.5 Writing Applications for the InnoDB memcached Plugin
14.20.6 The InnoDB memcached Plugin and Replication
14.20.7 InnoDB memcached Plugin Internals
14.20.8 Troubleshooting the InnoDB memcached Plugin
14.21 InnoDB Troubleshooting
14.21.1 Troubleshooting InnoDB I/O Problems
14.21.2 Forcing InnoDB Recovery
14.21.3 Troubleshooting InnoDB Data Dictionary Operations
14.21.4 InnoDB Error Handling
14.22 InnoDB Limits
14.23 InnoDB Restrictions and Limitations