Mysql Row_format Parameter explanation

When I changed the data engine today, it suddenly appeared.

Table storage engine for ' #sql -3e9_132 ' doesn ' t has this option

Such a hint:

Through the search, found some clues, the following is the explanation for the Row_format parameter:

In MySQL, if a table contains no varchar, text, and its deformation, blob, and its deformed fields, then this table is actually called static table [static/fixed], that is, the table row_format is fixed, This means that each record occupies the same amount of bytes. The advantages of reading fast, the disadvantage of wasting an extra portion of space.

So in actual development, this kind of table is very few, most of the table field types are many kinds of, then this kind of table is called: Dynamic: The advantage is space saving, disadvantage is the cost of reading time

The values of the Row_format are as follows:

DEFAULT

FIXED

DYNAMIC

Compressed

Redundant

COMPACT

To modify the parameters of the Row_format:

ALTER TABLE table_name Row_format = DEFAULT

Result of command execution:

Fixed--->dynamic: This causes char to become varchar

Dynamic--->fixed: This causes varchar to become char

Note: This property is supported only in the MYSAM database engine:

mysql> ALTER TABLE oem_idlib row_format = fixed; ERROR 1478 (HY000): Table storage engine ' InnoDB ' does not support the Create option ' Row_type '

　　

Mysql Row_format Parameter explanation