row format


The disk storage format for a row from an InnoDB table. As InnoDB gains new capabilities such as compression, new row formats are introduced to support the resulting improvements in storage efficiency and performance.

Each table has its own row format, specified through the ROW-FORMAT option. To see the row format for each InnoDB table, issue the command SHOW TABLE STATUS. Because all the tables in the system tablespace share the same row format, to take advantage of other row formats typically requires setting the innodb-file-per_table option, so that each table is stored in a separate tablespace.

See also compact row format.

See also compressed row format.

See also dynamic row format.

See also fixed row format.

See also redundant row format.

See also row.

See also table.

Retornar