Skip to content

Instantly share code, notes, and snippets.

@dermatz dermatz/clean-logs
Last active Aug 29, 2015

Embed
What would you like to do?
magento-db-log-cleanup
-- clean all patches
TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
-- clean all logs
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;
-- clean all reports
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.