564 myisamchk — MyISAM Table-Maintenance Utility Option Name Description --HELP Display help message and exit --help Display help message and exit --information Print informational statistics about the table that is checked --key_buffer_size Size of buffer used for index blocks for MyISAM tables --keys-used A bit-value that indicates which indexes to update --max-record-length Skip rows larger than the given length if myisamchk cannot allocate memory to hold them --medium-check Do a check that is faster than an --extend-check operation --myisam_block_size Block size to be used for MyISAM index pages --myisam_sort_buffer_size The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE --no-defaults Read no option files --parallel-recover Uses the same technique as -r and -n, but creates all the keys in parallel, using different threads (beta) --print-defaults Print default options --quick Achieve a faster repair by not modifying the data file --read_buffer_size Each thread that does a sequential scan allocates a buffer of this size for each table it scans --read-only Do not mark the table as checked --recover Do a repair that can fix almost any problem except unique keys that aren’t unique --safe-recover 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 --set-auto-increment Force AUTO_INCREMENT numbering for new records to start at the given value --set-collation Specify the collation to use for sorting table indexes --silent Silent mode --sort_buffer_size The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE --sort-index Sort the index tree blocks in high-low order --sort_key_blocks sort_key_blocks --sort-records Sort records according to a particular index --sort-recover Force myisamchk to use sorting to resolve the keys even if the temporary files would be very large --stats_method Specifies how MyISAM index statistics collection code should treat NULLs