Tutorial

In this article I will show you how to optimize your database overhead.

Over time your database may start to perform poorly. We could attribute some of this performance loss to overhead in the database. Overhead can lead to or cause a number of problems and issues. And let's face it there is nothing wrong with optimizing.

We can easily check and optimize our database tables using phpmyadmin. Most hosts do have phpmyadmin available in your hosting control panel.

So first lets just check to see if we have any overhead.

Login to your hosting control panel and navigate and open up phpmyadmin.

Once phpmyadmin opens or loads up find, select or click your database on the left hand column.

Now you will see your tables and we want to check the column "Overhead".

If you have any database overhead it will tell you how much. If you have many tables with overhead, or only a few, but with big numbers you might consider optimizing. Note 5.0 KiB is larger than 500 B. (5.0 KiB = 5 kilobytes or approximately 5000 bytes. 500 B = 500 bytes (so in this case the 5.0 KiB is a lot larger.)

If you have a lot of tables with overhead or a few tables with large overhead and you decide you want to optimize, you should first download and backup your database before proceeding.

You never know when something happens that just don't go as planned, and when the database is involved it is always wise to make a backup first.

So after you have downloaded your database backup, you simply check the box for the table that has the overhead.



phpMyAdmin Dolphin Table with Overhead:


Dolphin Database With Overhead
 

Then go to the bottom of the page, and in the drop down menu simply select "Optimize table".

phpMyAdmin Select Optimize table:


Select Optimize Table

 


Once it completes the process the overhead you original saw should be gone.



phpMyAdmin no more Overhead:


Dolphin Database Optimized

 


Now just go back and repeat the process for any other tables that have overhead.


Or if you are comfortable with this and would like to do all tables with overhead at once. Scroll to the bottom and find and click "Check tables having overhead". This will select all tables with overhead for you. Then, select "Optimize table" from the drop down and it will do them all at once for you.


Select All Dolphin Tables With Overhead

 


That's about it. You should have a fully optimized Dolphin database now.

Any problems, or if you did something wrong. Simply restore the backup database you downloaded prior to optimizing.

DO NOT:
Select the Empty or Drop in the drop down. If you do it will delete and remove the table from your database, and then you will have major problems. So take your time and read this over a few times making sure you understand the steps and directions.

Overall I would consider this fairly easy, and not very time consuming. Just make sure you download a backup database prior to messing with this, especially if you are not too familiar with phpmyadmin.


Tips:
You should check this occasionally and optimize when necessary.
This is not Dolphin specific, so if you have other databases you might check them and optimize them as well.

For those of you that have VPS or dedicated servers you can use this same method, or you might look into optimizing your database's server wide from the root level. A Cron to optimize at specific time intervals would work well providing you don't have a ton of databases, and many very large databases.

 
Written By
Tutorial by: Jeremy LeSarge (AKA Ray)

I am the owner and administrator of DialMe.com. I write Tutorials for Boonex Dolphin as well as tips and resources surrounding website programming and development. I enjoy working with WordPress, SEO, and Web Hosting / Servers. I also maintain a WordPress Blog here on this site where you will find a variety of technology and webmaster resources.

Actions
Recommend
Sponsored Links