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?

1 Answer 1


Check these link you might get some idea




  • None of those explain why the frontend user access should be blocked at all. Jan 13, 2015 at 6:17
  • Wht is size of your catalog
    – sunel
    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. Jan 13, 2015 at 6:19
  • have to tried indexing using shell
    – sunel
    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. Jan 13, 2015 at 6:21

Your Answer

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

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