MySQL's Row_format

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

If a table contains a varchar, text, and its deformation, blob, and its deformed fields, then this table is actually called a dynamic table, that is, the table's Row_format is dynamically, which means that each record occupies a dynamic byte. Its advantages save space and disadvantage increase the read time overhead.

Therefore, to do large search query volume of the table is generally in exchange for space for time, designed to static table. Row_format There are some other values: default FIXED DYNAMIC compressed redundant COMPACT
Modify row format ALTER TABLE table_name ROW_FORMAT = DEFAULT modification process causes: Fixed--->dynamic: This causes char to become varchar dynamic--- ; fixed: This causes varchar to become char

MySQL's Row_format