(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