This article will focus on optimizing your database tables within your phpFox AdminCP.
Periodically you will want to optimize your database tables, reducing the size of the database by cleaning out unnecessary “empty” space. You can do this in a couple different ways, but we will focus on using the tools available in your phpFox AdminCP.
As always, before you make any major changes or do any maintenance to your site, it is advised that you backup your site files and/or database.
Login to your admincp and select Tools > SQL > Maintenance.
The next page shows a list of all the tables in your database, the size of your database, and how much Overhead is in those tables. In order to optimize this database, we are going to check the box to the left of Table, to select ALL the database tables. You can select specific tables to optimize instead of the entire database if you would like. You don’t need to optimize ALL the tables at the same time.
Once you have selected all the database tables, scroll to the bottom of the page and click on Optimize Tables.
You should now see a Success message similar to the one here: