Home « SEO « WordPress Optimize Database With And Without Plugins
WordPress Optimize Database With And Without Plugins

WordPress Optimize Database With And Without Plugins

If you want to rank your website then don’t forget to optimize your website regularly. Here I am sharing optimize database with and without plugins. I will suggest optimizing WordPress site with plugin because it’s difficult for beginners to optimize a website with coding. Keep in mind before optimizing your website with a plugin or without plugin must backup of your database. Because if your database corrupts your all data waste and any action with the database is not reversible. If you want to optimize WordPress MySQL database then you can read discovered article, How To Optimize MySQL Database Using PHPMyAdmin?

Often when you make any change in old WordPress page or post then a revision auto create so it’s necessary to remove WordPress page or post revisions with PHPMyAdmin or plugin. You can also disable WordPress revisions. But I will suggest you don’t disable. I am also mentioning here WordPress disable revisions. You can follow if you want to disable. Make a routine to delete revision WordPress regularly because when your database will optimize then your website will work smoothly.

For revision deletion just follow some simple steps.

  • Login CPanel.
  • Search for PHPMyAdmin. Now open it.
  • Select database from left drop down menu.
  • On your right upper side. Just click on SQL and paste the below code.
DELETE FROM wp_posts WHERE post_type = "revision";
  • Just click on Go button which is placed below on right side.

Disable Auto Creation Of Revisions In WordPress

Keep in mind the excessive quantity of post or page revision slow your site speed. Try to remove these ones. You can also remove using a code or WordPress plugins. Here the 3 best WordPress plugins I am mentioning. I hope you will get good experience with these plugins. Another solution to rid off is disable revision by putting the below code in your wp-config file. If you know to access wp-config file then better otherwise you can read here, How to access a wp-config file in WordPress?

define('WP_POST_REVISIONS', false );

Best WordPress Optimization Plugins

Here I am mentioning MySQL optimization tool or plugins to optimize database WordPress.


WP Optimize Plugin

WP-Optimize is a most popular WordPress database optimization tool. Just copy the name of plugin and install by your WordPress dashboard. Wp-Optimize WordPress plugin allows you to remove revisions, spam, unapproved comments. You can also remove pingback and trackback by using Wp-Optimize WordPress Plugin.

Salient Features Of WP-Optimize WordPress Plugin

  • Deletion of post revisions
  • Removal of spam comments
  • Unapproved comments cleaner
  • Remove auto draft post
  • Repair Database

WP-DB Manager

WP DB Manager

WP-DB Manager database optimization plugin is a great plugin to optimize or repair any database. You can remove or repair any table instantly by using this WordPress plugin.

Salient Features Of WP DB Manager WordPress Plugin

  • Remove post revisions
  • Clean Spam comments
  • Delete unapproved comments
  • Remove auto draft post
  • Remove Empty Tables
  • Database Backup
  • Repair Database

Optimize Database After Deleting Revisions

Optimize Database After Deleting Revisions

Optimize Database after Deleting revisions plugin clean transit, unused tags, and spam comments. It’s a simple and effective plugin for WordPress. This is a free version and not paid version yet.

Salient Features Of Optimize Database After Deleting Revisions WordPress Plugin

  • Post revisions removal
  • Spam comments Deletion
  • Remove unapproved comments
  • Remove unused tags

These are WordPress plugin which works for database optimization and repairing. Take database before working n your site database.

AUTHORED BY Muhammad Awais Azeem

"Global Blurb since 2015" M. Awais Azeem is the CEO and founder of Global Blurb. The blog designed to share ideas about different topics. My profession is Accountant and I have completed CA Inter from Institute of Chartered Accountants of Pakistan. Me and my time present to sort out any issue regarding SEO, Blogging, Content Marketing and WordPress. Hire Us and Goodbye difficulty.

Want to contribute