0

I have Magento 2.3.1 on digitalocean plesk panel

It shows error like bellow

[2019-04-22 11:36:49] 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: 130000000 bytes; InnoDB buffer pool size: 134217728 bytes. [] []

0

Looks like problem with Category Products index. In custom module in etc/di.xml decrease the number for batchRowsCount.

<type name="Magento\CatalogInventory\Model\Indexer\Stock\Action\Full">
    <arguments>
        <argument name="batchRowsCount" xsi:type="array">
            <item name="configurable" xsi:type="number">1000</item>
        </argument>
    </arguments>
</type>

More details here.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.