Name
myisampack
Synopsis
myisampack options table
[.MYI]
Use this to create compressed, read-only tables to reduce table sizes
and to increase retrieval speed. When reading compressed tables,
MySQL decompresses the data in memory. To decompress tables packed
with myisampack
, use myisamchk
with the --unpack
option. Note that tables that
are compressed and later decompressed should be reindexed using
myisamchk
. The pack_isam
utility works very much like myisampack
with the
same options, but on ISAM tables, which are deprecated. Here is an
alphabetical list of options for myisampack
, along
with a brief explanation of each:
-
--backup, -b
Has the utility create a backup of the given table (table.OLD).
-
--debug=
options, -# options
Sets debug options to log (e.g., `d:t:o, filename').
-
--force, -f
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, -?
Displays basic help information.
-
--join=
table
, -j
table
Instructs the utility to join tables given into one compressed table. The table structures must be identical.
-
--packlength=
bytes
, -p
bytes
Sets the size of the pointers for records to the number of bytes given (1, 2, or 3).
-
--silent, -s
Suppresses all information except error messages.
-
--temp_dir=
path
, -T
path
Instructs the utility to use the path given for the directory where it is to write temporary tables.
-
--test, -t
Has the utility test the compression process without actually ...
Get MySQL in a Nutshell 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.