Skip to main content

We're currently improving our systems to provide you with a new, more unified login experience.

How to optimize a database and its tables via phpMyAdmin in cPanel or WHM

Austin Lowery
  • Updated

Introduction

phpMyAdmin offers a feature that allows a user to perform basic database optimization without the need for any special knowledge or skills.

 

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.

 

Procedure

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

This can also be done via phpMyAdmin in WHM at Home » SQL Services » phpMyAdmin.

Related articles