The Indexing tab

Last update: June 27, 2023

CREATED FOR:

  • Experienced
  • Admin
  • Developer

The Indexing tab attempts to explain issues with indexing and identify potential causes.

Core index invalidated

Core index invalidated

The Core index invalidated frame looks at indexing invalidation across a selected timeframe. If indexing is happening at the same time as other resource-intensive crons, it will place a heavy load on the site resources.

  • %Catalog Product Rule indexer has been invalidated%) as catalog_product_rule_idx_reset
  • %Catalog Rule Product indexer has been invalidated%) as catalog_rule_product_idx_reset
  • %Catalog Search indexer has been invalidated%) as catalog_search_idx_reset
  • %Category Products indexer has been invalidated%) as category_products_idx_reset
  • %Customer Grid indexer has been invalidated%) as customer_grid_idx_reset
  • %Design Config Grid indexer has been invalidated%) as design_config_grid_idx_
  • %Product Categories indexer has been invalidated%) as product_categories_idx_reset
  • %Product EAV indexer has been invalidated%) as product_eav_idx_reset
  • %Product Price indexer has been invalidated%) as product_price_idx_reset
  • %Stock indexer has been invalidated%) as stock_idx_reset
  • %Inventory indexer has been invalidated%) as inventory_idx_reset
  • %Inventory indexer has been invalidated%) as inventory_idx_reset
  • %Sales Rule indexer has been invalidated%) as sales_rule_idx_reset

Core index rebuilds

Core index rebuilds

The Core index rebuilds frame looks at core index rebuilds across a selected timeframe. Here are the strings that are parsed from the logs to indicate index rebuild completion.

  • %Catalog Product Rule index has been rebuilt%) as catalog_product_rule_idx
  • %Catalog Rule Product index has been rebuilt%) as catalog_rule_product_idx
  • %Catalog Search index has been rebuilt%) as catalog_search_idx
  • %Category Products index has been rebuilt successfully%) as category_products_idx
  • %Customer Grid index has been rebuilt%) as customer_grid_idx
  • %Design Config Grid index has been rebuilt%) as design_config_grid_idx
  • %Product Categories index has been rebuilt%) as product_categories_idx
  • %Product EAV index has been rebuilt%) as product_eav_idx
  • %Product Price index has been rebuilt%) as product_price_idx
  • %Stock index has been rebuilt%) as stock_idx
  • %Inventory index has been rebuilt successfully%) as inventory_idx
  • %Product/Target Rule index has been rebuilt successfully%) as prod_target_rule_idx
  • %Sales Rule index has been rebuilt successfully%) as sales_rule_idx

catalogsearch index table(s)

catalogsearch index table(s)

The catalogsearch index table(s) frame looks at catalogsearch index tables across a selected timeframe. This query is looking at the duration of any datastore operations against tables with %catalogsearch% in the table name.