Row_format of Mysql

Mysql's row_format is in mysql. If a table does not contain varchar, text, its deformation, blob, and its deformation fields, this table is also called a static table, that is, the row_format of the table is fixed, that is, each record occupies the same bytes. Its advantage is fast reading, and its disadvantage is a waste of additional space. Www.2cto.com if a table contains varchar, text, its deformation, blob, and its deformation fields, then this table is also called a dynamic table, that is, the row_format of this table is dynamic, that is to say, the bytes occupied by each record are dynamic. Its advantages are space saving and its disadvantages increase the read time overhead. Therefore, tables with a large number of search queries generally exchange space for time and are designed as static tables. Row_format has other values: DEFAULTFIXEDDYNAMICCOMPRESSEDREDUNDANTCOMPACT www.2cto.com modifying the row format alter table table_name ROW_FORMAT = DEFAULT cause: fixed ---> dynamic: This causes CHAR to change to VARCHARdynamic ---> fixed: this will cause VARCHAR to become CHAR author Zhang weijian