My Magento installation (1.4.1) contains the following tables:


Since there is an index in their name, will they be rebuilt by a re-index, that is, may I safely truncate them?

I can not find any of them in the list of tables that are safe to truncate here.

I'm on Magento 1.4.1, although this might apply to other versions as well, provided these tables exist.

  • possible duplicate of Is it safe to truncate the catalog_category_product_index table? – Marius Mar 20 '14 at 13:51
  • Nope, this refers to a differet set of tables which wasn't answered in the question above. – workflow Mar 20 '14 at 14:03
  • Damn. Sorry. I promise to read more carefully next time. I will retract my close vote. – Marius Mar 20 '14 at 14:16
  • @workflow did you ever end up doing this? If so did it work? – David Manners May 23 '14 at 14:02
  • @david-manners We did truncate the catalogindex_price table only, as it was somewhat larger - the others are negligible in size. No adverse effects so far, after running in production for almost a month. Since Magento hasn't re-populated it, I'm guessing these are indeed legacy tables leftover after an update. – workflow Jun 2 '14 at 21:12

Looking into the history of app/code/core/Mage/CatalogIndex/etc/config.xml it turns out that:

  • catalogindex_price was removed in 1.4
  • catalogindex_minimal_price is still used as of 1.9
  • catalogindex_eav was removed in 1.4
  • catalogindex_aggregation is still used as of 1.9
  • catalogindex_aggregation_tag is still used as of 1.9
  • catalogindex_aggregation_to_tag is still used as of 1.9

That being said, it's safe to DROP catalogindex_price and catalogindex_eav and safe to TRUNCATE the others if you rebuild the index afterwards. But note that the shop might behave weird until the reindex process finished so you might want to put it into maintenance mode. And as always, don't forget to make backups.


| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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