1

I believe older versions of Magento (e.g. 1.5) would drop the flat table and then rebuild it. It seems that in 1.7+, the flat table is not even dropped, just updated.

In either case, why does the frontend need to be disabled?

With 1.5, couldn't the system build the new flat index, then drop the old one and rename the new one to the required name? The only point where the frontend might need to be disabled would be during the relatively brief renaming process.

In 1.7, why disable the frontend at all? I manually changed "working" to "pending" for the catalog_product_flat index process. The frontend worked fine until the indexer got to a point where it expected to see "working" and instead saw "pending" and the website hanged. But that is a technicality. The point is that the frontend can keep working while the indexer is working.

So why disabled the frontend?

Improve this question

1 Answer 1

Reset to default
-3

Check these link you might get some idea

magento-reindexing-data-risks

solution-problem-with-reindexing-process-for-product-flat-data-indexes

permanent-solution-for-the-common-indexing-issue

Improve this answer
7
  • None of those explain why the frontend user access should be blocked at all.
    – Buttle Butkus
    Commented Jan 13, 2015 at 6:17
  • Wht is size of your catalog
    – sunel
    Commented Jan 13, 2015 at 6:18
  • about 130,000 active items. flat catalog reindex takes about 15 minutes. But there is no real reason I can see that the frontend should be completely blocked.
    – Buttle Butkus
    Commented Jan 13, 2015 at 6:19
  • have to tried indexing using shell
    – sunel
    Commented Jan 13, 2015 at 6:20
  • You don't seem to understand my question at all. Yes, we reindex using shell but that still triggers "site down for maintenance" message on the frontend.
    – Buttle Butkus
    Commented Jan 13, 2015 at 6:21

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.