Name
myisampack
Synopsis
myisampack options /path/table
[.MYI]
This utility creates compressed, read-only tables in order to
reduce table sizes and to increase retrieval speed. For the table, give
the path and table name. Optionally, you can include the
.MYI file extension with the table name. When
reading compressed tables, MySQL decompresses the data in memory. To
decompress tables packed with myisampack
, use
myisamchk
with the --unpack
option.
Tables that are compressed and later decompressed should be
reindexed using myisamchk
.
A sample run of this utility is:
myisamchk --verbose /data/mysql/testing/courses.MYI
Here is a list of options available for this utility in alphabetical order:
--backup
,-b
This option has the utility create a backup of the given table (
table
.OLD).--character-sets-dir=
filepath
This option specifies the directory containing the character sets the utility should use for sorting data.
--debug[=
,options
]-# [
options
]This option logs debugging information. The set of options used by default is
'd:t:o,logname'
. See Table 16-1 at the end of the list of options under themysqldump
utility for an explanation of these flags and others that may be used.--force
,-f
This option forces a compressed table to be created even if the results are larger than the original, and to overwrite a temporary table (
table
.TMD) if it exists.--help
,-?
This option displays basic help information.
--join=
,table
-j
table
This option instructs the utility to join the tables given into one compressed ...
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.