Skip to main content
Code SnippetsServer Configuration

Optimize All MySQL Tables Command

By March 21, 2014No Comments

Need to defragment tables and optimize MySQL for better performance? A quick and easy command to perform the task from shell.

——– Recommendations —————————————————–
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance

Run:

mysqlcheck -Ao

Defragmenting and optimizing your sql tables is easy. You now have a slightly faster database.

 

Leave a Reply