MyISAM supports three different storage
formats. Two of them, fixed and dynamic format, are chosen
automatically depending on the type of columns you are using. The
third, compressed format, can be created only with the
myisampack utility (see
Section 4.6.5, “myisampack — Generate Compressed, Read-Only MyISAM Tables”).
When you use
CREATE TABLE or
ALTER TABLE for a table that has no
TEXT columns, you can force the
table format to
DYNAMIC with the
See Section 13.1.18, “CREATE TABLE Statement”, for information about
You can decompress (unpack) compressed
tables using myisamchk
Section 4.6.3, “myisamchk — MyISAM Table-Maintenance Utility”, for more information.