B. Reclaim free space from table files by using the --optimize option. This option runs the OPTIMIZE TABLE statement for each table, which defragments the data and index pages, sorts the index pages, and updates the index statistics1. This can improve the performance and storage efficiency of the tables, especially for those that undergo frequent insert, update, or delete operations2.
D. Rename the mysqlcheck command to mysqlrepair so that it repairs tables by default. This is a special feature of mysqlcheck that allows you to change its default behavior by renaming the binary. If you copy or create a symbolic link to mysqlcheck named mysqlrepair, it will run the REPAIR TABLE statement for each table instead of the CHECK TABLE statement3. This can be useful for fixing corrupted tables that use storage engines that support this statement, such as MyISAM4.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit