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.

The phpMyAdmin tool I will be using is build into the control panel provided by hosting company, Hostmonster.com.

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.

- 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!!

Please give us some feedback, let us know your thoughts about "How to Optimize Joomla MySql Tables with phpMyAdmin"! 

Bookmark with:

              

• Joomla - Find Your Database Name
• How to setup and Implement Google Analytics in Joomla 1.5
• Joomla - How to Import User Information into your Contacts in Outlook