Truncate Customer Log tables in Magento

This entry was posted on November 05, 2012 by Brent W Peterson

To keep the size of you Magento Database small it helps to truncate your log tables.

The following is for MySQL access to truncate all data in your tables.

Always BACKUP first

TRUNCATE `log_customer` ;
TRUNCATE `log_quote` ;
TRUNCATE `log_summary` ;
TRUNCATE `log_summary_type` ;
TRUNCATE `log_url` ;
TRUNCATE `log_url_info` ;
TRUNCATE `log_visitor` ;
TRUNCATE `log_visitor_info` ;
TRUNCATE `log_visitor_online` ;

Twitter: @brentwpeterson on Twitter
Linkedin: http://www.linkedin.com/in/brentwpeterson
View My Magento Profile