WordPress relies upon MySQL database which is the most popular open source relational database management system. It is important & necessary to optimizing your WordPress database. Because things like post revisions, old spam comments can pile up over the time. Over time, your MySQL database will build up overhead that slows down your websites and compromises performance. Instead you can use WordPress widgets to clean & optimize the database.
Here we have come up with some of the awesome free WordPress optimize database widget plugins to optimize WordPress database and defrag them for proper space allocation. Hope you like this post. We’d love to have you Pin It, Tweet It, Stumble It and Facebook It to let others know that this resource is now available to them! You may be interested in the following posts: WordPress Free Animation Plugins, Premium Flat Magazine WordPress Themes and Free WordPress Slideshare Widgets.
Clean Up Optimizer
WP Clean Up Optimizer optimizes your WordPress as well as clean up the obsolete data from database. You can schedule the process of Cleaning, Optimizing , Deleting and Repairing the database tables without going to phpMyAdmin. 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.
Design Approval System
Approved designs get a STAR on the Project Board, and Clients signature is recorded to the database. Check out the Project Board. Clients, projects, & designs are organized on one page + Clients can login to see there designs! With the click of a button you can send the design’s review link to a client for approval. Change the text in all automatic confirmation emails.
POWr Contact Form
POWr Contact Form is a free cloud-based plugin you can edit in your live web page. Create a POWr account to access the entire plugin library. First, download, install, and activate POWr Contact Form. Then drop the widget anywhere in your theme. Or add to a page/post with the POWr icon in the WP editor. Create recurring payments for memberships and subscriptions. Add inputs for text, dropdowns, checkboxes, email, date, and more.
Backing up your WordPress website is easy with WP BackItUp. Simply install WP BackItUp and within minutes you will have a complete backup of your entire site. No complex configuration to deal with. No advanced knowledge of WordPress required. No FTP, cPanel, MySQL or PHPMyAdmin involved. If you can press a button then you can backup your WordPress site with WP BackItUp.
Better Delete Revision
Better Delete Revision not only deletes redundant revisions of posts from your WordPress Database, it also deletes other database content related to each revision such meta information, tags, relationships, and more. Better Delete Revision is based on the old “Delete Revision” plugin but it is compatible with the latest version of WordPress (3.x) with improved features.
WP Clean Up
WP Clean Up can help us to clean up the wordpress database by removing “revision” “draft” “auto draft” “moderated comments” “spam comments” “trash comments” “orphan postmeta” “orphan comment meta” “orphan relationships” “dashboard transient feed”. It allows you to optimize your WordPress database without phpMyAdmin. 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.
Many plugins do not clean up their database tables after you uninstall them. What happens most of the time is that the plugin files and folder is deleted but not the corresponding plugin database tables. This where this plugin comes to the rescue. The WPDBSpringClean plugin identifies unused, WordPress DB tables which have been left over from old plugins you have uninstalled on your site and it then gives you the option of deleting these tables.