I want to know how reindexing works in Magento2. I am wondering what affects in my database when we do reindexing in Magento2.

Can anyone help me in this please

Thank you

3 Answers 3


indexer:info ==> Shows allowed Indexers
indexer:reindex ==> Reindexes Data
indexer:reset ==> Resets indexer status to invalid
indexer:set-mode ==> Sets index mode type
indexer:show-mode ==> Shows Index Mode
indexer:status ==> Shows status of Indexer

php bin/magento indexer:reindex


You can go through this to get proper knowledge of Indexing in Magento 2 Click here

Topics in this blog covers:

Indexing Types

Index Status

Indexing Modes

Materialized View


Custom Index in Magento 2

Manage Magento 2 Indexers and many more


Can you share the issues that are occurring when re indexing your magento .

  • I am not getting any issues. I want to get in-depth knowledge of reindexing in magento. 1. Why reindexing is introduced in Magento. 2. What happens in database when we do reindex. etc etc Aug 8, 2022 at 12:28
  • In Short, If you see the database we will see the indexers tables there. When we use the indexer then it updates the data there and shows us at the front.
    – Rana Zain
    Aug 8, 2022 at 12:49
  • I see there are some tables ending with "_replica". When i run the indexing, the data seems to update in "_replica" tables. Is that correct ? Aug 9, 2022 at 6:59
  • Can you please share the screenshot of the tables, so I can check
    – Rana Zain
    Sep 15, 2022 at 8:10

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.