Optimizing MySQL - Database Design Manual: Using MySQL for Windows - page 157

Figure 13.10 Repairing a table with myisamchk -o.

and then type:

c:\mysql\data\bin\myisamchk -o tablename

tablename is the name of the table that you are trying to repair. This process and the
results can be seen in Figure 13.10.

ANALYZE TABLE

The ANALYZE TABLE command is another tool to allow you to optimize your MySQL
tables, which is used as follows:

ANALYZE TABLE tablename, tablename, tablename, …

ANALYZE TABLE will examine the key distribution within the table and store the results.
These keys are used when you are joining the table with others, and if the key distribution
is stored this way, it will make some joins run quicker.
Again, this will generate a table of results similar to those shown in Figure 13.9.