Log cleaning in Magento is great, and they even provide a shell script for cleaning log tables. But sometimes I just want to do it the fast way through the MySQL cli. To do that I run this script.<\/p>\n
[sql]TRUNCATE TABLE dataflow_batch_export;
\nTRUNCATE TABLE dataflow_batch_import;
\nTRUNCATE TABLE log_customer;
\nTRUNCATE TABLE log_quote;
\nTRUNCATE TABLE log_summary;
\nTRUNCATE TABLE log_summary_type;
\nTRUNCATE TABLE log_url;
\nTRUNCATE TABLE log_url_info;
\nTRUNCATE TABLE log_visitor;
\nTRUNCATE TABLE log_visitor_info;
\nTRUNCATE TABLE log_visitor_online;
\nTRUNCATE TABLE report_viewed_product_index;
\nTRUNCATE TABLE report_compared_product_index;
\nTRUNCATE TABLE report_event;[\/sql]<\/p>\n","protected":false},"excerpt":{"rendered":"