Store
Community Documentation

v3 Knowledgebase

Optimize Tables for Better Performance

**We recommend to always backup the database before doing maintenance on it.

In the AdminCP you will see an option to Optimize Tables found in

AdminCP >> Tools >> SQL >> Maintenance

On this screen you will see all of your database tables in a list. On the left is a selector that you can use to select some tables or all tables.

You might, periodically, want to optimize all of your tables in order to, basically, defrag your database.

After you have selected your tables to optimize, scroll to the bottom of the page and select Optimize Tables.

optimize.png
optimize2.png

More information on optimizing tables is found here.

http://docs.whmcs.com/Backups#Optimise_Tables

http://dev.mysql.com/doc/refman/4.1/en/optimize-table.html