• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

WP SITES

2784

Original Genesis Tutorials & 6000+ Guaranteed Code

Snippets

  • Consultation
  • Full Access
  • Log in

How to Optimize Your WordPress Database for Better Performance

If you don’t optimize your database you’ll find your site slowing down day by day. The reason for this is that WordPress stores post revisions in your MySQL Database tables every time you add content, edit posts and click the Save Draft button.

Here’s an example:

WordPress Post Revisions

If you take a look at the bottom of your Edit Post screen you’ll see what i mean. When i deleted my post revisions using the WP Optimize plugin, my database decreased in size from 97mg to 23mg.

Post RevisionsDeleting post revisions will clean your database and make your database smaller and faster. You could do this manually using phpMyAdmin in cPanel or simply install a plugin like WP Optimize.

Caution: Always make sure you create a full database backup using phpMyAdmin before making any changes to your database.

Database Optimization Plugins

WP Optimize

As well as optimizing your database, and deleting posts revisions, WP Optimize will also bulk delete comments in your spam queue.

Read more about WP Optimize here.

WP Database Optimizer

The WP database Optimizer plugin allows you to schedule a regular database optimization automatically.

WordPress Optimization

The WordPress Codex offer an extensive range of resources to help further optimize your WordPress installation & improve the performance of your WordPress site so it runs as efficiently as possible.

Using phpMyAdmin

Check & Repair Database

You can also login to cPanel and manually Check and Repair your databases if needed.

Click the SQL Databases icon in the Databases section where you’ll find these options.

Modify Databases

Its now very easy to cleanup your databases and optimize WordPress for better performance.

Reader Interactions

Comments

  1. Mia Orantes says

    March 18, 2012 at 5:19 pm

    BY the way, what plugin do you use in the bottom right that suggests other related posts in the same taxonomy? Also, do you have a post on the top plugins that you use?

    Log in to Reply
    • Brad Dalton says

      March 18, 2012 at 5:45 pm

      upPrev Previous Post Animated Notification is the full name of the plugin

      Here’s my list of the top 50 plugins http://wpsites.net/wordpress-plugin/top-50-best-wordpress-plugins-create-the-ultimate-wordpress-experience-for-your-site-visitors/

      Log in to Reply
  2. Mia Orantes says

    March 18, 2012 at 5:17 pm

    Brad, I had no idea about these plugins! I hope they are free. I am going to check them out now. Great post. I have achieved first page ranking for some of my desired keyword phrases , but I think my page speed is keeping me from optimal search engine performance.

    Log in to Reply
    • Brad Dalton says

      March 18, 2012 at 5:43 pm

      Hi Mia

      I guess if you offer WordPress web design you should really learn about WordPress plugins as there’s 18,000 free ones

      Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

Primary Sidebar

Code written by Brad Dalton specialist for Genesis, WooCommerce & WordPress theme customization. Read More…

Advertise · WPEngine · Genesis · Log in

  • Access Problems
  • Account Details
  • Consulting
  • Tags
 

Loading Comments...
 

You must be logged in to post a comment.