Demo of the module: Partial Indexers Maintenance

Demo of the module: Partial Indexers Maintenance

https://www.sashas.org/partial-indexers-maintenance.html

The Partial Indexers Maintenance module helps to manage partial indexers.

Magento 2 has two index types:

Full reindex, which means rebuilding all the indexing-related database table
Partial reindex, which means rebuilding the database tables only for the things that changed (like changing a single product attribute or price)

The materialized view (Mview) reindex is used to track database changes for a certain entity and runs partial reindex only for the changed entities. The partial reindex is being called by CRON and it defines IDs to be re-indexed from the change log by last applied version id of the changed entity

In some cases, the partial reindex may be suspended due an error or have a large backlog of items to reindex. The out of the box Magento functionality requires to run a full re-index of an entity that may take several hours for large catalog and affect customers who visites website or require website to be in the maintenance mode during the reindex.

The module adds command line interface to run reindex only for entities from a change log instead of a full reindex. Also, there is option to suspend or resume partial reindex that has been suspended. In addition to that in cases when your store has customizations, there is a command that shows what modules/code classes use a specific materialized view

Видео Demo of the module: Partial Indexers Maintenance канала Alexander L