Best WordPress Plugins to Cleanup, Optimize DB
WP-Optimize is an extensive WordPress database cleanup and optimization tool. It doesn’t require PhpMyAdmin to clean and optimize your database tables. The requirements to install this plugin is WordPress 3.8+, PHP 5.1.xx and MySql 5.1.xx.
How this could help you?
- Every-time you save a new post or pages, WordPress creates a revision of that post or page. If you edit a post 6 times you might have 5 copy of that post as revisions. Imagine if your post or pages are long and big. It is a huge number of bytes that’s on your MySQL overhead. Now WP-Optimize allows you to optimize and shrink your posts table by removing not necessary post revisions from the database. As example, if you have a post which is approximately 100KB data and you have 5 revisions of that post, the total space wasted is about 500KB. And if you have 100 posts similar to it, you have 50MB database space wasted.
- Similar to the scenario described above, there might be thousands of spam and un-approved comments in your comments table, WP-Optimize can clean and remove those in a single click
- WP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces
- Automatically cleans database every week and respects the “Keeps selected number of weeks data” option.
P3 (Plugin Performance Profiler)
This plugin creates a profile of your WordPress site’s plugins’ performance by measuring their impact on your site’s load time. Often times, WordPress sites load slowly because of poorly configured plugins or because there are so many of them. By using the P3 plugin, you can narrow down anything causing slowness on your site.
This plugin uses the canvas element for drawing charts and requires requires Firefox, Chrome, Opera, Safari, or IE9 or later. This plugin will not work in IE8 or lower.
The requirements to install this plugin is 3.3 or higher and compatible up to: 4.1
WP Clean Up
WP Clean Up can help us to clean up the wordpress database by removing “revision” “draft” “auto draft” and so on.
It allows you to optimize your WordPress database without phpMyAdmin. It adds a settings page to “Dashboard”->”Settings”->”WP Clean Up” where you can clean up the wordpress database. It allows you to remove the redundant data within few clicks. It is a effective tool to keep your database clean and surely save a lot of space of your MySQL Database.
The requirements to install this plugin is 2.7 or higher and compatible up to: 3.9.2
Optimize Database after Deleting Revisions
This plugin is a ‘One Click’ WordPress Database Cleaner / Optimizer. It have features like Deletes redundant revisions of posts and pages,Deletes trashed posts, pages and comments, Deletes spammed comments, Deletes unused tags, Deletes ‘orphan postmeta items’, Deletes ‘expired transients’, Optimizes the database tables etc.
The requirements to install this plugin is 2.8 or higher and compatible up to: 4.1
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.
The requirements to install this plugin is 3.9 or higher and compatible up to: 4.1
NO WARRANTY, USE IT AT YOUR OWN RISK!