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

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".
   Please note: If you have more tables than can fit on a single page, you will need to "Check All" on every page of tables to ensure the optimization gets applied to all tables.
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.