1832

WP-Optimize Database Cleanup and Optimization Plugin for Wordpress

wp-optimize
I use wordpress solutions in a day to day basis. Wordpress comes with a very extensible framework that allows you to add comprehensive and powerful functionality to your Blog system. WP-Optimize plugin is written to simplify your daily wordpress works and make it simpler. WP-Optimize is a wordpress 2.7++ 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. Additionally you can rename any username to another username too. Here are the details.
Hosted at Wordpress Official Plugin Directory

How this could help you?

  • Everytime 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’s a huge number of bytes thats 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 spams 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
  • Wordpress doesn’t allow you to rename existing username which could be a security issue because your default wordpress admin username is “admin”, if you read my Wordpress Security guide article, you will know the risks involved. WP-Optimize can rename any existing username to other name

Features:

  • Remove the existing wordpress post revisions
  • Remove all the comments in the spam queue
  • Remove all the un-approved comments
  • Rename one username to another username, it’s designed to rename default “Admin” user to something else
  • Apply MySql optimize commands on your database tables without phpMyAdmin.
  • Display Database table statistics.

Requirements:

  • It Requires wordpress version 2.7 and higher. Tested with 2.7

Installation:

  • Unzip the archive into your hard drive.
  • Upload the folder to your wp-content/plugins folder on your web host.
  • Login to your dashboard and activate the plugin via activate option.
  • The menu item is under Dashboard>WP-Optimize.

Usage:

  • Select the WP-Optimize menu item under Dashboard dropdown menu
  • Select the actions you want to perform
  • Click on Process button

Screen Shots:
screenshot-1

 

screenshot-2

This is a primary version of the plugin so any feedback here would be highly appreciated.

WP-Optimize Plugin Latest - Size:  Downloaded: 2809 times


Did this plugin helped you out?
Would you like to donate an amount for this Plugin?
Donate for this Plugin

GD Star Rating
loading...
WP-Optimize Database Cleanup and Optimization Plugin for Wordpress9.71016

About Ruhani Rabin

Ruhani Rabin is the original owner and author of this blog. He also reviews web 2.0 startups at Tech2all.com. Largely interested in web 2.0 apps & Social Media. Currently the Vice President of MOL Access Portal (MOL is owner of Friendster.com). Also he is Web 2.0 & Social Media Researcher and a Total fun Geek!.. There you have it ;)

Twitter Profile: http://twitter.com/ruhanirabin

  • Great plugin. I does exactly what it is supposed to do and works like a charm.
    Thank you!
  • Hello ruhani,
    just wanted to say thanx for the plugin, saves me a few minutes.
    I wonder if there's a way to schedule it to do a weekly cleaning?
    Also echo scottwyden's comment bellow, merge with WP-DBManager and we're laughing.
  • Hello, i like to add the total space information.

    i would like to add this lines in your next version.

    in line 351 add line: $total_gigi+=$total;
    in line 399 add line: <?php $total_gigi = round ($total_gigi,3);?>
    in line 412 add line:

    <?php _e('Total space:', 'wp-optimize'); ?> <?php echo $total_gigi?> Kb

  • Great plug-in
    Thanks
    Will
  • Hi Ruhani,
    Thanks for the great plugin.
    Following is the translation Bazilian Portuguese: http://bit.ly/62QGvV
    ;)
  • Correction download link WP-Optimize 0.8.0: http://bit.ly/62QGvV
  • Hey Rabin
    Thanks for this great plugin this is must use plugin for people like me who dont want to mess with phpmyadmin that always scared that something will surely go wrong.
    Thanks again
  • thanks for sharing i know some of them but for else thanks for it.
  • The Wordpress Development Team at Xieno has acquired a growth along with the growth of Wordpress itself. Our team is capable of providing almost any kind of solution, possible, in Wordpress. Despite of its powerful Bloging opportunity our Wordpress portfolio is consist of eCommerce Solutions, Photo Gallery, Social Networking, Link Directory, CMS enabled Informative Portal etc.
  • Hi Ruhani , this is a great plugin ( Im quite new to all things Wordpress :D ) - and I just have 1 question : How compatible is this now to WP 2.9 ? [ I dont want to cause brain damage to my new version :D ] . Your response is greatly appreciated . Thank you :)
blog comments powered by Disqus