O'Reilly logo

MySQL in a Nutshell by Russell J.T. Dyer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required