Magento 2 Please update innodb_buffer_pool_size or decrease batch size value
Magento can increase the memory for processing a large amount of data by using memory engines instead of InnoDB. The algorithm increases the memory value for the max_heap_table_size and tmp_table_size MySQL parameters.
When the allocated memory size for a temporary table will be greater than 20% of innodb_buffer_pool_size, the error message is written to the Magento log.
To prevent this error message, you need to update default Batching configuration of catalog_category_product (Category Products) indexer because "Current batch size: 100000".
For more details, take a look here.
- Go to your server
MySQL settings file (my.ini)
- Search for
innodb_buffer_pool_size
and increase this value.