It is important to optimize your database tables every so often because it will help improve performance and load time of your site. This task is very easy and there should be no excuse for not doing this every so often. Let’s face it, if your site is slow, people will go else where.

 

Note: This process can be done for other database sites as well such as Wordpress. The steps I am going to show you are related to a MySql database and the phpMyAdmin tool.

 

Before we begin we will need to know what are database name is. This can be found in the admin counsel under global configuration. If you need some more details take a look at the article "Joomla - Find Your database name".

 

Now that we know are database name we will want to launch phpMyAdmin.

Most Hosting Companies allow you to open phpMyAdmin tool from cpanel. If you running this on your own ubuntu server you can install it by launch a terminal and running the following command: sudo apt-get install phpmyadmin. Once completed you can access at http://servername/phpmyadmin

 Example from cpanel

 

 

- Select the database you would like to optimize from the left panel

 

 

 

 

You should now see your database tables.

 

 

 

 

- Scroll to the bottom of the page and select "Check All"

 

 

 

 

Select Optimize Table from the drop down.

 

 

You should now see what tables got optimized and which ones did not need to be. I just optimized a little bit before I took that screen shot so not to many changed since then.

 

That was easy!!

ShareThis