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:

Sahil Chugh

He is the CEO and founder at MageHost. Sahil loves to solve problems and makes sure his clients have a speedy website. When not working hard on his Mac, he is seen traveling!