Magento2 Memory size allocated for the temporary table is more than

Posted by

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: 80000000 bytes; InnoDB buffer pool size: 134217728 bytes

参考:https://magento.stackexchange.com/questions/207457/magento-2-please-update-innodb-buffer-pool-size-or-decrease-batch-size-value