14.8 InnoDB Row Storage and Row Formats

14.8.1 Overview of InnoDB Row Storage
14.8.2 Specifying the Row Format for a Table
14.8.3 DYNAMIC and COMPRESSED Row Formats
14.8.4 COMPACT and REDUNDANT Row Formats

This section discusses how InnoDB features such as table compression, off-page storage of long variable-length column values, and large index key prefixes (innodb_large_prefix) are controlled by the ROW_FORMAT clause of the CREATE TABLE statement. It also discusses considerations for choosing the right row format, and compatibility of row formats between MySQL releases.