How to optimize your Drupal database

Updated on Dec 10, 2015

After a period of using your Drupal installation, it will produce junk bits within the database that you are using. Thus, it is a good idea to optimize your database tables for best performance, especially if you are running a large social network website.

The first thing is to find the name of the database set on your Drupal website. This will allow you to manipulate it per your needs.

Drupal configuration file

You can locate the name of your database, reviewing our tutorial on how to edit the Drupal Configuration File.

Log into your cPanel account and navigate to the Databases tab and then click on the phpMyAdmin service.

Access phpMyAdmin via cPanel

Select the database that you are using from the list on the left side of the screen.

Select database via phpMyAdmin

Scroll down to the end you will notice a Check All box below the tables on your database. This button will select all of them. Then simply select the Optimize tableoption from the drop-down box.

Check all tables and run optimization tool via phpMyAdmin

Once the optimization of your database is completed, they system will display a successful message and also provide details on the process.

Optimization is completed successfully

On this page...

    Drupal Hosting

    • Free Drupal Installation
    • 24/7 Drupal Support
    • Free Domain for life
    • Hack-free Protection
    • Fast SSD Storage
    • Free Drupal Transfer
    • Free CloudFlare CDN
    • Immediate Activation
    View More