MyISAM 支持三种不同的存储格式。其中两种,固定格式和动态格式,会根据你使用的列类型自动选择。第三种,压缩格式,只能通过 myisampack 工具创建(请参见 第 6.6.6 节,“myisampack — 生成压缩的只读 MyISAM 表格”)。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 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”).
当您对没有 BLOB 或 TEXT 列的表使用 CREATE TABLE 或 ALTER TABLE 时,可以使用 ROW_FORMAT 表选项强制将表格式设置为 FIXED 或 DYNAMIC。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.
有关 ROW_FORMAT 的信息,请参见 第 15.1.20 节,“CREATE TABLE 语句”。See Section 15.1.20, “CREATE TABLE Statement”, for information about
ROW_FORMAT.
您可以使用 myisamchk --unpack 解压(展开)压缩的 MyISAM 表;更多信息请参见 第 6.6.4 节,“myisamchk — MyISAM 表维护工具”。You can decompress (unpack) compressed MyISAM
tables using myisamchk
--unpack; see
Section 6.6.4, “myisamchk — MyISAM Table-Maintenance Utility”, for more information.