> [!INFO]
> **Website**: [The S Group](https://www.sashas.org/)
> **Breadcrumbs**: [Home](https://www.sashas.org/) > [Management](https://www.sashas.org/site-management.html) > [Catalog](https://www.sashas.org/site-management/catalog.html) > [Partial Indexers Maintenance](https://www.sashas.org/partial-indexers-maintenance.html)

# Partial Indexers Maintenance

![Partial Indexers Maintenance](https://www.sashas.org/media/catalog/product/cache/74c1057f7991b4edb2bc7bdaa94de933/l/o/logo-site.png)

**Rating**: ★★★★★ (5.0/5 from 0 reviews)

**Price**: $20.00 USD | **Availability**: In Stock | **SKU**: `module-mview-reindex`

> The Partial Indexers Maintenance module in Magento 2 manages partial indexers, which are used to rebuild database tables for changed entities. It offers a command-line interface to run a reindex only for entities from a change log and suspend or resume a partial reindex. Additionally, it provides information on which modules/code classes use a specific materialized view, making it useful for stores with customizations.

## Overview

The Partial Indexers Maintenance module helps to manage partial indexers.

Magento 2 has two types of indexes:

- Full reindex, which means rebuilding all the indexing-related database tables.

- Partial reindex, which means rebuilding the database tables only for the things that have changed (such as changing a single product attribute or price).

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

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

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

### Commands

- tsg:mview:reindex - Reindex a partial index.

- tsg:mview:suspend - Suspend a partial index.

- tsg:mview:reset - Reset a partial index to the idle state.

- tsg:mview:resume - Resume a previously suspended partial index.

- tsg:mview:subscriptions - View subscriptions for a partial index.

## Specifications

| Feature | Details |
| :--- | :--- |
| **Product Name** | Partial Indexers Maintenance |
| **SKU** | `module-mview-reindex` |
| **Price** | $20.00 USD |
| **Magento Compatibility** | 2.4.x |
| **License** | GNU General Public License v3.0 (GPL-3.0) |
| **Stock Status** | In Stock |

## Customer Reviews

*There are currently no reviews for this product.*

## Related Products

| Product | SKU | Price | Link |
| :--- | :--- | :--- | :--- |
| **404 Not Found Error Log** | `m2-error-log` | $20.00 | [View Product](https://www.sashas.org/404-not-found-error-log.html) |
| **Product Alert Grid** | `module-product-alert-grid` | $20.00 | [View Product](https://www.sashas.org/product-alert-grid.html) |
| **Shipping Origin** | `module-shipping-origin` | $25.00 | [View Product](https://www.sashas.org/shipping-origin.html) |
| **Call For Price** | `CallForprice-Magento2` | $20.00 | [View Product](https://www.sashas.org/call-for-price-magento-2.html) |
| **Customer Two Factor Authentication** | `Two Factor Authentication for Customers` | $20.00 | [View Product](https://www.sashas.org/two-factor-authentication-for-customers.html) |



## Navigation & Categories
- [Experience](https://www.sashas.org/customer-experience.html)
  - [Catalog Enhancements](https://www.sashas.org/customer-experience/catalog-enhancements.html)
  - [Cart & Checkout](https://www.sashas.org/customer-experience/cart-checkout.html)
  - [Customers](https://www.sashas.org/customer-experience/customers.html)
  - [Shipping](https://www.sashas.org/customer-experience/shipping.html)
  - [Payments](https://www.sashas.org/customer-experience/payments.html)
- [Management](https://www.sashas.org/site-management.html)
  - [Sales & Fulfillment](https://www.sashas.org/site-management/sales-fulfillment.html)
  - [Catalog](https://www.sashas.org/site-management/catalog.html)
  - [Customer Support](https://www.sashas.org/site-management/customer-support.html)
  - [Marketing & Promotions](https://www.sashas.org/site-management/marketing-promotions.html)
  - [Content Management](https://www.sashas.org/site-management/content-management.html)
  - [Reporting & Analytics](https://www.sashas.org/site-management/reporting-analytics.html)
- [Optimization](https://www.sashas.org/optimization.html)
  - [Performance](https://www.sashas.org/optimization/performance.html)
  - [Monitoring](https://www.sashas.org/optimization/monitoring.html)
  - [Troubleshooting & Debugging](https://www.sashas.org/optimization/troubleshooting-debugging.html)
- [Blog](https://www.sashas.org/blog)
- [About Us](https://www.sashas.org/about-us.html)
- [Contact Us](https://www.sashas.org/contact.html)
- [Privacy Policy](https://www.sashas.org/privacy-and-refund-policy.html)
- [Refund Policy](https://www.sashas.org/refund-policy.html)