There are many ways to optimize your blog in order to speed it up.

One of the way is to optimize the MySQL database of your blog..

The reason you need to optimize the database is that over a period of time and usage, the database will be fragmented.

I have read in a couple blogs on how to optimize the blog. When I saw the commands, programming codes and lengthy steps required to optimize the database, I froze. I told myself I am not going to use those methods. I knew that all it takes is one wrong move and my blog’s database will be corrupted.

I have search around and found a useful plugin that allow optimizing your blog database safely and efficiently.

It is known as Optimize DB.
You can download it here at http://yoast.com/wordpress/optimize-db/

Installation
You just need to download the zip file from the above site.
Unzip the file
Upload the file to your blog’s plugin folder.

Usage
At the Manage Plugin screen, go to the Optimize DB plugin and select Activate.

At the Optimize DB’s plugin, select Optimize.

It will read your blog’s database and display a similar list. You just need to click on Optimize Now.

optimise DB01b

Once it finished optimizing, it will display below.

optimise DB02

Simple isn’t ?

I hope the above article is useful to you.

Regards
Alwin Chuah

Interesting articles:

speed-up-your-wordpress-blog-through-wp-super-cache/

super-affiliate-blogger

link-that-open-in-new-tab-or-window

check-your-blog-posting-in-google

risk-with-wordpress-id

free-photos-for-your-blog

Click Here to claim Your Free Money Making Blog

Reblog this post [with Zemanta]
 
 
pf button both Improve your blog speed by optimize your blog’s MySQL Database

Like this post? Subscribe to my RSS feed and get loads more!