Explain the options of myisamchk to improve the performance of a table.

Answer

Myisamchk has a couple of options to optimize a table.

• Using myisamchk –r table_name, runs myisamchk in recovery mode. This option combines the fragmented rows and gets rid of wasted space.
• --Analyze, -a is used for analyze the distribution of key values.
• --sort-index, -S – Sorts index tree.
• --sort-records=index_num, -R index_num – sorts recods according to particularr index.