In the upper table, you select the tables to repair/optimize along with the amount of disk space used by each table. In the lower table, you may select:
- Optimize Tables – selecting this option defragments MySQL’s data file for this table and reclaims lost space. For more information on this process, see the MySQL manual. It is not necessary to optimize tables that are showing no overhead.
- Repair Tables – this option causes MySQL to attempt to repair any tables it thinks are crashed. MySQL generally reports this by issuing an error such as ‘Got error ### from table handler’. Under normal conditions, this should not occur and this option should not need to be run. However, if something goes wrong, this option will generally restore all your data. For more information, see the MySQL manual.