Tech Magazine

Optimizing Your WordPress Database For A Better Performance

Posted on the 28 February 2013 by Babanature @proudlyonenaija

I’d like to ask you a question or 2; have you ever waked up one day and discovered that something is wrong with your website? Or have you ever notice your blog/ website or forum showing “500 Internal Server Error or 403 forbidden Error?

internal-server-error

If your blog is running slow or your blog always get 500 Internal Server Error then you’re driving away those valuable customers and loyal readers or even people (first timers) coming from search engines.

Must Read: CHANGING YOUR WORDPRESS USERNAME/ LOGIN NAME

Our blog runs slow or shows Internal Server Error (at times) because of database misuse and or too much plugins installed… And once you start getting too much Internal Server Error or slow performance, your hosting provider will have no choice but to knock your door and suggest you migrate to a VPS package. But do you know that you can actually avoid all that by optimizing your database? Don’t worry, we are going to make this post as interesting and comprehensive as possible. So are you ready to do this with me and make your website more faster? Then let’s go

OPTIMIZING YOUR DATABASE FOR A BETTER PERFORMANCE

If you have YARPP and Commentluv plugin installed on your wordpress blog then you need this even more. We need this to speed up our blog and making it user and browser friendly…

First off go to your control panel (C-panel) >>> Scroll to your “Databases” section and click “phpMyAdmin”. You are now in your “phpMyAdmin” section where we will work on our WordPress database.

Now click the Database that you want to optimize

Please note that your databases is located at the left side of the panel (see the screenshot below)

phpmyadmin database

Have you seen it? Click the database you want to optimize to take you to the database table. Now if you study your table carefully, you will discover that the “overhead” has some figures. Those figures needs to be optimized (wiped out). Now how do we optimize this?

Scroll down and click “Check tables having overhead” have you clicked it? Now click the drop down menu beside it and choose “Optimize table”

wordpress database

Once you have successfully optimize your WordPress tables, It will look like the screen shot below

mysql wordpress database

Note: Before doing anything with your database it is good to do a backup, incase you miss press a button, you can easily revert back.

Now your site will be 3 times faster that it usually is but to make our wordpress site even more faster like the first day you installed it, download this plugin called “WP Optimizer” you can download it here

Now let’s get to know what WP Optimize does from the horses words;

Every time 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 is a huge number of bytes that’s 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.

You need to optimize your database today to prevent error and wasted space. And remember, your blog is your business don’t play with it.

:)

Must Read: 8 Killer Ways Of Getting More Comments To Your Blog Post

I’ll ask you again; have you ever had a database problem? What measures did you take to correct it? Please I’d like to read your answers.

Do you have comments, questions and thoughts that you’d like to share? Then please do use the comment box below. Remember that your comment and thoughts are highly welcomed and much appreciated.

Do you like this post? Do click the like button, share us and recommend us to friend because you’ll never know which of your friends need it the most.

Don't Miss Any Post Again. Subscribe To Our Feed And Be Updated

Enter your email address below:

Powered by OnenaijaBlog


You Might Also Like :

Back to Featured Articles on Logo Paperblog

These articles might interest you :

Magazine