The Indexing tab
The Indexing tab attempts to explain issues with indexing and identify potential causes.
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%) ascatalog_product_rule_idx_reset%Catalog Rule Product indexer has been invalidated%) ascatalog_rule_product_idx_reset%Catalog Search indexer has been invalidated%) ascatalog_search_idx_reset%Category Products indexer has been invalidated%) ascategory_products_idx_reset%Customer Grid indexer has been invalidated%) ascustomer_grid_idx_reset%Design Config Grid indexer has been invalidated%) asdesign_config_grid_idx_%Product Categories indexer has been invalidated%) asproduct_categories_idx_reset%Product EAV indexer has been invalidated%) asproduct_eav_idx_reset%Product Price indexer has been invalidated%) asproduct_price_idx_reset%Stock indexer has been invalidated%) asstock_idx_reset%Inventory indexer has been invalidated%) asinventory_idx_reset%Inventory indexer has been invalidated%) asinventory_idx_reset%Sales Rule indexer has been invalidated%) assales_rule_idx_reset
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%) ascatalog_product_rule_idx%Catalog Rule Product index has been rebuilt%) ascatalog_rule_product_idx%Catalog Search index has been rebuilt%) ascatalog_search_idx%Category Products index has been rebuilt successfully%) ascategory_products_idx%Customer Grid index has been rebuilt%) ascustomer_grid_idx%Design Config Grid index has been rebuilt%) asdesign_config_grid_idx%Product Categories index has been rebuilt%) asproduct_categories_idx%Product EAV index has been rebuilt%) asproduct_eav_idx%Product Price index has been rebuilt%) asproduct_price_idx%Stock index has been rebuilt%) asstock_idx%Inventory index has been rebuilt successfully%) asinventory_idx%Product/Target Rule index has been rebuilt successfully%) asprod_target_rule_idx%Sales Rule index has been rebuilt successfully%) assales_rule_idx
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.
product index table(s)
The product index table(s) frame looks at product index tables across a selected timeframe. This query is looking at the duration of any datastore operations against tables with %product% in the table name.