DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) MyISAM table formats

Info Catalog (mysql.info.gz) Key space (mysql.info.gz) MyISAM storage engine (mysql.info.gz) MyISAM table problems
 
 14.1.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 the `myisampack' utility.
 
 When you `CREATE' or `ALTER' 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. This causes `CHAR' and `VARCHAR' columns
 to become `CHAR' for `FIXED' format or `VARCHAR' for `DYNAMIC' format.
 
 In the future, you will be able to compress or decompress tables by
 specifying `ROW_FORMAT={COMPRESSED | DEFAULT}' to `ALTER TABLE'.  
 `CREATE TABLE' CREATE TABLE.
 

Menu

 
* Static format               Static (Fixed-Length) Table Characteristics
* Dynamic format              Dynamic Table Characteristics
* Compressed format           Compressed Table Characteristics
 
Info Catalog (mysql.info.gz) Key space (mysql.info.gz) MyISAM storage engine (mysql.info.gz) MyISAM table problems
automatically generated byinfo2html