TechnologyWordPress
How To Minimize WordPress Database Size To Improve Blog Performance ( Beginner’s Level Guide)

How To Minimize WordPress Database Size To Improve Blog Performance ( Beginner’s Level Guide)

By: SolutionsHint    59 views Updated: 13th Dec, 2017

In this tutorial i will explain  “How To Minimize WordPress Database Size To Improve Blog Performance” , to improve in performance , i always  should keep in mind that WordPress database should be optimize for Search Engine Optimization too .

There are two important Way to Host WordPress installation .
1. WordPress stored on your server 
 2. WordPress database
It’s an important for you to keep clean your WordPress database and reduce the size from time to time.

Over time, your WordPress database has many redundant (unused) tables, unused records, and have many entries which you can remove without affecting your blog.This process must do for every WordPress user to keep the size of their database at a minimum and keep their WordPress blog loading quickly .This will help reduce the load on your server and your WordPress performance will improve dramatically.

” These are some popular plugin to Optimize WordPress Database to improve the performance .”

How To Minimize WordPress Database Size To Improve Blog Performance

  1. Remove unused plugin and Theme from blog .
  2. Clear Trash, Draft posts from your post with if they are unused .
  3. Remove unused pages from WordPress Blog .
  4. Remove Trash, Spam from the blog .
  5. If you have installed Akismet plugin so please remove & delete unused table from database .
  6. Drop or Empty Unused Database Table .
  7. Query for remove unused , table are bellow just run that query in databse ,
  8. Query 1 DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);
    DELETE FROM wp_commentmeta WHERE meta_key LIKE ‘% akismet %’;
  9. Query 2 : DELETE FROM wp_postmeta WHERE meta_key = “_edit_lock”;
    DELETE FROM wp_postmeta WHERE meta_key = “_edit_last”;
  10. Remove All rar & zip Files from the server , its takes to much space on server so keep in mind after extract of rar & zip file delete for database performance .
  11. Optimize the Image for the post , its really increase the size of database , so use optimized image in the articles.
  12. Use online free tools to optimize all images http://optimizilla.com/.

Screenshot Tutorial

Step 1  : Empty Drafts, Trash from blog .

How To Minimize WordPress Database Size To Improve Blog Performance ( Beginner's Level Guide)

Step 2 : Remove Unused page from blog .

Reduce  WordPress Database Size To Improve Blog Performance

Step 3 : Remove Unused plugin from blog .

Reduce  WordPress Database Size To Improve to  Performance

Step 4 : Done !!

About the Author

I am a professional blogger from my heart, I am going through all the possible ways that can help to audience. I am trying my best to write content that my readers will like me. I will really be happy when my readers will become more happy with my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *