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 compressing the table.
- --verbose, -v
-
Displays information about the compression process.
- --version, -V
-
Displays the version of the utility.
- --wait, -w
-
Instructs the utility to wait before compressing if the table is locked by another client or utility.
|
