Cleaning your WordPress data is very important, it increases the speed of your website and increases search rankings. All WordPress websites consist of 2 parts: the first part is Files which contains media, themes, and plugins. The second part contains Settings, posts, users and their credentials, post-Meta. If these file sizes are too large, your website will slow down and may crash, and even sometimes lose data.
Most of the major search engines use page speed as a factor in ranking a page (Core Web Vitals 2021). For optimum WordPress performance, you want to keep the database clean. Cleaning your WordPress database is part of an overall process of WordPress performance tuning and is also recommended in WordPress’ optimization guide.
In this tutorial, to clean your WordPress database I suggest you install a plugin that is WP-Optimize to delete Comments, drafts, Pingbacks, unused tables lefts behind by old plugins.
- Unused WordPress Plugins
- Unnecessary Comments
- Old Posts
- Unused Media
- Caching Plugins
- Orphaned data
- Unused tags
Let’s take a look at how you can clean up your WordPress database.
1. Before you start, make a Backup!
Create a Complete WordPress Backup for your website before you do everything else. Use UpdraftPlus WordPress Backup Plugin to backup your data. UpdraftPlus Plugin simplifies backups and restoration. It is the world’s highest-ranking and most popular scheduled backup plugin, with over three million currently active installs. Back up your files and database backups into the cloud and restore with a single click!
2. Cleaning up your WordPress Database with WP-Optimize Plugin
Now let’s install WP-Optimize Plugin, an all-in-one WordPress performance plugin that caches your site, and cleans your database, compresses your images.
After installing and activating WP-Optimize, go to the settings to optimize and start deleting unnecessary things. You will see in the Settings for Optimizations and Tables Tabs.
3. In the Optimizations Settings tab
You can optimize database tables, clean all post revisions, clean all auto-draft posts, remove unapproved comments, remove pingback, etc.
Warning: Items marked with this icon perform more intensive database operations. In very rare cases, if your database server happened to crash or be forcibly powered down at the same time as an optimization operation was running, data might be corrupted. You may wish to run a backup before optimizing.
4. In the Tables Settings tab
In the WP-OptimizeTables tab, you will see information about the size, the old plugin that is not installed on your WordPress site. You should delete them if you don’t plan on using them again.
I recommend you clean up your database weekly to make your Website faster, optimize Core Web Vitals, and get high rankings on search engines.
That’s all, in this tutorial helped you clean your WordPress site using WP-Optimize Plugin. You can also use similar Plugins that I will list below.
5. Similar Plugins That Clean Your WordPress Database
5.1 WP-Sweep Plugin
This plugin cleans up:
- Auto drafts
- Deleted comments
- Unapproved comments
- Spammed comments
- Deleted comments
- Orphaned post meta
- Orphaned comment meta
- Orphaned user meta
- Orphaned term meta
- Orphan term relationships
- Unused terms
- Duplicated post meta
- Duplicated comment meta
- Duplicated user meta
- Duplicated term meta
- Transient options
- Optimizes database tables
- oEmbed caches in post meta
‘Advanced Database Cleaner’ is a must-have plugin that allows you to clean databases, optimize databases, and more.
- Delete old revisions of posts and pages
- Delete old auto drafts
- Delete trash posts
- Delete pending comments
- Delete spam comments
- Delete trash comments
- Delete pingbacks
- Delete trackbacks
- Delete orphan post metadata
- Delete orphan comment metadata
- Delete orphan user metadata
- Delete orphan term metadata
- Delete orphan relationships
- Delete expired transients
Database Cleanup plugin scans the database and shows the tables beyond core WordPress installation. Some WordPress plugins create and use their own database tables.
Those tables are left in your database after plugin deactivation and deletion often.
With the help of this plugin, you can check your database and discover if it is clean or not.
Extra columns added to the core WordPress tables could be shown also.
To read more about ‘Plugins Garbage Collector’ visit this link at shinephp.com
That’s all how to Clean Your WordPress Database Improved Performance, I hope this tutorial helped you clean your WordPress site using WP-Optimize Plugin. You may also want to check out our guide on the most common WordPress errors and how to fix them.