Does anyone have a MySQL optimization / repair script written completely in SQL? I would like to run it as a scheduled procedure.
You may search for the mysql tuner script it will help little. But the tuning really depend on hardware and your database .
