Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

18.2.3 MyISAM Table Storage Formats

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 themyisampack utility (seeSection 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”).

When you useCREATE TABLE orALTER TABLE for a table that has noBLOB orTEXT columns, you can force the table format toFIXED orDYNAMIC with theROW_FORMAT table option.

SeeSection 15.1.20, “CREATE TABLE Statement”, for information aboutROW_FORMAT.

You can decompress (unpack) compressedMyISAM tables usingmyisamchk--unpack; seeSection 6.6.4, “myisamchk — MyISAM Table-Maintenance Utility”, for more information.