Jan
25
2009

Optimizing your MySQL database with PhpMyAdmin & WP-Plugin

It is always a good idea to maintain your databases’ tables optimized to potentially maximum your application. Here, I will introduce 2 simple guides to optimize your MySQL Database.

PhpMyAdmin
1. Log in to your phpMyadmin

2. Select your database

3. Highlight or Check all the database’s tables

4. Under the box of “With selected”, select Optimize table.

Done, optimize table SQL query on the selected tables were executed.

Next, I will introduce another optimize plug-in for WordPress 2.7

WP-Optimize
In fact, this plug-in is pretty simple to use and install. As usual, upload the document/files to your wp-content/plugins. Consequently, log on your dashboard – plug-in and active the plug-in.

1. Log in your Dashboard (WordPress 2.7) and you will see WP-Optimize at the top left corner.

2. There are 4 option there ( Normally, I select all)
a.) Remove All Post revisions
b.) Clean marked Spam Comments
c.) Clean Unapproved comments
d.) Optimize database tables

3. Next, Click Process

4. Lastly, you may see the report under the same page

Download Here: Click Here

In addition, there are few more feathers that available under this plug-in.


Author: Ruhani Rabin

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.

For information available at WordPress Plugins

About the Author:

ShawnLiv, the founder and editor of GenPlace Forum, ShawnLiv Dot Com, and Shawn's Tech Place. Learn more about him and follow him on Twitter at @shawnliv

4 Comments + Add Comment

  • Thanks — I’ll definitely download the plugin, and recommend to the other blogs I host. Much easier than doing the phpMyAdmin thing.

    – Sean

  • @Sean
    You’re welcome Sean, but i think the one we should really thank is the Author: Ruhani Rabin

Leave a comment

Email Updates

Enter your email address:

FaceBook Fan’s Page