InnoDB 1.1 for MySQL 5.5 User's Guide - Downloads

2.5 How Crash Recovery Works with Fast Index Creation . ...... Existing databases can be used with the InnoDB Storage Engine for MySQL. ...... A kind of database that primarily organizes data on disk storage (hard drives or equivalent). Data is ...
1MB Sizes 11 Downloads 125 Views
InnoDB 1.1 for MySQL 5.5 User's Guide

InnoDB 1.1 for MySQL 5.5 User's Guide Abstract This is the User's Guide for the InnoDB storage engine 1.1 for MySQL 5.5. Beginning with MySQL version 5.1, it is possible to swap out one version of the InnoDB storage engine and use another (the “plugin”). This manual documents the latest InnoDB plugin, version 1.1, which works with MySQL 5.5 and features cutting-edge improvements in performance and scalability. This User's Guide documents the procedures and features that are specific to the InnoDB storage engine 1.1 for MySQL 5.5. It supplements the general InnoDB information in the MySQL Reference Manual. Because InnoDB 1.1 is integrated with MySQL 5.5, it is generally available (GA) and production-ready. WARNING: Because the InnoDB storage engine 1.0 and above introduces a new file format, restrictions apply to the use of a database created with the InnoDB storage engine 1.0 and above, with earlier versions of InnoDB, when using mysqldump or MySQL replication and if you use the older InnoDB Hot Backup product rather than the newer MySQL Enterprise Backup product. See Section 1.4, “Compatibility Considerations for Downgrade and Backup”. For legal information, see the Legal Notices. Document generated on: 2014-01-30 (revision: 37565)

Table of Contents Preface and Legal Notices .................................................................................................................. v 1 Introduction to InnoDB 1.1 ............................................................................................................... 1 1.1 Features of the InnoDB Storage Engine ................................................................................ 1 1.2 Obtaining and Installing the InnoDB Storage Engine ............................................................... 3 1.3 Viewing the InnoDB Storage Engine Version Number ............................................................. 3 1.4 Compatibility Considerations for Downgrade and Backup ........................................................ 3 2 Fast Index Creation in the InnoDB Storage Engine ........................................................................... 5 2.1 Overview of Fast Index Creation ........................................................................................... 5 2.2 Examples of Fast Index Creation .......................................................................................... 5 2.3 Implementation Details of Fast Index Creation ....................................................................... 6 2.4 Concurrency Considerations for Fast Index Creation .............................................................. 7 2.5 How Crash Recovery Works with Fast Index Creation ............................................................ 7 2.6 Limitations of Fast Index Creation ......................................................................................... 7 3 Working with InnoDB Compressed Tables ....................................................................................... 9 3.1 Overview of Table Compression ............................................................................................ 9 3.2 Enabling Compression for a Table ........................................................................................ 9 3.2.1 Configuration Parameters for Compression ............................................................... 10 3.3 Tuning Compression for InnoDB Tables ............................................................................... 11 3.4 How Compression Works for InnoDB Tables ........................................................................ 14 3.5 SQL Compression Syntax Warnings and Errors ................................................................... 17 4 InnoDB File-Format Management .................................................................................................. 21 4.1 Enabling File Formats ............................................................................................