How to optimize a database

  • 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.