When we are using the wordpress sites then we need to clean the database always. If your site is having more than 500 articles then you need to worry about server performance.
Mysql load will impact your server. Many people are suggesting to use the WP-DBManager wordpress plugin. But forgot about plugin feature. That plugin specially made for database backup and managing the tables.
If you want to optimize your wordpress database then you need to use wp-optimize wordpress plugin. I found that is only plugin is helpful for really keep optimize your wordpress database.
I used that plugin. Before using that plugin my mysql database size was 135mb. After using that wp-optimize plugin features database size was 4mb. That means my database really really optimized.
My sites performance was also improved.
What is features of wp-optimize?
- 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.
I really liked this wordpress plugin. Thanks to Ruhani Rabin who wrote this plugin.
You can download this plugin from here
http://wordpress.org/extend/plugins/wp-optimize/
I REALLY liked your post and blog! It took me a minute bit to find your site…but I bookmarked it. Would you mind if I posted a link back to your post?
I was just having a conversation over this I am glad I came across this it cleared some of the questions I had.
This post makes a lot of sense !
Thanks for posting. Good to see that not everyone is using RSS feeds to build their blogs
Awesome post. I so good to see someone taking the time to share this information
Nice post! You truly have a wonderful way of writing which I find captivating! I will definitely be bookmarking you and returning to your blog. In fact, your post reminded me about a strange thing that happened to me the other day. I’ll tell you about that later…
I would like to say “wow” what a inspiring post. This is really great. Keep doing what you’re doing!!
This post makes a lot of sense !
Great read. Thanks for the info!
I’ve been checking your blog for a while now, seems like everyday I learn something new
Thanks
Nice post! You truly have a wonderful way of writing which I find captivating! I will definitely be bookmarking you and returning to your blog. In fact, your post reminded me about a strange thing that happened to me the other day. I’ll tell you about that later…
Intriguing post. I have been searching for some good resources for solar panels and discovered your blog. Planning to bookmark this one!
Interesting read, perhaps the best article iv’e browse today. We learn everyday cheers to you!