Step 1:

Due to changes in a database such as the deletion of data sets, it can lead to fragmentation which means that unused spaces can occur between the allocated spaces. Those unused spaces are called overhead.

It makes sense to optimize a database from time to time in order to reassort the data and to erase a possibly existing overhead. In the end, this will increase the amount of free webspace.

Step 2:

First, log in to your database via phpMyAdmin.

This can be done directly in the KAS (Technical Administration) panel by clicking menu item Databases and the phpMyAdmin icon right next to the respective database.

You can also access the phpMyAdmin directly by calling up www.yourdomain.com/mysqladmin/ and entering the login credentials of the database. The login credentials can be found inside your KAS (Technical Administration) under the menu item Databases.

Once inside the phpMyAdmin, please click the database name on the left side unless it's already selected.

Step 3:

On the right side please scroll down and click Check tables having overhead.

Step 4:

From the drop-down field, please select Optimize table.

Step 5:

At the end, an overview of the optimized tables will be shown.