From Magento 1.9.2.3 multi-store to Magento 2.3.4 after successfully migrated settings and data to Magento 2.3.4 reindex error,
Error Screenshot: https://snipboard.io/cGWypo.jpg
Note: I am searching google still not getting a relevant solution.
System.log Error:
[2020-06-08 09:17:23] 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: 1000; Allocated memory size: 202500000 bytes; InnoDB buffer pool size: 134217728 bytes. [] []
My innodb_buffer_pool_size :
>etc/my.cnf
innodb_buffer_pool_size = 8048M
submitted by /u/aveeva7
[link] [comments]