The world's most popular open source database
MySQL 5.5 Reference Manual :: 14 The InnoDB Storage Engine
Section Navigation [Toggle]
- Preface and Legal Notices
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Security
- 7 Backup and Recovery
- 8 Optimization
- 9 Language Structure
- 10 Globalization
- 11 Data Types
- 12 Functions and Operators
- 13 SQL Statement Syntax
- 14 The InnoDB Storage Engine
- 14.1 Introduction to InnoDB 1.1
- 14.2 Installing the InnoDB Storage Engine
- 14.3 Upgrading the InnoDB Storage Engine
- 14.4 Downgrading the InnoDB Storage Engine
- 14.5 InnoDB Concepts and Architecture
- 14.6 InnoDB Configuration
- 14.7 InnoDB Administration
- 14.8 InnoDB Tablespace Management
- 14.9 InnoDB Table Management
- 14.10 InnoDB Compressed Tables
- 14.11 InnoDB File-Format Management
- 14.12 InnoDB Row Storage and Row Formats
- 14.13 InnoDB Disk I/O and File Space Management
- 14.14 InnoDB Fast Index Creation
- 14.15 InnoDB Startup Options and System Variables
- 14.16 InnoDB Performance
- 14.17 InnoDB INFORMATION_SCHEMA Tables
- 14.18 InnoDB Monitors
- 14.19 InnoDB Backup and Recovery
- 14.20 InnoDB and MySQL Replication
- 14.21 InnoDB Troubleshooting
- 15 Alternative Storage Engines
- 16 High Availability and Scalability
- 17 Replication
- 18 MySQL Cluster NDB 7.2
- 19 Partitioning
- 20 Stored Programs and Views
- 21 INFORMATION_SCHEMA Tables
- 22 MySQL Performance Schema
- 23 Connectors and APIs
- 24 Extending MySQL
- 25 MySQL Enterprise Edition
- 26 MySQL Workbench
- A MySQL 5.5 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Release Notes
- D Restrictions and Limits
- MySQL Glossary
- E Licenses for Third-Party Components
- General Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Join Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Statement/Syntax Index
- Status Variable Index
- System Variable Index
Table of Contents [+/-]
- 14.1 Introduction to InnoDB 1.1 [+/-]
- 14.1.1 Features of the InnoDB Storage Engine
- 14.1.2 InnoDB as the Default MySQL Storage Engine
- 14.1.3 Checking InnoDB Availability
- 14.1.4 Turning Off InnoDB
- 14.1.5 Obtaining and Installing the InnoDB Storage Engine
- 14.1.6 Viewing the InnoDB Storage Engine Version Number
- 14.1.7 Compatibility Considerations for Downgrade and Backup
- 14.1.8 InnoDB Storage Engine Change History
- 14.1.9 Third-Party Software Contributions
- 14.2 Installing the InnoDB Storage Engine
- 14.3 Upgrading the InnoDB Storage Engine
- 14.4 Downgrading the InnoDB Storage Engine [+/-]
- 14.5 InnoDB Concepts and Architecture [+/-]
- 14.5.1 MySQL and the ACID Model
- 14.5.2 The InnoDB Transaction Model and Locking
- 14.5.3 InnoDB Lock Modes
- 14.5.4 Consistent Nonlocking Reads
- 14.5.5 Locking Reads (SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE)
- 14.5.6 InnoDB Record, Gap, and Next-Key Locks
- 14.5.7 Avoiding the Phantom Problem Using Next-Key Locking
- 14.5.8 Locks Set by Different SQL Statements in InnoDB
- 14.5.9 Implicit Transaction Commit and Rollback
- 14.5.10 Deadlock Detection and Rollback
- 14.5.11 How to Cope with Deadlocks
- 14.5.12 InnoDB Multi-Versioning
- 14.5.13 InnoDB Table and Index Structures
- 14.6 InnoDB Configuration
- 14.7 InnoDB Administration
- 14.8 InnoDB Tablespace Management [+/-]
- 14.9 InnoDB Table Management [+/-]
- 14.10 InnoDB Compressed Tables [+/-]
- 14.11 InnoDB File-Format Management [+/-]
- 14.12 InnoDB Row Storage and Row Formats [+/-]
- 14.13 InnoDB Disk I/O and File Space Management [+/-]
- 14.14 InnoDB Fast Index Creation [+/-]
- 14.15 InnoDB Startup Options and System Variables
- 14.16 InnoDB Performance [+/-]
- 14.16.1 Overview of InnoDB Performance
- 14.16.2 InnoDB Buffer Pool Configuration
- 14.16.3 InnoDB Mutex and Read/Write Lock Implementation
- 14.16.4 Configuring the Memory Allocator for InnoDB
- 14.16.5 Configuring InnoDB Change Buffering
- 14.16.6 Configuring Thread Concurrency for InnoDB
- 14.16.7 Configuring the Number of Background InnoDB I/O Threads
- 14.16.8 Group Commit
- 14.16.9 Configuring the InnoDB Master Thread I/O Rate
- 14.16.10 Using the PAUSE Instruction in InnoDB Spin Loops
- 14.16.11 Configuring Spin Lock Polling
- 14.16.12 InnoDB Integration with MySQL Performance Schema
- 14.16.13 Better Scalability with Multiple Rollback Segments
- 14.16.14 Configuring InnoDB Purge Scheduling
- 14.16.15 Configuring Optimizer Statistics Parameters
- 14.16.16 Estimating ANALYZE TABLE Complexity for InnoDB Tables
- 14.17 InnoDB INFORMATION_SCHEMA Tables [+/-]
- 14.18 InnoDB Monitors [+/-]
- 14.19 InnoDB Backup and Recovery [+/-]
- 14.20 InnoDB and MySQL Replication
- 14.21 InnoDB Troubleshooting [+/-]
User Comments