7.1.2 MyISAM Table Formats

MyISAM supports 3 different table types. Two of them are chosen automatically depending on the type of columns you are using. The third, compressed tables, can only be created with the myisampack tool.

When you CREATE or ALTER a table you can for tables that doesn't have BLOBs force the table format to DYNAMIC or FIXED with the ROW_FORMAT=# table option. In the future you will be able to compress/decompress tables by specifying ROW_FORMAT=compressed | default to ALTER TABLE. See section 6.5.3 CREATE TABLE Syntax.

Subsections

• 7.1.2.1 Static (Fixed-length) Table Characteristics
• 7.1.2.2 Dynamic Table Characteristics
• 7.1.2.3 Compressed Table Characteristics

User Comments

Add your own comment.