Proper defragmentation of MySQL innodb tables

This task is able to defrag the entire MySQL server by dump all datas, clean files and import datas in order to restart to a freshed MySQL indexes.
You did not have to execute this task daily but sometimes during the Year...
The task can be driven trough tasks.

  • Add a new schedule and choose "Defrag the entire MySQL server"
  • Set a schedule just to save the task.
  • Click on Add button.

28-06-2012_16-49-43.png

  • Find the created task and uncheck the checkbow in order to disable it from the scheduler.
  • You can run it by clicking on the green arrow.

28-06-2012_16-54-03.png