Optimize magento database Log Cleaning

Optimize magento database Log Cleaning

SET foreign_key_checks = 0;

TRUNCATE dataflow_batch_export;

TRUNCATE dataflow_batch_import;

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;

TRUNCATE report_viewed_product_index;

TRUNCATE report_compared_product_index;

TRUNCATE report_event;

TRUNCATE index_event;

TRUNCATE catalog_compare_item;

SET foreign_key_checks = 1;