Optimize a Database
Carlos Escalante avatar
Written by Carlos Escalante
Updated over a week ago

It is always a good idea to keep your databases' tables optimized, making this optimization is quite easy when using the phpMyAdmin tool available in cPanel:

  1. Log in to the cPanel account that owns the database.

  2. Select the phpMyAdmin icon.

  3. Select the database name from the sidebar on the left.

  4. At the bottom of the list of tables mark the checkbox next to "Check All".

  5. To the right of that checkbox look for the dropdown menu and select "Optimize Table".

Sometimes this optimization can make significant improvements to the speed of the database, and other times it may not make any difference. The result depends on the particular database.

Did this answer your question?