When installed, a WordPress Database normally has only 11 tables. But over time, when you install plugins, themes,… the number of tables, records will increase, causing the database to become bloated and slow. To help your blog/ website load faster, you need to clean up things that are not necessary (no longer used) in the Database. Here are the top best free plugins to help you in WordPress database cleanup easily, quickly and efficiently.

WP-Optimize

WP-Optimize is a highly regarded plugin (4.7/ 5 stars) based on the opinions of hundreds of users. With just one click, you can use the WP-Optimize to clean and optimize your database. It can clean up post revisions, and a lot of spam comments relevant information. You may also be set to automatically clean your database once a week.

Features:

• Enable/Disable trackbacks for all published post
• Enable/Disable comments for all published post
• Removal of stale post revisions
• Removal of stale unapproved and spam comments
• Removal of trashed comments
• Removal of akismet metadata from comments
• Removal of other stale metadata from comments
• Mobile device friendly, now you can optimize your site on the go
• Removal of all trackbacks and pingbacks
• Cleaning up auto draft posts
• Removal of transient options
• Clear out the post trash
• Automatic cleanup of all the integrated options (also uses retention if enabled)
• Ability to keep selected number of weeks data when cleaning up
• Option to add or remove link on wp admin bar.
• Enable/Disable weekly schedules of optimization
• Apply native WordPress MySql optimize commands on your database tables without phpMyAdmin or any manual query.
• Display Database table statistics. Shows how much space can be optimized and how much space has been cleared.
• Enabled for Administrators only.

Download WP-Optimize

WP DBManager

With over 1 million downloads and has 4/5 star ratings, WP DBManager is one of the most popular plugins in the database cleanup. WP DBManager has many features to help manage databases entirely your WordPress. In addition to cleaning, it allows you to optimize database, repair database, backup database, restore database, delete backup database, drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.

Download WP DBManager

WP Clean Up Optimizer

Clean Up WP Optimizer is a free plugin for WordPress, that helps you to clean up the old information from your database, and also have the ability to optimize and repair. This plugin can clean up post revisions, drafts, comments, pingbacks and orphaned information such as post meta.

By removing revision, draft, auto draft, moderated comments, spam comments, trash comments, orphan postmeta, orphan commentmeta, orphan relationships, dashboard transient feed and other data will optimize your WordPress and keep your database reform and safe. Advance feature i.e. confining the user by blocking their IP Address and Keep tracking the user who are currently logged in as well as trying to login. Cron Jobs adds a new information panel to WP Clean Up Optimizer that displays details such as List of the Scheduled events, Individual Schedule Interval, Date & Time for next event Execution and Arguments to pass to the hook function(s) for WP scheduled events (both custom and core).

Download WP Clean Up Optimizer