QuestionQ39

VerifiedWorking with Databases and EAV

While investigating indexer issues, an Adobe Commerce developer sees log errors similar to Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. The client is advised to update innodb_buffer_pool_size or reduce the batch-size value.

Why does reducing the batch-size value improve performance?

Explanation

Reducing the indexer batch size lowers the number of entities processed in each iteration, so the temporary table for that iteration requires less memory. Adobe Commerce documents batch indexing as processing a portion of data on each iteration and supports tuning batch sizes to improve indexer performance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!