{"id":22361,"date":"2018-06-12T19:21:16","date_gmt":"2018-06-12T13:51:16","guid":{"rendered":"https:\/\/blog.resellerclub.com\/?p=22361"},"modified":"2026-05-13T13:58:11","modified_gmt":"2026-05-13T13:58:11","slug":"how-to-optimize-wordpress-database","status":"publish","type":"post","link":"https:\/\/www.resellerclub.com\/blog\/how-to-optimize-wordpress-database\/","title":{"rendered":"How to optimize WordPress Database"},"content":{"rendered":"

If you have a WordPress website<\/a>, it is bound to have a database irrespective of the website being functional or redundant. A WordPress database stores all the data of your website. It includes posts, pages, comments (if any), website, theme and plugin settings, as well as, entries from forms and links if any.<\/p>\n

Anything that\u2019s filled with unwanted data hampers its performance. Optimization is, therefore, the key to efficiency and increasing performance. Optimizing your WordPress database ensures that your database size is reduced and the load speed of your website is considerably improved.<\/p>\n

In this article, I\u2019ll walk you through how you can optimize WordPress database.<\/p>\n

How to Optimize WordPress Database<\/strong>
\nThere are two ways to optimizing your WP database we\u2019ll be covering both:<\/p>\n

Method I: Using phpMyAdmin<\/strong>
\nphpMyAdmin is the most preferred tool to manage your WordPress database. You can find phpMyAdmin in your cPanel under the Databases section.
\n\"how<\/p>\n

    \n
  1. Once you login to phpMyAdmin you can have a look at the size of each table in your database. The size of a table is dependent on the amount of data stored in it. More the data stored, more are the rows in a table which in turn means increased size.<\/li>\n
  2. Apart from size, there is another column known as Overhead. Overhead is a temporary disk storage space that stores queries. Even though the overhead of a table might increase it hardly affects the performance of the website.<\/li>\n
  3. The figure below shows the landing page of phpMyAdmin and the extreme right-hand side columns show the \u2018Size\u2019 and \u2018Overhead\u2019 column.
    \n\"how<\/li>\n
  4. To optimize your database select all the tables in your database by clicking on the checkbox. Next, click on the drop-down menu and select \u2018Optimize Table\u2019 and click on \u2018Go\u2019
    \n\"how
    \nAlternatively, you can also use a SQL command to optimize the tables. The command to be used is:
    \nQuery: OPTIMIZE TABLE ‘tablename’
    \nExample: OPTIMIZE TABLE ‘wp_links’<\/li>\n
  5. After this, the command is executed and you get a message saying your WordPress database has now been optimized.<\/li>\n<\/ol>\n

    You can even refer to the official WordPress guide for Automatic Database Optimizing<\/a>.<\/p>\n

    Method II: Using a Plugin<\/strong>
    \nIf you\u2019re sceptical about using phpMyAdmin to optimize WordPress database then using a plugin for the same is a safe option.<\/p>\n

      \n
    1. Before optimizing your WordPress database it is preferable if you can take a backup. Some of the options for taking backup are Codeguard<\/a> or UpdraftPlus.<\/li>\n
    2. Once you\u2019re done taking a backup install a plugin to optimize your WordPress database. WP Optimize is one of the popular plugins with over 7,00,000+ active installations. Check out this post on how to install a WordPress plugin<\/a>.<\/li>\n
    3. After your plugin is installed and activated, click on the WP-Optimize tab in your WordPress dashboard and the settings page will open.
      \n\"how<\/li>\n
    4. In the above figure, click on the checkboxes you want to optimize. Before clicking on the red text icons make sure to take a backup as these store sensitive data.<\/li>\n
    5. After clicking on the items you want to optimize click on \u2018Run all selected optimizations\u2019 button. The plugin now starts optimizing your WordPress database. On completion of the operation, you will be notified.<\/li>\n<\/ol>\n

      I hope this article helped you understand how to optimize WordPress database. Did you face any issues will optimizing your WordPress database or have a tip to share? Please let us know in the comments section below.<\/p>\n

      Reseller Club Hosting Services<\/h2>\n

      Reseller Hosting<\/a> | Windows Reseller Hosting<\/a> | Cloud Hosting<\/a> | VPS Hosting<\/a> | Managed VPS Hosting<\/a> | Dedicated Server Hosting<\/a> | Windows Dedicated Server<\/a> | Managed Dedicated Server<\/a> | Linux Shared Hosting<\/a> | Windows Shared Hosting<\/a><\/p>\n

      \n\t\t\t
      \n\t\t\t <\/div><\/div>\n\t\t