The OPTIMIZE TABLE request makes it possible to also optimize a MySQL table by releasing non-used space and by defragging data files. |
It can improve the file access speed by completely and thoroughly defragging hard disk. |
These routines are not needed with SSDs, and the defragging can be considered harmful. |
Defragging your hard disk helps your computer store the files it has more efficiently. |
Windows 8.1 has a built-in disk optimiser that does some defragging once a week. |
Enhanced AutoPilot scheduling allows users and administrators to schedule defragging whenever and wherever it is convenient. |