Reindexing — Full, Partial, and Performance

Full Reindex Command

# Reindex all indexers
php bin/magento indexer:reindex

# Reindex specific indexer
php bin/magento indexer:reindex catalog_product_price

# Reindex specific product
php bin/magento indexer:reindex catalog_product_price 123

What Full Reindex Does

1. Clears all index data
2. Rebuilds from source tables
3. Updates flat tables / search index
4. Marks indexer as 'valid'

Full Reindex Performance

# Time full reindex
time php bin/magento indexer:reindex

# With verbose output
php bin/magento indexer:reindex -vvv

Full Reindex for Large Catalogs

# For very large catalogs, run indexer-specific
php bin/magento indexer:reindex catalog_product_flat
php bin/magento indexer:reindex catalog_category_product
php bin/magento indexer:reindex catalog_product_price
php bin/magento indexer:reindex catalogsearch_fulltext

When to Full Reindex

• After theme/layout changes
• After attribute changes
• After data migration
• After module install/uninstall
• When index is corrupted

Reindex by IDs

# Reindex specific products
php bin/magento indexer:reindex catalog_product_price 101 102 103

Programmatic Partial Reindex

namespace Vendor\Module\Service;

use Magento\Framework\Indexer\IndexerRegistry;

class IndexService
{
    public function __construct(
        private IndexerRegistry $indexerRegistry
    ) {}

    public function reindexProduct(int $productId): void
    {
        $indexer = $this->indexerRegistry->get('catalog_product_price');
        $indexer->reindexRow($productId);
    }

    public function reindexProducts(array $productIds): void
    {
        $indexer = $this->indexerRegistry->get('catalog_product_price');
        $indexer->reindexList($productIds);
    }
}

Changelog-Based Reindex

Scheduled mode tracks changes in changelog tables:

-- Check pending changes
SELECT * FROM catalog_product_price_cl
ORDER BY updated_at DESC;

-- Process changelog
php bin/magento cron:run --group index

Batch Reindex

// Batch reindex for performance
$batchSize = 500;
$chunks = array_chunk($productIds, $batchSize);

foreach ($chunks as $chunk) {
    $indexer->reindexList($chunk);
}

Performance Metrics

-- Reindex duration
SELECT
    indexer_id,
    updated_at,
    TIMESTAMPDIFF(SECOND, LAG(updated_at) OVER (ORDER BY updated_at), updated_at) as duration
FROM indexer_state
WHERE indexer_id = 'catalog_product_price';

Optimization Techniques

# Increase PHP memory for reindex
php -d memory_limit=2G bin/magento indexer:reindex

# Run reindex with production mode
php bin/magento deploy:mode:set production

# Disable unnecessary modules during reindex
php bin/magento module:disable Vendor_Module

Parallel Reindexing

# Run multiple indexers in parallel
php bin/magento indexer:reindex catalog_product_flat &
php bin/magento indexer:reindex catalog_category_product &
php bin/magento indexer:reindex catalog_product_price &
wait

Database Optimization

-- Optimize tables before reindex
OPTIMIZE TABLE catalog_product_entity;
OPTIMIZE TABLE catalog_product_entity_int;

-- Increase innodb_buffer_pool_size
SET GLOBAL innodb_buffer_pool_size = 2147483648;

Common Reindex Issues

Debug Commands

# Check indexer status
php bin/magento indexer:status

# Check detailed info
php bin/magento indexer:info catalog_product_price

# Reset stuck indexer
php bin/magento indexer:reset catalog_product_price

# Force reindex
php bin/magento indexer:reindex catalog_product_price -f

SQL Debugging

-- Check index validity
SELECT * FROM indexer_state WHERE status != 'valid';

-- Check changelog size
SELECT
    TABLE_NAME,
    TABLE_ROWS,
    DATA_LENGTH
FROM information_schema.TABLES
WHERE TABLE_NAME LIKE '%_cl';

-- Monitor reindex progress
SHOW PROCESSLIST;

Log Analysis

# Check reindex logs
grep -i reindex var/log/system.log

# Check for errors
grep -i error var/log/exception.log | grep -i index

Production Checklist

# Before reindex
1. php bin/magento maintenance:enable
2. Backup database

# Reindex
3. php bin/magento indexer:reindex

# After reindex
4. php bin/magento cache:clean
5. php bin/magento maintenance:disable