Code SnippetsServer Configuration

Optimize All MySQL Tables Command

By March 21, 2014 No 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


mysqlcheck -Ao

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


Robert Rooke

Author Robert Rooke

More posts by Robert Rooke

Leave a Reply