Magento 2.4.5-p1
Smartwave Porto theme
I have found the following Error in my logs:
main.WARNING: Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 100000; Allocated memory size: 1300000000 bytes; InnoDB buffer pool size: 2147483648 bytes.
I googled it and found the following article:
Magento 2 Please update innodb_buffer_pool_size or decrease batch size value
It suggests to update default Batching configuration of catalog_category_product (Category Products) indexer because “Current batch size: 100000” and points to this article here:
https://developer.adobe.com/commerce/php/development/components/indexing/optimization/
I’ve raised this with our hosting and they responded with:
On the server end we can increase the ‘innodb_buffer_pool_size’ value, as per the update of Batching configuration of catalog_category_product, it requires tweaking of the Magento 2 coding, which is a matter that falls outside our scope of expertise.
Currently, ‘innodb_buffer_pool_size’ is set to 2 GB, upon your request, we can increase it to 4 GB or 8 GB.
I am honestly lost. What do I need to do?
