To fulfill the repair or database optimization will be required mysqlcheck utility

MySQLTuner is a utility that analyzes the statistics of MySQL and issue recommendations for optimizing MySQL server settings.