0

I just exported my DB and found my DB file size 761 MB

I think this is too heavy and effect badly to admin performance

Am I something wrong while running store? Is it okay with this big db file size?

(I just also found I exported same commend and found my DB file size 665 MB this time strange..)

2
  • For an established store this is actually small - I regularly work on stores with databases of several GB in size. Commented Oct 28, 2014 at 16:54
  • 1
    Sounds about right. You are after all, running Magento. It's one of the reasons you don't run Magento on a resource poor server. If database size is your major concern, you need to check into other ecommerce software. Commented Oct 28, 2014 at 21:15

2 Answers 2

1

Completely fine. You can do some cleaning of various tables without affecting the store. Example cleanup operations. I've worked on sites with 3-5GB database dumps. Good sites, nice load times and no issues.

2
  • Thanks! I just dump again I got 1.7 GB, Do you know why the file size different each time I dump?
    – Yohan
    Commented Oct 29, 2014 at 0:42
  • Could be logs, or some system working with a temporary table? Commented Oct 30, 2014 at 0:45
2

Magento maintains several tables for logging. These tables log things such as customer accesses and which products have been compared. Magento has a mechanism for cleaning these logs regularly, but unfortunately this feature is disabled by default and most customers do not turn it on.you can use below SQL query to clean your DB table.

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;
1
  • Be wary truncating report_viewed_product_index - it can cause catastrophic product page errors on some sites.
    – choco-loo
    Commented Oct 29, 2014 at 1:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.