MySQL :: InnoDB 1.1 for MySQL 5.5 User’s Guide :: 2 Fast Index Creation in the InnoDB Storage Engine

InnoDB 1.1 for MySQL 5.5 User’s Guide :: 2 Fast Index Creation in the InnoDB Storage Engine

« 1.4 Compatibility Considerations for Downgrade and Backup

Section Navigation [Toggle]

1 Introduction to InnoDB 1.1
2 Fast Index Creation in the InnoDB Storage Engine
3 InnoDB Data Compression
4 InnoDB File-Format Management
5 How InnoDB Stores Variable-Length Columns
6 InnoDB INFORMATION_SCHEMA tables
7 InnoDB Performance and Scalability Enhancements
8 Changes for Flexibility, Ease of Use and Reliability
9 Installing the InnoDB Storage Engine
10 Upgrading the InnoDB Storage Engine
11 Downgrading the InnoDB Storage Engine
12 InnoDB Storage Engine Change History
A Third-Party Software
B List of Parameters Changed in InnoDB 1.1 and InnoDB Plugin 1.0
C InnoDB Glossary
Index

Chapter 2. Fast Index Creation in the InnoDB Storage Engine

Table of Contents [+/-]

2.1. Overview of Fast Index Creation
2.2. Examples of Fast Index Creation
2.3. Implementation Details of Fast Index Creation
2.4. Concurrency Considerations for Fast Index Creation
2.5. How Crash Recovery Works with Fast Index Creation
2.6. Limitations of Fast Index Creation

In MySQL 5.5 and higher, or in MySQL 5.1 with the InnoDB Plugin, creating and dropping secondary indexes does not copy the contents of the entire table, making this operation much more efficient than with prior releases.

This is the User’s Guide for the InnoDB storage engine 1.1 for MySQL 5.5, generated on 2012-05-23 (revision: 30566) .

Top / Previous / Next / Up / Table of Contents