How to optimize your Joomla 3.0 Website Database

Rate this item
(1 Vote)
Wednesday, 22 May 2013 07:38;
Published in Joomla Tutorials;

At times, your website may get slow or dont respond as it normally does. You may get errors like MySQL died, Request time out, MySQL is not responding etc. 

This is due to the MySQL limitations of server incapability to handle the traffic load. In order to fix this or get rid of this issues, make sure, you are doing a regular monthly or weekly maintenance of your Joomla database. Here are few tips :

  1. Select all tables and REPAIR tables
  2. Select all tables and OPTIMIZE tables
  3. Find out all the large tables and manipulate them to find, which can be emptied or cleaned off
  4. Find all the finger_terms table and empty them. This is the main reason, why Joomla 3.0 websites get really slow, when limited resources are available.
Read 2499 times Last modified on Saturday, 29 June 2013 14:16
comments powered by Disqus

We are on Facebook

Tutorials Search