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.
- 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.