> ## Documentation Index
> Fetch the complete documentation index at: https://kb.mochahost.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Optimize your Databases via PhpMyAdmin

When a database is 'cluttered' it can result in your website poor speed performance, resource overusage of your cPanel account – a number of MySQL requests to a 'heavy' database may stuck in a queue hitting Entry Processes and CPU limits.

**To resolve this a proper optimization is required to involve the efficiency with which data is retrieved from the database.**

To do that, please ofllow the steps below.

1. To begin with you need to **locate the database assigned to your website**. If you do not know it's name, feel free to check it your website's configuration file.

2. In this case we have a WordPress-based website, our database name is test\\\_wp255.

![](https://tutorials.my-virtual-panel.com/articles/fn9Nmmh.png)

**Before making any changes, we strongly advise that you download the backup of your database.**

3. To do so, move to Files section > Backups menu.

![](https://tutorials.my-virtual-panel.com/articles/7ggVw2M.png)

4. Click on the database in question in Download a MySQL Database Backup menu to start the download.

![](https://tutorials.my-virtual-panel.com/articles/zpQPHNY.png)

5. Now you can proceed with the optimization itself. Navigate to **Databases section > phpMyAdmin** menu.

![](https://tutorials.my-virtual-panel.com/articles/yhUkVau.png)

6. Click on the database in the left menu to expand the list of the tables.

![](https://tutorials.my-virtual-panel.com/articles/0I4JC6q.png)

7. Check-mark the needed table and select **Optimize** table from the drop-down menu as shown below.

![](https://tutorials.my-virtual-panel.com/articles/YQkKKRX.png)

8. In the same way you can optimize several tables at once, or all of them using **Check All** option. 

![](https://tutorials.my-virtual-panel.com/articles/0a0YDSu.png)

9. As a result, you will get the following output and your database will be successfully optimized.

![](https://tutorials.my-virtual-panel.com/articles/Q2wXbbp.png)