You automatically benefit from the “fast index creation”
feature for every index you create on a large InnoDB table.
If you switch to the “Barracuda” file format using the
innodb_file_format
option in combination
with the innodb_file_per_table
option, you can
take advantage of other features such as table compression.
For the full list of features, refer to
Section 1.2, “Features of the InnoDB Plugin”.
This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).