{"id":11829,"date":"2026-06-02T04:23:38","date_gmt":"2026-06-02T04:23:38","guid":{"rendered":"https:\/\/www.magetop.com\/blog\/?p=11829"},"modified":"2026-06-02T04:26:38","modified_gmt":"2026-06-02T04:26:38","slug":"magento-2-indexers-explained","status":"publish","type":"post","link":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/","title":{"rendered":"Magento 2 Indexers Explained: Types, Modes & Troubleshooting"},"content":{"rendered":"\n

If you have ever run bin\/magento indexer:status<\/code> and stared at a wall of “invalid” or “working” statuses, you already know that Magento 2’s indexer system is both essential and sometimes mysterious. This guide cuts through that mystery: what each indexer actually does, which update mode to choose, how the changelog mechanism works under the hood, and the exact steps to diagnose and fix the most common indexer problems.<\/p>\n\n\n\n\n\n

What Is an Indexer in Magento 2?<\/h2>\n\n\n\n

Magento stores raw data in normalized relational tables \u2014 products, prices, attributes, stock levels. Querying that raw data in real time for every storefront request would be brutally slow. Indexers solve this by pre-computing derived data<\/strong> and storing it in flat, optimized tables that the frontend reads directly.<\/p>\n\n\n\n

Think of indexers as the layer between your admin edits and what customers actually see. When you change a product price, that change does not immediately appear in the flat price table \u2014 the indexer has to run first and propagate the new value.<\/p>\n\n\n\n

\n\n\n\n

All Magento 2 Indexer Types Explained<\/h2>\n\n\n\n

Magento 2.4.x ships with eleven indexers by default. Here is every one of them, with its indexer code and what it builds:<\/p>\n\n\n\n

1. catalog_category_product<\/h3>\n\n\n\n

Builds the mapping between categories and their assigned products. Used by category pages to know which products belong to which category. Any change to category assignment or category hierarchy triggers this.<\/p>\n\n\n\n

2. catalog_product_category<\/h3>\n\n\n\n

The reverse of the above \u2014 maps each product to its parent categories. Used for breadcrumbs and layered navigation.<\/p>\n\n\n\n

3. catalog_product_attribute<\/h3>\n\n\n\n

Flattens EAV product attribute data into a single flat table (catalog_product_flat_*<\/code>). This makes storefront product queries dramatically faster because instead of doing dozens of EAV joins, Magento reads one row per product. Requires the Flat Product<\/strong> setting to be enabled in admin (Stores > Configuration > Catalog > Storefront > Use Flat Catalog Product<\/code>).<\/p>\n\n\n\n

4. catalog_product_price<\/h3>\n\n\n\n

Computes the final price for every product across every customer group, website, and currency. This includes tier prices, special prices, catalog price rules, and tax. The output lands in catalog_product_index_price<\/code>. This is typically the most expensive indexer to run<\/strong> because of the permutations involved.<\/p>\n\n\n\n

5. cataloginventory_stock<\/h3>\n\n\n\n

Rebuilds stock status for all products, combining source stock (MSI) data with salability rules. Without a valid stock index, “In Stock \/ Out of Stock” labels and add-to-cart availability are unreliable.<\/p>\n\n\n\n

6. catalogrule_rule<\/h3>\n\n\n\n

Applies catalog price rules to products and writes the results to catalogrule_product<\/code> and catalogrule_product_price<\/code>. This runs automatically at midnight via cron but must be forced manually after rule changes.<\/p>\n\n\n\n

7. catalogrule_product<\/h3>\n\n\n\n

Depends on catalogrule_rule<\/code>. Calculates the discounted prices per product after rules are applied and feeds those values into the price index.<\/p>\n\n\n\n

8. catalogsearch_fulltext<\/h3>\n\n\n\n

Builds the search index inside Elasticsearch or OpenSearch. Every change to a product’s name, SKU, description, or searchable attributes must be indexed here before the product appears in search results or layered navigation.<\/p>\n\n\n\n

9. design_config_grid<\/h3>\n\n\n\n

Indexes design configuration data (themes, header\/footer settings) for display in the admin design grid. Rarely a performance concern.<\/p>\n\n\n\n

10. customer_grid<\/h3>\n\n\n\n

Flattens customer data for the admin customer grid (Customers > All Customers<\/code>). Does not affect the storefront.<\/p>\n\n\n\n

11. catalog_product_flat (optional)<\/h3>\n\n\n\n

A secondary flat table indexer, separate from catalog_product_attribute<\/code>. It enables fast attribute queries across all product types when flat catalog is on.<\/p>\n\n\n\n

\n\n\n\n

The Two Update Modes<\/h2>\n\n\n\n

Every indexer operates in one of two modes. You can check them all at once with:<\/p>\n\n\n

\nbin\/magento indexer:status\n<\/pre><\/div>\n\n\n
Update on Save<\/h3>\n\n\n
\nbin\/magento indexer:set-mode realtime catalogsearch_fulltext\n<\/pre><\/div>\n\n\n
In this mode, Magento re-indexes immediately whenever relevant data changes \u2014 the moment you save a product, update a price, or assign a category. For small stores with low admin traffic, this is convenient: the storefront is always current.<\/p>\n\n\n\n
The downside is that every save triggers a potentially expensive reindex operation synchronously<\/strong>, making admin saves slow and causing timeouts on bulk imports.<\/p>\n\n\n\n
Update by Schedule (Recommended for Production)<\/h3>\n\n\n
\nbin\/magento indexer:set-mode schedule catalogsearch_fulltext\n<\/pre><\/div>\n\n\n
In schedule mode, Magento records what changed<\/em> \u2014 not the full reindex \u2014 into a changelog table<\/strong>, then processes those changes asynchronously via cron.<\/p>\n\n\n\n
How the Changelog Mechanism Works<\/h4>\n\n\n\n
Every indexer in schedule mode gets a pair of changelog tables in the database. For example, catalog_product_price<\/code> gets:<\/p>\n\n\n\n
    \n
  • catalog_product_index_price_cl<\/code> \u2014 the changelog table<\/li>\n\n\n\n
  • A database trigger on catalog_product_entity<\/code> that inserts the entity_id<\/code> of any modified product into the changelog table on UPDATE<\/code><\/li>\n<\/ul>\n\n\n\n
    When cron runs indexer:reindex<\/code>, Magento reads the changelog, processes only the affected entity IDs, and removes them from the log. This means that if 3 products changed since the last cron run, only those 3 products are reindexed \u2014 not your entire catalog of 50,000 SKUs.<\/p>\n\n\n\n
    To verify changelog tables exist for all schedule-mode indexers:<\/p>\n\n\n
    \nSHOW TABLES LIKE '%_cl';\n<\/pre><\/div>\n\n\n
    If changelog tables are missing, re-running bin\/magento setup:upgrade<\/code> will recreate them.<\/p>\n\n\n\n
    \n\n\n\n
    Choosing the Right Mode Per Indexer<\/h2>\n\n\n\n
    Not all indexers benefit equally from each mode. Here is a practical guide:<\/p>\n\n\n\n
    Indexer<\/th>Recommended Mode<\/th>Reason<\/th><\/tr><\/thead>
    catalog_product_price<\/code><\/td>Schedule<\/td>Expensive; slow on every save<\/td><\/tr>
    catalogsearch_fulltext<\/code><\/td>Schedule<\/td>ES\/OS writes are costly<\/td><\/tr>
    cataloginventory_stock<\/code><\/td>Schedule<\/td>Bulk imports need async<\/td><\/tr>
    catalog_product_attribute<\/code><\/td>Schedule<\/td>Flat rebuild is heavy<\/td><\/tr>
    catalog_category_product<\/code><\/td>Schedule<\/td>Tree changes are infrequent<\/td><\/tr>
    customer_grid<\/code><\/td>Realtime<\/td>Admin-only; low volume<\/td><\/tr>
    design_config_grid<\/code><\/td>Realtime<\/td>Rarely changes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    For most production stores: put all performance-sensitive indexers on Schedule and ensure cron is running every minute.<\/strong><\/p>\n\n\n\n
    \n\n\n\n
    Running a Reindex<\/h2>\n\n\n\n
    Full reindex of all indexers:<\/strong><\/p>\n\n\n
    \nbin\/magento indexer:reindex\n<\/pre><\/div>\n\n\n
    Reindex a specific indexer:<\/strong><\/p>\n\n\n
    \nbin\/magento indexer:reindex catalog_product_price\n<\/pre><\/div>\n\n\n
    Check status before and after:<\/strong><\/p>\n\n\n
    \nbin\/magento indexer:status\nbin\/magento indexer:show-mode\n<\/pre><\/div>\n\n\n
    Reset an indexer to “invalid” (forces a full reindex on next run):<\/strong><\/p>\n\n\n
    \nbin\/magento indexer:reset catalog_product_price\n<\/pre><\/div>\n\n\n
    For large catalogs, always run reindex from CLI \u2014 never from admin \u2014 and consider using nohup<\/code> or a terminal multiplexer so a dropped SSH connection does not abort mid-run:<\/p>\n\n\n
    \nnohup bin\/magento indexer:reindex > \/var\/log\/magento_reindex.log 2>&1 &\n<\/pre><\/div>\n\n\n
    \n\n\n\n
    Common Indexer Problems and How to Fix Them<\/h2>\n\n\n\n
    Problem 1: “One or more indexers are invalid. Make sure your Magento cron job is running.”<\/h3>\n\n\n\n
    This admin banner appears when indexer status is invalid<\/code>. It means data changed but the indexer has not run yet.<\/p>\n\n\n\n
    Fix:<\/strong><\/p>\n\n\n\n
      \n
    1. Confirm cron is running: ps aux | grep cron<\/code><\/li>\n\n\n\n
    2. Check the cron schedule table: SELECT * FROM cron_schedule WHERE job_code LIKE 'indexer%' ORDER BY scheduled_at DESC LIMIT 20;<\/code><\/li>\n\n\n\n
    3. Manually trigger: bin\/magento indexer:reindex<\/code><\/li>\n\n\n\n
    4. If cron is missing entries entirely, verify crontab -l<\/code> has Magento’s cron entry<\/li>\n<\/ol>\n\n\n\n
      Problem 2: Indexer stuck in “working” status<\/h3>\n\n\n\n
      Magento marks an indexer as “working” when a reindex process starts and uses a database lock. If the process crashes mid-run, the lock persists and the indexer never returns to “ready.”<\/p>\n\n\n\n
      Fix:<\/strong><\/p>\n\n\n
      \nbin\/magento indexer:reset\nbin\/magento indexer:reindex\n<\/pre><\/div>\n\n\n
      If that does not work, check for orphaned locks:<\/p>\n\n\n
      \nSELECT * FROM indexer_state WHERE status = 'working';\nUPDATE indexer_state SET status = 'invalid' WHERE status = 'working';\n<\/pre><\/div>\n\n\n
      Problem 3: Reindex runs but products still not appearing in search<\/h3>\n\n\n\n
      The search index may have rebuilt correctly in MySQL but the data has not been pushed to Elasticsearch or OpenSearch.<\/p>\n\n\n\n
      Fix:<\/strong><\/p>\n\n\n
      \nbin\/magento cache:flush\nbin\/magento indexer:reset catalogsearch_fulltext\nbin\/magento indexer:reindex catalogsearch_fulltext\n<\/pre><\/div>\n\n\n
      Also check that the search engine connection is healthy:<\/p>\n\n\n
      \nbin\/magento config:show catalog\/search\/engine\n<\/pre><\/div>\n\n\n
      Then verify connectivity from the Magento server to your search host on port 9200 (Elasticsearch) or 9200\/9300 (OpenSearch).<\/p>\n\n\n\n
      Problem 4: Price changes not reflecting on the storefront<\/h3>\n\n\n\n
      Usually a stale catalog_product_price<\/code> index combined with full-page cache.<\/p>\n\n\n\n
      Fix:<\/strong><\/p>\n\n\n
      \nbin\/magento indexer:reindex catalog_product_price catalogrule_rule catalogrule_product\nbin\/magento cache:clean full_page block_html\n<\/pre><\/div>\n\n\n
      Problem 5: Changelog tables missing after indexer set to schedule mode<\/h3>\n\n\n
      \nSHOW TABLES LIKE 'catalog_product_index_price_cl';\n<\/pre><\/div>\n\n\n
      If empty: changelog tables were not created. This happens after upgrades where setup:upgrade<\/code> was not run cleanly.<\/p>\n\n\n\n
      Fix:<\/strong><\/p>\n\n\n
      \nbin\/magento setup:upgrade\nbin\/magento setup:di:compile\nbin\/magento indexer:set-mode schedule\n<\/pre><\/div>\n\n\n
      \n\n\n\n
      Performance Tips for Large Catalogs<\/h2>\n\n\n\n
      1. Use schedule mode for all heavy indexers.<\/strong> The changelog mechanism means only changed entities are processed \u2014 the most important optimization for stores with 10,000+ SKUs.<\/p>\n\n\n\n
      2. Separate cron processes.<\/strong> Magento 2 supports cron groups (catalog<\/code>, default<\/code>). The catalog group handles indexing. You can run it on a dedicated cron process with higher resource limits.<\/p>\n\n\n\n
      3. Avoid running reindex during peak traffic.<\/strong> Full reindexes lock tables or create high DB load. Schedule them during off-peak windows.<\/p>\n\n\n\n
      4. Monitor with n98-magerun2:<\/strong><\/p>\n\n\n
      \nn98-magerun2 sys:cron:list\nn98-magerun2 index:list\n<\/pre><\/div>\n\n\n
      5. Watch changelog table size.<\/strong> If cron is not running, changelog tables grow unboundedly. Check periodically:<\/p>\n\n\n
      \nSELECT COUNT(*) FROM catalog_product_index_price_cl;\n<\/pre><\/div>\n\n\n
      A very large count (100k+ rows) means cron has been down for a while and your next reindex will be slow.<\/p>\n\n\n\n
      \n\n\n\n
      Summary<\/h2>\n\n\n\n
      Magento 2’s indexer system is designed to keep storefront performance high by pre-computing data that would be expensive to calculate on the fly. Understanding what each indexer builds, why schedule mode with changelogs is the right production choice, and how to diagnose stuck or invalid indexers gives you direct control over one of the most impactful subsystems in the platform.<\/p>\n\n\n\n
      The key takeaways:<\/p>\n\n\n\n
        \n
      • Schedule mode + cron<\/strong> is the correct setup for any store with meaningful catalog size or admin activity<\/li>\n\n\n\n
      • Changelog tables<\/strong> are the mechanism behind schedule mode \u2014 if they are missing, the system falls back silently<\/li>\n\n\n\n
      • Never ignore the “indexers invalid” banner<\/strong> in production \u2014 it means customers may be seeing stale prices, stock, or search results<\/li>\n\n\n\n
      • When in doubt, indexer:status<\/code> \u2192 indexer:reset<\/code> \u2192 indexer:reindex<\/code> is your diagnostic sequence<\/li>\n<\/ul>\n\n\n\n
        Keep your indexers healthy and your storefront stays fast and accurate.<\/p>\n
        \u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"
        Understand every Magento 2 indexer \u2014 what each does, update-on-save vs schedule mode, performance impact, and common fix steps.<\/p>\n","protected":false},"author":108,"featured_media":11831,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-11829","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magento-2-knowledge-base"],"yoast_head":"\nMagento 2 Indexers Explained: Types, Modes & Troubleshooting - Magetop Blog<\/title>\n<meta name=\"description\" content=\"Understand every Magento 2 indexer \u2014 what each does, update-on-save vs schedule mode, performance impact, and common fix steps.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Magento 2 Indexers Explained: Types, Modes & Troubleshooting - Magetop Blog\" \/>\n<meta property=\"og:description\" content=\"Understand every Magento 2 indexer \u2014 what each does, update-on-save vs schedule mode, performance impact, and common fix steps.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/\" \/>\n<meta property=\"og:site_name\" content=\"Magetop Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MagetopStore\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-02T04:23:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-02T04:26:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1376\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Callula Huy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MagetopStore\" \/>\n<meta name=\"twitter:site\" content=\"@MagetopStore\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Callula Huy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/\"},\"author\":{\"name\":\"Callula Huy\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/a2bf0aa38cec01bc41197b9ec4b3e8c9\"},\"headline\":\"Magento 2 Indexers Explained: Types, Modes & Troubleshooting\",\"datePublished\":\"2026-06-02T04:23:38+00:00\",\"dateModified\":\"2026-06-02T04:26:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/\"},\"wordCount\":1325,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png?fit=1376%2C768&ssl=1\",\"articleSection\":[\"Magento 2 Knowledge Base\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/\",\"url\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/\",\"name\":\"Magento 2 Indexers Explained: Types, Modes & Troubleshooting - Magetop Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png?fit=1376%2C768&ssl=1\",\"datePublished\":\"2026-06-02T04:23:38+00:00\",\"dateModified\":\"2026-06-02T04:26:38+00:00\",\"description\":\"Understand every Magento 2 indexer \u2014 what each does, update-on-save vs schedule mode, performance impact, and common fix steps.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png?fit=1376%2C768&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png?fit=1376%2C768&ssl=1\",\"width\":1376,\"height\":768,\"caption\":\"Magento 2 Indexers Explained: Types, Modes & Troubleshooting\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.magetop.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Magento 2 Indexers Explained: Types, Modes & Troubleshooting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#website\",\"url\":\"https:\/\/www.magetop.com\/blog\/\",\"name\":\"Magetop Blog\",\"description\":\"Exploring Magento Tips, Tricks, and Trends\",\"publisher\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.magetop.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\",\"name\":\"Magetop.com\",\"url\":\"https:\/\/www.magetop.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1\",\"width\":475,\"height\":475,\"caption\":\"Magetop.com\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/MagetopStore\",\"https:\/\/x.com\/MagetopStore\",\"https:\/\/www.linkedin.com\/company\/magetop\",\"https:\/\/www.pinterest.com\/magetop\",\"https:\/\/www.youtube.com\/channel\/UCXoiJsz88OfPmwa8QpUkwOA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/a2bf0aa38cec01bc41197b9ec4b3e8c9\",\"name\":\"Callula Huy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/321e837578b99a75c9d7f5c884e62e11b3b6df2b5934726e98fd365f580393c7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/321e837578b99a75c9d7f5c884e62e11b3b6df2b5934726e98fd365f580393c7?s=96&d=mm&r=g\",\"caption\":\"Callula Huy\"},\"description\":\"Callula is the Marketing Executive at Magetop. With more than 5 years of copywriting under his belt, Callula is into creating valuable content that is straight to the point. Life student. Workaholic. Foreign languages and traveling aficionado.\",\"sameAs\":[\"http:\/\/magetop.com\"],\"url\":\"https:\/\/www.magetop.com\/blog\/author\/callula-huy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Magento 2 Indexers Explained: Types, Modes & Troubleshooting - Magetop Blog","description":"Understand every Magento 2 indexer \u2014 what each does, update-on-save vs schedule mode, performance impact, and common fix steps.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/","og_locale":"en_US","og_type":"article","og_title":"Magento 2 Indexers Explained: Types, Modes & Troubleshooting - Magetop Blog","og_description":"Understand every Magento 2 indexer \u2014 what each does, update-on-save vs schedule mode, performance impact, and common fix steps.","og_url":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/","og_site_name":"Magetop Blog","article_publisher":"https:\/\/www.facebook.com\/MagetopStore","article_published_time":"2026-06-02T04:23:38+00:00","article_modified_time":"2026-06-02T04:26:38+00:00","og_image":[{"width":1376,"height":768,"url":"https:\/\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png","type":"image\/png"}],"author":"Callula Huy","twitter_card":"summary_large_image","twitter_creator":"@MagetopStore","twitter_site":"@MagetopStore","twitter_misc":{"Written by":"Callula Huy","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#article","isPartOf":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/"},"author":{"name":"Callula Huy","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/a2bf0aa38cec01bc41197b9ec4b3e8c9"},"headline":"Magento 2 Indexers Explained: Types, Modes & Troubleshooting","datePublished":"2026-06-02T04:23:38+00:00","dateModified":"2026-06-02T04:26:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/"},"wordCount":1325,"commentCount":0,"publisher":{"@id":"https:\/\/www.magetop.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png?fit=1376%2C768&ssl=1","articleSection":["Magento 2 Knowledge Base"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/","url":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/","name":"Magento 2 Indexers Explained: Types, Modes & Troubleshooting - Magetop Blog","isPartOf":{"@id":"https:\/\/www.magetop.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#primaryimage"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png?fit=1376%2C768&ssl=1","datePublished":"2026-06-02T04:23:38+00:00","dateModified":"2026-06-02T04:26:38+00:00","description":"Understand every Magento 2 indexer \u2014 what each does, update-on-save vs schedule mode, performance impact, and common fix steps.","breadcrumb":{"@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#primaryimage","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png?fit=1376%2C768&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png?fit=1376%2C768&ssl=1","width":1376,"height":768,"caption":"Magento 2 Indexers Explained: Types, Modes & Troubleshooting"},{"@type":"BreadcrumbList","@id":"https:\/\/www.magetop.com\/blog\/magento-2-indexers-explained\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.magetop.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Magento 2 Indexers Explained: Types, Modes & Troubleshooting"}]},{"@type":"WebSite","@id":"https:\/\/www.magetop.com\/blog\/#website","url":"https:\/\/www.magetop.com\/blog\/","name":"Magetop Blog","description":"Exploring Magento Tips, Tricks, and Trends","publisher":{"@id":"https:\/\/www.magetop.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.magetop.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.magetop.com\/blog\/#organization","name":"Magetop.com","url":"https:\/\/www.magetop.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1","width":475,"height":475,"caption":"Magetop.com"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/MagetopStore","https:\/\/x.com\/MagetopStore","https:\/\/www.linkedin.com\/company\/magetop","https:\/\/www.pinterest.com\/magetop","https:\/\/www.youtube.com\/channel\/UCXoiJsz88OfPmwa8QpUkwOA"]},{"@type":"Person","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/a2bf0aa38cec01bc41197b9ec4b3e8c9","name":"Callula Huy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/321e837578b99a75c9d7f5c884e62e11b3b6df2b5934726e98fd365f580393c7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/321e837578b99a75c9d7f5c884e62e11b3b6df2b5934726e98fd365f580393c7?s=96&d=mm&r=g","caption":"Callula Huy"},"description":"Callula is the Marketing Executive at Magetop. With more than 5 years of copywriting under his belt, Callula is into creating valuable content that is straight to the point. Life student. Workaholic. Foreign languages and traveling aficionado.","sameAs":["http:\/\/magetop.com"],"url":"https:\/\/www.magetop.com\/blog\/author\/callula-huy\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/06\/Magento-2-Indexers-Explained-Types-Modes-Troubleshooting.png?fit=1376%2C768&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/paOdw5-34N","jetpack-related-posts":[{"id":11362,"url":"https:\/\/www.magetop.com\/blog\/fix-one-or-more-indexers-are-invalid-magento-2\/","url_meta":{"origin":11829,"position":0},"title":"How to Fix \u201cOne or More Indexers Are Invalid\u201d in Magento 2","author":"Aaron LX","date":"February 27, 2026","format":false,"excerpt":"While working with Magento 2, you may sometimes see the system message:\u201cOne or more indexers are invalid. Make sure your Magento cron job is running.\u201d This warning usually appears in the Magento Admin panel and indicates that some indexers need to be rebuilt. Fortunately, the issue is quite common and\u2026","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How to Fix \u201cOne or More Indexers Are Invalid\u201d in Magento 2","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/02\/How-to-Fix-One-or-More-Indexers-Are-Invalid-in-Magento-2.png?fit=1200%2C667&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/02\/How-to-Fix-One-or-More-Indexers-Are-Invalid-in-Magento-2.png?fit=1200%2C667&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/02\/How-to-Fix-One-or-More-Indexers-Are-Invalid-in-Magento-2.png?fit=1200%2C667&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/02\/How-to-Fix-One-or-More-Indexers-Are-Invalid-in-Magento-2.png?fit=1200%2C667&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2026\/02\/How-to-Fix-One-or-More-Indexers-Are-Invalid-in-Magento-2.png?fit=1200%2C667&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":10677,"url":"https:\/\/www.magetop.com\/blog\/magento-2-opensearch-optimization\/","url_meta":{"origin":11829,"position":1},"title":"Magento 2 and OpenSearch: Best Practices for Store Search Optimization","author":"Aaron LX","date":"September 22, 2025","format":false,"excerpt":"Magento 2 OpenSearch optimization is essential for improving store search performance and delivering accurate product results. In this guide, we\u2019ll explore best practices for configuring search weight, stop words, and synonyms to enhance user experience and boost conversions. What is OpenSearch in Magento 2? OpenSearch is an open-source search and\u2026","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"Magento 2 and OpenSearch Best Practices for Store Search Optimization","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/09\/Magento-2-and-OpenSearch-Best-Practices-for-Store-Search-Optimization.png?fit=1200%2C667&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/09\/Magento-2-and-OpenSearch-Best-Practices-for-Store-Search-Optimization.png?fit=1200%2C667&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/09\/Magento-2-and-OpenSearch-Best-Practices-for-Store-Search-Optimization.png?fit=1200%2C667&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/09\/Magento-2-and-OpenSearch-Best-Practices-for-Store-Search-Optimization.png?fit=1200%2C667&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/09\/Magento-2-and-OpenSearch-Best-Practices-for-Store-Search-Optimization.png?fit=1200%2C667&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":4128,"url":"https:\/\/www.magetop.com\/blog\/magento-2-commands-list\/","url_meta":{"origin":11829,"position":2},"title":"Magento 2 SSH\/CLI Commands List","author":"Aaron LX","date":"January 8, 2021","format":false,"excerpt":"If you regularly run and set up the Magento 2 website, you will need to use the SSH and CLI commands. The commands in Magento are quite a few, and you'll probably miss out on some useful ones. I have compiled all the commands in Magento 2 SSH\/CLI Commands List.\u2026","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"Magento 2 SSH\/CLI Commands List","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/01\/Magento-2-SSH-CLI-Commands-List.jpg?fit=750%2C445&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/01\/Magento-2-SSH-CLI-Commands-List.jpg?fit=750%2C445&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/01\/Magento-2-SSH-CLI-Commands-List.jpg?fit=750%2C445&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/01\/Magento-2-SSH-CLI-Commands-List.jpg?fit=750%2C445&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":1640,"url":"https:\/\/www.magetop.com\/blog\/how-to-use-model-in-magento-2\/","url_meta":{"origin":11829,"position":3},"title":"How To Use Model In Magento 2","author":"Aaron LX","date":"April 1, 2020","format":false,"excerpt":"In this tutorial, we will learn about How To Use Model in Magento 2. This is a basic tutorial followed by How To Create Database Table in Magento 2. You should see the previous article to understand this lesson.","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"Magento 2 How To Use Model","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Model.png?fit=750%2C445&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Model.png?fit=750%2C445&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Model.png?fit=750%2C445&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2020\/04\/Magento-2-How-To-Use-Model.png?fit=750%2C445&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":5509,"url":"https:\/\/www.magetop.com\/blog\/unlock-reindex-process-in-magento-2\/","url_meta":{"origin":11829,"position":4},"title":"How To Unlock Reindex Process In Magento 2","author":"Aaron LX","date":"June 17, 2021","format":false,"excerpt":"In this post, I will guide you on\u00a0How To Unlock Reindex Process In Magento 2. Fix index locked error during the indexing process in Magento 2.","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How To Unlock Reindex Process In Magento 2","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Unlock-Reindex-Process-In-Magento-2.png?fit=1200%2C713&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Unlock-Reindex-Process-In-Magento-2.png?fit=1200%2C713&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Unlock-Reindex-Process-In-Magento-2.png?fit=1200%2C713&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Unlock-Reindex-Process-In-Magento-2.png?fit=1200%2C713&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Unlock-Reindex-Process-In-Magento-2.png?fit=1200%2C713&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":9255,"url":"https:\/\/www.magetop.com\/blog\/solving-cluster_block_exception-error-in-magento-2\/","url_meta":{"origin":11829,"position":5},"title":"Solving cluster_block_exception Error in Magento 2: Index blocked by [TOO_MANY_REQUESTS\/12\/disk usage exceeded flood-stage watermark, index has read-only-allow-delete block]","author":"Callula Huy","date":"August 14, 2024","format":false,"excerpt":"Today, we delve into the cluster_block_exception issue in Magento 2, exploring solutions recommended by experts.","rel":"","context":"In "Magento 2 Tutorials"","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"Solving cluster_block_exception Error in Magento 2","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2024\/08\/Solving-cluster_block_exception-Error-in-Magento-2.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2024\/08\/Solving-cluster_block_exception-Error-in-Magento-2.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2024\/08\/Solving-cluster_block_exception-Error-in-Magento-2.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2024\/08\/Solving-cluster_block_exception-Error-in-Magento-2.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2024\/08\/Solving-cluster_block_exception-Error-in-Magento-2.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/11829","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/users\/108"}],"replies":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/comments?post=11829"}],"version-history":[{"count":1,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/11829\/revisions"}],"predecessor-version":[{"id":11830,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/11829\/revisions\/11830"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/media\/11831"}],"wp:attachment":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/media?parent=11829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/categories?post=11829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/tags?post=11829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}