You are here: Home / Topics / Wordpress / WP-Optimize Database Cleanup and Optimization Plugin for WordPress

WP-Optimize Database Cleanup and Optimization Plugin for WordPress

January 21, 2009 By 623 Comments

wp-optimize

Latest version hosted at WordPress Official Plugin Directory

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 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.

Funding and Feature Suggestions

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 that is 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 username which could be a security issue because your default WordPress administrator 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:

  • Requires PHP 5.1.xx and MySQL 5.1.xxx
  • It Requires WordPress version 2.9 and higher. Tested with 2.9 & 3.xx
  • InnoDB Table formats not supported yet

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. In addition to that you can post your feature suggestions at Fundry.com

WP-Optimize Plugin Latest - Size: 133.34 kB Downloaded: 9271 times


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

Comments

comments

Filed Under: Wordpress
About Ruhani Rabin

Ruhani Rabin is the original owner and author of this blog. Largely interested in web 2.0 apps & Social Media. Currently the Idea Generator (Senior Vice President of Friendster.com). Also he is Media Researcher and a Total fun Geek!.. There you have it ;)