Magento Stack Exchange
Magento Stack Exchange

Questions tagged [indexing]

Questions about the Magento indexer. This includes the flat catalog index. For MySQL indexes, use the "mysql -indexes" tag instead.

381 questions
23
votes
3 answers

When are the indexes invalidated?

I have a shop and all the time ALL indexes are invalid. I noticed, that I have no clue, when an index is invalidated. Can you give me a list of "all" events, which make one or more of these indexes to get invalid? Product Attributes Product…
Fabian Blechschmidt
  • 35,388
  • 8
  • 75
  • 182
6
votes
2 answers

Why Magento locks are stored in file system?

Maybe I'm missing something obvious but why Magento is storing database locks in a file system? Storing them in a database instead will make it faster and will also resolve the clustering issue. Any ideas?
Tim Bezhashvyly
  • 11,575
  • 6
  • 43
  • 73
5
votes
1 answer

Category Products Indexing

If I re-index catalog_category_product, shouldn't the tables catalog_category_product and catalog_category_product_index have the same amount of entries afterwards? If not, what is the difference or what explains it? If yes, how come they are still…
Celldweller
  • 967
  • 3
  • 15
  • 26
5
votes
2 answers

Indexer model is not defined

I'm using Magento CE 1.7. here is the error I get suddenly, each time I access the "index management" screen (so I canot access it anymore), or each time I try to update a product (so i can't save product anymore) and each time I try to…
Rod
  • 145
  • 1
  • 1
  • 5
4
votes
1 answer

Magento index_process* tables cleanup

Magento's index_process* tables (index_process_event and index_event) are getting quite big. I was looking in Mage_Index (Magento 1.7.0.2) module if there is something in place for cleanup (deleted entries that are not required). Am I missing…
FlorinelChis
  • 2,900
  • 2
  • 26
  • 41
2
votes
2 answers

check if reindexing is needed

I need to easily and quickly check if indexing needs to be done. I have been looking around and have $process = Mage::getSingleton('index/indexer')->getProcessById(); or $process =…
Quantum
  • 553
  • 8
  • 35
2
votes
0 answers

Re-indexing issue

I am using CE 1.8 and facing re-indexing issue. While re-indexing from the Magento Admin Panel sometimes we get errors like “An error occurred while saving the URL rewrite” or “cannot initialize indexer process”. Any help would be appreciable
Abhishek Gupta
  • 1,185
  • 8
  • 17
1
vote
2 answers

What would cause Catalog Rewrites Indexer to need refreshed immediately after it completes?

Immediately after reindexing the Catalog URL Rewrites, Magento says we need to reindex them again. I'm using the command line to run indexer.php as a background task: nohup php indexer.php --reindex catalog_url > /home/ubuntu/rewrites_index_20130218…
Aaron Pollock
  • 1,169
  • 1
  • 13
  • 22
1
vote
1 answer

Tables to safetly truncate

I want to ask, which tables can I safely truncate in Magento, (I want to truncate all tables generated by the indexation process to make a new reindex of all my data)
Adel Tunesier
  • 21
  • 1
  • 7
0
votes
2 answers

Magento - Website/Store level indexing

We are working on Magento 1.7.0.2 (community). We have created multiple websites. Our query is, is there way to indexing on selected website or store? like website or store level configuration. Consider the the scenario, we have 3 website (WEBSITE1,…
Kishor Hase
  • 908
  • 11
  • 22
0
votes
2 answers

Problem Reindexing Catalog Url

I am trying to reindex my magento installation but I get this error when I run: php indexer.php --reindex catalog_url Catalog URL Rewrites index process unknown error: exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1206 The…
Niko Zarzani
  • 185
  • 3
  • 18