(mysql.info.gz) myisamchk other options
Info Catalog
(mysql.info.gz) myisamchk repair options
(mysql.info.gz) Table maintenance
(mysql.info.gz) myisamchk memory
5.7.3.5 Other Options for `myisamchk'
.....................................
`myisamchk' supports the following options for actions other than table
checks and repairs:
`--analyze, -a'
Analyze the distribution of keys. This improves join performance
by enabling the join optimizer to better choose the order in which
to join the tables and which keys it should use. To obtain
information about the distribution, use a `myisamchk --description
--verbose TBL_NAME' command or the `SHOW KEYS FROM TBL_NAME'
statement.
`--description, -d'
Print some descriptive information about the table.
`--set-auto-increment[=VALUE], -A[VALUE]'
Force `AUTO_INCREMENT' numbering for new records to start at the
given value (or higher, if there are existing records with
`AUTO_INCREMENT' values this large). If VALUE is not specified,
`AUTO_INCREMENT' number for new records begins with the largest
value currently in the table, plus one.
`--sort-index, -S'
Sort the index tree blocks in high-low order. This optimizes
seeks and makes table scanning by key faster.
`--sort-records=#, -R #'
Sort records according to a particular index. This makes your
data much more localized and may speed up range-based `SELECT' and
`ORDER BY' operations that use this index. (The first time you use
this option to sort a table, it may be very slow.) To determine a
table's index numbers, use `SHOW KEYS', which displays a table's
indexes in the same order that `myisamchk' sees them. Indexes are
numbered beginning with 1.
Info Catalog
(mysql.info.gz) myisamchk repair options
(mysql.info.gz) Table maintenance
(mysql.info.gz) myisamchk memory
automatically generated byinfo2html