WordPress Plugins to help Optimize & Manage your Database

1. WP-DBManager

This WordPress Plugin has a lot of capabilities and allows you to optimize your database, repair your database, backup your database, restore your database, delete your backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.

Download here


2. WP-Optimize

This simple but effective plugin allows you to clean up your WordPress database and optimize it without phpMyAdmin. Also renames any username. WP-Optimize is a WordPress 2.9++ database cleanup and optimization tool. It doesn’t require PhpMyAdmin to optimize your database tables. It allows you to remove post revisions, comments in the spam queue, un-approved comments within few clicks.

If you’re not aware post revisions eat up lot of space on your database and 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.

Download here


3. WP-Clean Fix

WP CleanFix is a management tool for check, repair, fix and optimize your WordPress blog. The Ajax interface allow to manage all status in one only page!

Features

Database Tables optimization
Check/Remove for unused UserMeta
Check/Remove for Post Revision and Trash
Check/Remove for unused Post Meta
Check/Remove for unused Tags
Check/Remove/Relink for Posts without Authors
Check/Remove/Relink for Pages without Authors
Check/Remove for Attachments without Post/Page
Check/Remove for unused Categories
Check/Remove for unlink Categories (terms)

Download


Wodpress,Wodpress tips,Wodpress tricks,Wodpress blog,Wodpress plugin,Wodpress widget,Wodpress database,database optimization