MySQL 5.5 Release Notes
You specify the row format for a table with the
ROW_FORMAT clause of the
CREATE TABLE and
ALTER TABLE statements. For
example:
CREATE TABLE t1 (f1 int unsigned) ROW_FORMAT=DYNAMIC ENGINE=INNODB;
InnoDB ROW_FORMAT options
include COMPACT,
REDUNDANT,
DYNAMIC, and
COMPRESSED. For
InnoDB tables, rows are stored in
COMPACT format
(ROW_FORMAT=COMPACT) by default. Refer to the
CREATE TABLE documentation for
additional information about the ROW_FORMAT
table option.
The physical row structure of an InnoDB table
is dependant on the row format. See
Section 14.11.3, “Physical Row Structure of InnoDB Tables” for more information.