How to optimise WordPress database with phpMyAdmin

February 28, 2024 / WordPress

This article explains the process of optimising your WordPress database with phpMyAdmin. Optimising your WordPress database with phpMyAdmin can enhance site performance, reduce server load, improve storage efficiency, bolster security, and streamline maintenance.

To manually optimise your WordPress database, you may have to log in through your hosting provider.

Let us follow the steps-

  1. Log in to cPanel.
  2. Select the “Database” tool and click on the “phpMyAdmin” sub-option.
  3. Select the tables that need to be optimised from the “Structure” tab.Structure
  4. You can also choose them by checking the “Check all” box.
    check all
  5. After selecting the tables, click on the drop-down arrow as shown below.
  6. Click on the “Optimise table” option.
    Optimise WordPress database
  7. You will get a success message as soon as the database is cleaned and optimised.

Was not it useful to you? Hope you grasped everything well. For more such informative articles, do visit our KB section regularly.


Dominos Search