QuestionQ39
VerifiedWorking with Databases and EAVWhile 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?
Community Discussion