89401

MyisAMTable Storage Formats

MylSAMsupports three different storage formats. Two of them, fixed and dynamie format, are chosen

automatically depending on the type of columns you are using. The third, compressed format, can be

created only with the myisampackutility (see Section 4.6.5, “myisampack— Generate Compressed,

Read-Only MylSAM Tables”).

When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT columns, you

can force the table format to FIXED or DYNAMIC with the ROW_FORMAT table option.

See Section 13.1.17, “CREATE TABLE Syntax", for information about ROW_FORMAT. You can decompress (unpack) compressed MylSAMtables using myisamchk — unpack [334];see

Section 4.6.3, "myisamchk— MylSAM Table-Maintenance Utility’’, for morę information.