> For the complete documentation index, see [llms.txt](https://docs.clouduxe.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.clouduxe.com/databases/how-to-optimize-a-database-via-phpmyadmin-in-cpanel.md).

# How to Optimize a Database via phpMyAdmin in cPanel

Optimizing your database can enhance its performance. Follow these steps:

* Log in to your **cPanel account**.
* In the **Databases** section, click on **phpMyAdmin**.

<figure><img src="/files/tqq7S8zEJi0VGNrcdspf" alt=""><figcaption></figcaption></figure>

* Click on the **Expand** icon from the navigation tree in the left sidebar.

<figure><img src="/files/xEDbXgCacKVDyVomX3lr" alt=""><figcaption></figcaption></figure>

* Scroll down, mark **Check All**, and select **Optimize tables** from the drop-down menu.

<figure><img src="/files/ZmAZOkpbZaDi3Xmmb5LR" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Your tables have been successfully optimized!
{% endhint %}