mysql| table Row_format Static and dynamic, Compact

InnoDB generally corresponds to Compact, MyISAM generally corresponds to static and dynamic

In MySQL, if there is a table with varchar, text, and its deformation, blob, and its deformed fields, then this table is actually called a dynamic table, that is, the table is the Row_format, which is dynamic, that is, the bytes occupied by each record. Its advantages save space and disadvantage increase the read time overhead. Conversely, this table is called a static table, which Row_format is fixed, that is, each record consumes bytes. Advantage read fast, disadvantage waste part of space

Therefore, to do large search query volume of the table is generally in exchange for space for time, designed to static table.

Row_format also has some other values:

DEFAULT
FIXED
DYNAMIC
Compressed
Redundant
COMPACT

Modify row format

ALTER TABLE table_name Row_format = DEFAULT

The modification process causes:

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

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

mysql| table Row_format Static and dynamic, Compact