Optimize Database

Introduction

AutoGallery SQL's database optimize function allows you to "cleanup" the MySQL database tables that it uses so they are optimized for both speed and disk usage. In general, you will not need to run this command more than once every few weeks, as MySQL is quite efficient in maintaining it's datafiles. The only time you may need to run it more often is if you delete a large number of galleries from your database.

In some cases, usually after your server recovers from a serious error, your MySQL database may become corrupted. When this happens you will get error messages from AutoGallery SQL indicating that there is a problem with one or more of your database tables. In most circumstances MySQL is able to repair damaged tables with it's built in functions. AutoGallery SQL allows you to run these built in functions with the Optimize/Repair feature. If you ever get these types of error messages, simply login to the control panel and use the Optimize/Repair function.

Optimizing and Repairing Your Database

To optimize and repair your database, simply click on the Optimize/Repair Database link in the Setup section of the control panel menu. A small window will pop-up and let you know that the procedure is in progress and it will tell you when it is done. There is nothing further that you need to do, your MySQL database optimization is complete.