- Login in your Atomia control panel.
- On the start page, click the Databases tab. Click the link given in front of "PHPMyadmin".
- Login in PHPMyadmin using the database username/password.
- Once inside phpmyadmin, you can click the database name to reveal
tables in the right hand pane. - Now scroll below and click ' Check All' link to select all tables or you can select the checkbox of each table which you wish to optimize.
- Once done select click the small arrow on the 'With Selected' drop down and select "Optimize table".
We recommend to optimize the databases on a regular basis. An optimized database has a better performance and consumes less webspace.