Over time, Magento installs can become bloated with unnecessary data, the main culprit here is the log tables such as log_url in the database. They can get very large and eventually slow down your Magento install. The log tables that can be safely truncated include:

  • log_url
  • log_url_info
  • log_visitor
  • log_visitor_info

The easiest way to clean these tables is via SSH, log into your server and navigate to the web root then run the following command:

php shell/log.php clean
  •  
  •  
  •  
  •  
  •  
  •