Tips to optimise a WordPress database

Tips to optimise a WordPress database

This website has been running for a couple of years now, and the database has continued to grow with it!  Yesterday I looked into how I could remove some of the redundant content and reduce the overall size.

I found an article by ProBlogDesign entitled “How to Optimize a WordPress Database” which was very helpful.

In particular, I found the following points the most handy:

  1. MySQL Optimize:

    In phpMyAdmin, just select the table, go to the “Operations” tab, and then click “Optimize Table.”

  2. Delete All Post Revisions:

    Add this line to your wp-config.php file to stop future revisions being stored:

    define('WP_POST_REVISIONS', false);
    

    Then clear all the revisions stored in the database with this SQL command:

    DELETE FROM wp_posts WHERE post_type = 'revision';
    

There are many more things you can do to ensure your database is running as efficiently as possible.  Check out Michael Martin’s post to find out more.

Scroll to Top