myisamchk in recovery mode.
myisamchk -r tbl_name
OPTIMIZE TABLE SQL statement.
OPTIMIZE TABLE does a table repair and a key analysis.
OPTIMIZE TABLE also sorts the index tree so key lookups are faster.
myisamchk has the options to improve the performance of a table:
--analyze
--sort-index
--sort-records=index_num
Should I set up a table maintenance schedule?
© 2007 John Michael Pierobon