<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="myisamchk">
      </a>
      6.6.4 myisamchk — MyISAM Table-Maintenance Utility
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="myisamchk-general-options.html">
       6.6.4.1 myisamchk General Options
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="myisamchk-check-options.html">
       6.6.4.2 myisamchk Check Options
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="myisamchk-repair-options.html">
       6.6.4.3 myisamchk Repair Options
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="myisamchk-other-options.html">
       6.6.4.4 Other myisamchk Options
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="myisamchk-table-info.html">
       6.6.4.5 Obtaining Table Information with myisamchk
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="myisamchk-memory.html">
       6.6.4.6 myisamchk Memory Usage
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045307751424">
  </a>
  <p>
   The
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   utility gets information about
        your database tables or checks, repairs, or optimizes them.
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   works with
   <code class="literal">
    MyISAM
   </code>
   tables (tables that have
   <code class="filename">
    .MYD
   </code>
   and
   <code class="filename">
    .MYI
   </code>
   files
        for storing data and indexes).
  </p>
  <p>
   You can also use the
   <a class="link" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
    <code class="literal">
     CHECK TABLE
    </code>
   </a>
   and
   <a class="link" href="repair-table.html" title="15.7.3.5 REPAIR TABLE Statement">
    <code class="literal">
     REPAIR TABLE
    </code>
   </a>
   statements to
        check and repair
   <code class="literal">
    MyISAM
   </code>
   tables. See
   <a class="xref" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
    Section 15.7.3.2, “CHECK TABLE Statement”
   </a>
   , and
   <a class="xref" href="repair-table.html" title="15.7.3.5 REPAIR TABLE Statement">
    Section 15.7.3.5, “REPAIR TABLE Statement”
   </a>
   .
  </p>
  <p>
   The use of
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   with partitioned tables
        is not supported.
  </p>
  <div class="caution" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Caution
   </div>
   <p>
    It is best to make a backup of a table before performing a
          table repair operation; under some circumstances the operation
          might cause data loss. Possible causes include but are not
          limited to file system errors.
   </p>
  </div>
  <p>
   Invoke
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa87376921"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisamchk <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span> <em class="replaceable">tbl_name</em> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span></code></pre>
  </div>
  <p>
   The
   <em class="replaceable">
    <code>
     options
    </code>
   </em>
   specify what you want
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   to do. They are described in the
        following sections. You can also get a list of options by
        invoking
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk --help
     </strong>
    </span>
   </a>
   .
  </p>
  <p>
   With no options,
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   simply checks your
        table as the default operation. To get more information or to
        tell
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   to take corrective action,
        specify options as described in the following discussion.
  </p>
  <p>
   <em class="replaceable">
    <code>
     tbl_name
    </code>
   </em>
   is the database table you
        want to check or repair. If you run
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   somewhere other than in the database directory, you must specify
        the path to the database directory, because
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   has no idea where the database is
        located. In fact,
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   does not actually
        care whether the files you are working on are located in a
        database directory. You can copy the files that correspond to a
        database table into some other location and perform recovery
        operations on them there.
  </p>
  <p>
   You can name several tables on the
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   command line if you wish. You can also specify a table by naming
        its index file (the file with the
   <code class="filename">
    .MYI
   </code>
   suffix). This enables you to specify all tables in a directory
        by using the pattern
   <code class="filename">
    *.MYI
   </code>
   . For example, if
        you are in a database directory, you can check all the
   <code class="literal">
    MyISAM
   </code>
   tables in that directory like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa75270679"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisamchk *<span class="token punctuation">.</span>MYI</code></pre>
  </div>
  <p>
   If you are not in the database directory, you can check all the
        tables there by specifying the path to the directory:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa83915613"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisamchk <em class="replaceable">/path/to/database_dir/</em>*<span class="token punctuation">.</span>MYI</code></pre>
  </div>
  <p>
   You can even check all tables in all databases by specifying a
        wildcard with the path to the MySQL data directory:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa66496"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisamchk <em class="replaceable">/path/to/datadir/*/*</em><span class="token punctuation">.</span>MYI</code></pre>
  </div>
  <p>
   The recommended way to quickly check all
   <code class="literal">
    MyISAM
   </code>
   tables is:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa59562425"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisamchk <span class="token property">--silent</span> <span class="token property">--fast</span> <em class="replaceable">/path/to/datadir/*/*</em><span class="token punctuation">.</span>MYI</code></pre>
  </div>
  <p>
   If you want to check all
   <code class="literal">
    MyISAM
   </code>
   tables and
        repair any that are corrupted, you can use the following
        command:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa18769702"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisamchk <span class="token property">--silent</span> <span class="token property">--force</span> <span class="token property">--fast</span> <span class="token property">--update-state</span> \
          <span class="token constant">--key_buffer_size</span><span class="token attr-value"><span class="token punctuation">=</span>64M</span> <span class="token constant">--myisam_sort_buffer_size</span><span class="token attr-value"><span class="token punctuation">=</span>64M</span> \
          <span class="token constant">--read_buffer_size</span><span class="token attr-value"><span class="token punctuation">=</span>1M</span> <span class="token constant">--write_buffer_size</span><span class="token attr-value"><span class="token punctuation">=</span>1M</span> \
          <em class="replaceable">/path/to/datadir/*/*</em><span class="token punctuation">.</span>MYI</code></pre>
  </div>
  <p>
   This command assumes that you have more than 64MB free. For more
        information about memory allocation with
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   , see
   <a class="xref" href="myisamchk-memory.html" title="6.6.4.6 myisamchk Memory Usage">
    Section 6.6.4.6, “myisamchk Memory Usage”
   </a>
   .
  </p>
  <p>
   For additional information about using
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   , see
   <a class="xref" href="myisam-table-maintenance.html" title="9.6 MyISAM Table Maintenance and Crash Recovery">
    Section 9.6, “MyISAM Table Maintenance and Crash Recovery”
   </a>
   .
  </p>
  <div class="important" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Important
   </div>
   <p>
    <span class="emphasis">
     <em>
      You must ensure that no other program is using the
          tables while you are running
      <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
       <span class="command">
        <strong>
         myisamchk
        </strong>
       </span>
      </a>
     </em>
    </span>
    . The most effective
          means of doing so is to shut down the MySQL server while
          running
    <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
     <span class="command">
      <strong>
       myisamchk
      </strong>
     </span>
    </a>
    , or to lock all tables
          that
    <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
     <span class="command">
      <strong>
       myisamchk
      </strong>
     </span>
    </a>
    is being used on.
   </p>
   <p>
    Otherwise, when you run
    <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
     <span class="command">
      <strong>
       myisamchk
      </strong>
     </span>
    </a>
    , it may
          display the following error message:
   </p>
   <div class="copytoclipboard-wrapper">
    <pre class="programlisting one-line language-none"><div class="docs-select-all right" id="sa28840136"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-none">warning: clients are using or haven't closed the table properly</code></pre>
   </div>
   <p>
    This means that you are trying to check a table that has been
          updated by another program (such as the
    <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
     <span class="command">
      <strong>
       mysqld
      </strong>
     </span>
    </a>
    server) that hasn't yet closed the
          file or that has died without closing the file properly, which
          can sometimes lead to the corruption of one or more
    <code class="literal">
     MyISAM
    </code>
    tables.
   </p>
   <p>
    If
    <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
     <span class="command">
      <strong>
       mysqld
      </strong>
     </span>
    </a>
    is running, you must force it to
          flush any table modifications that are still buffered in
          memory by using
    <a class="link" href="flush.html#flush-tables">
     <code class="literal">
      FLUSH TABLES
     </code>
    </a>
    .
          You should then ensure that no one is using the tables while
          you are running
    <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
     <span class="command">
      <strong>
       myisamchk
      </strong>
     </span>
    </a>
   </p>
   <p>
    However, the easiest way to avoid this problem is to use
    <a class="link" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
     <code class="literal">
      CHECK TABLE
     </code>
    </a>
    instead of
    <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
     <span class="command">
      <strong>
       myisamchk
      </strong>
     </span>
    </a>
    to check tables. See
    <a class="xref" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
     Section 15.7.3.2, “CHECK TABLE Statement”
    </a>
    .
   </p>
  </div>
  <p>
   <a class="link" href="myisamchk.html" title="6.6.4 myisamchk — MyISAM Table-Maintenance Utility">
    <span class="command">
     <strong>
      myisamchk
     </strong>
    </span>
   </a>
   supports the following options,
        which can be specified on the command line or in the
   <code class="literal">
    [myisamchk]
   </code>
   group of an option file. For
        information about option files used by MySQL programs, see
   <a class="xref" href="option-files.html" title="6.2.2.2 Using Option Files">
    Section 6.2.2.2, “Using Option Files”
   </a>
   .
  </p>
  <div class="table">
   <a name="idm46045307681520">
   </a>
   <p class="title">
    <b>
     Table 6.17 myisamchk Options
    </b>
   </p>
   <div class="table-contents">
    <table frame="box" rules="all" summary="Command-line options available for myisamchk.">
     <colgroup>
      <col style="width: 35%"/>
      <col style="width: 64%"/>
     </colgroup>
     <thead>
      <tr>
       <th>
        Option Name
       </th>
       <th>
        Description
       </th>
      </tr>
     </thead>
     <tbody>
      <tr>
       <td>
        <a class="link" href="myisamchk-other-options.html#option_myisamchk_analyze">
         --analyze
        </a>
       </td>
       <td>
        Analyze the distribution of key values
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_backup">
         --backup
        </a>
       </td>
       <td>
        Make a backup of the .MYD file as file_name-time.BAK
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-other-options.html#option_myisamchk_block-search">
         --block-search
        </a>
       </td>
       <td>
        Find the record that a block at the given offset belongs to
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_character-sets-dir">
         --character-sets-dir
        </a>
       </td>
       <td>
        Directory where character sets can be found
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-check-options.html#option_myisamchk_check">
         --check
        </a>
       </td>
       <td>
        Check the table for errors
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-check-options.html#option_myisamchk_check-only-changed">
         --check-only-changed
        </a>
       </td>
       <td>
        Check only tables that have changed since the last check
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_correct-checksum">
         --correct-checksum
        </a>
       </td>
       <td>
        Correct the checksum information for the table
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_data-file-length">
         --data-file-length
        </a>
       </td>
       <td>
        Maximum length of the data file (when re-creating data file when it is full)
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_debug">
         --debug
        </a>
       </td>
       <td>
        Write debugging log
       </td>
      </tr>
      <tr>
       <td>
        --decode_bits
       </td>
       <td>
        Decode_bits
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_defaults-extra-file">
         --defaults-extra-file
        </a>
       </td>
       <td>
        Read named option file in addition to usual option files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_defaults-file">
         --defaults-file
        </a>
       </td>
       <td>
        Read only named option file
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_defaults-group-suffix">
         --defaults-group-suffix
        </a>
       </td>
       <td>
        Option group suffix value
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-other-options.html#option_myisamchk_description">
         --description
        </a>
       </td>
       <td>
        Print some descriptive information about the table
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-check-options.html#option_myisamchk_extend-check">
         --extend-check
        </a>
       </td>
       <td>
        Do very thorough table check or repair that tries to recover every possible row from the data file
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-check-options.html#option_myisamchk_fast">
         --fast
        </a>
       </td>
       <td>
        Check only tables that haven't been closed properly
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-check-options.html#option_myisamchk_force">
         --force
        </a>
       </td>
       <td>
        Do a repair operation automatically if myisamchk finds any errors in the table
       </td>
      </tr>
      <tr>
       <td>
        --force
       </td>
       <td>
        Overwrite old temporary files. For use with the -r or -o option
       </td>
      </tr>
      <tr>
       <td>
        --ft_max_word_len
       </td>
       <td>
        Maximum word length for FULLTEXT indexes
       </td>
      </tr>
      <tr>
       <td>
        --ft_min_word_len
       </td>
       <td>
        Minimum word length for FULLTEXT indexes
       </td>
      </tr>
      <tr>
       <td>
        --ft_stopword_file
       </td>
       <td>
        Use stopwords from this file instead of built-in list
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_HELP">
         --HELP
        </a>
       </td>
       <td>
        Display help message and exit
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_help">
         --help
        </a>
       </td>
       <td>
        Display help message and exit
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-check-options.html#option_myisamchk_information">
         --information
        </a>
       </td>
       <td>
        Print informational statistics about the table that is checked
       </td>
      </tr>
      <tr>
       <td>
        --key_buffer_size
       </td>
       <td>
        Size of buffer used for index blocks for MyISAM tables
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_keys-used">
         --keys-used
        </a>
       </td>
       <td>
        A bit-value that indicates which indexes to update
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_max-record-length">
         --max-record-length
        </a>
       </td>
       <td>
        Skip rows larger than the given length if myisamchk cannot allocate memory to hold them
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-check-options.html#option_myisamchk_medium-check">
         --medium-check
        </a>
       </td>
       <td>
        Do a check that is faster than an --extend-check operation
       </td>
      </tr>
      <tr>
       <td>
        --myisam_block_size
       </td>
       <td>
        Block size to be used for MyISAM index pages
       </td>
      </tr>
      <tr>
       <td>
        --myisam_sort_buffer_size
       </td>
       <td>
        The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_no-defaults">
         --no-defaults
        </a>
       </td>
       <td>
        Read no option files
       </td>
      </tr>
      <tr>
       <td>
        --parallel-recover
       </td>
       <td>
        Uses the same technique as -r and -n, but creates all the keys in parallel, using different threads (beta)
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_print-defaults">
         --print-defaults
        </a>
       </td>
       <td>
        Print default options
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_quick">
         --quick
        </a>
       </td>
       <td>
        Achieve a faster repair by not modifying the data file
       </td>
      </tr>
      <tr>
       <td>
        --read_buffer_size
       </td>
       <td>
        Each thread that does a sequential scan allocates a buffer of this size for each table it scans
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-check-options.html#option_myisamchk_read-only">
         --read-only
        </a>
       </td>
       <td>
        Do not mark the table as checked
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_recover">
         --recover
        </a>
       </td>
       <td>
        Do a repair that can fix almost any problem except unique keys that aren't unique
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_safe-recover">
         --safe-recover
        </a>
       </td>
       <td>
        Do a repair using an old recovery method that reads through all rows in order and updates all index trees based on the rows found
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-other-options.html#option_myisamchk_set-auto-increment">
         --set-auto-increment
        </a>
       </td>
       <td>
        Force AUTO_INCREMENT numbering for new records to start at the given value
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_set-collation">
         --set-collation
        </a>
       </td>
       <td>
        Specify the collation to use for sorting table indexes
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_silent">
         --silent
        </a>
       </td>
       <td>
        Silent mode
       </td>
      </tr>
      <tr>
       <td>
        --sort_buffer_size
       </td>
       <td>
        The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-other-options.html#option_myisamchk_sort-index">
         --sort-index
        </a>
       </td>
       <td>
        Sort the index tree blocks in high-low order
       </td>
      </tr>
      <tr>
       <td>
        --sort_key_blocks
       </td>
       <td>
        sort_key_blocks
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-other-options.html#option_myisamchk_sort-records">
         --sort-records
        </a>
       </td>
       <td>
        Sort records according to a particular index
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_sort-recover">
         --sort-recover
        </a>
       </td>
       <td>
        Force myisamchk to use sorting to resolve the keys even if the temporary files would be very large
       </td>
      </tr>
      <tr>
       <td>
        --stats_method
       </td>
       <td>
        Specifies how MyISAM index statistics collection code should treat NULLs
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_tmpdir">
         --tmpdir
        </a>
       </td>
       <td>
        Directory to be used for storing temporary files
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-repair-options.html#option_myisamchk_unpack">
         --unpack
        </a>
       </td>
       <td>
        Unpack a table that was packed with myisampack
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-check-options.html#option_myisamchk_update-state">
         --update-state
        </a>
       </td>
       <td>
        Store information in the .MYI file to indicate when the table was checked and whether the table crashed
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_verbose">
         --verbose
        </a>
       </td>
       <td>
        Verbose mode
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_version">
         --version
        </a>
       </td>
       <td>
        Display version information and exit
       </td>
      </tr>
      <tr>
       <td>
        <a class="link" href="myisamchk-general-options.html#option_myisamchk_wait">
         --wait
        </a>
       </td>
       <td>
        Wait for locked table to be unlocked, instead of terminating
       </td>
      </tr>
      <tr>
       <td>
        --write_buffer_size
       </td>
       <td>
        Write buffer size
       </td>
      </tr>
     </tbody>
    </table>
   </div>
   <div class="table-contents">
    <table cellpadding="0" cellspacing="0" style="position: fixed; top: 0px; display: none; left: 401px; width: 739px;">
     <thead>
      <tr>
       <th style="width: 260.906px;">
        Option Name
       </th>
       <th style="width: 477.094px;">
        Description
       </th>
      </tr>
     </thead>
    </table>
   </div>
  </div>
  <br class="table-break"/>
 </div>
 <br/>
</div>
