I have just installed Magento 2 a few days ago.
And suddenly when I try to reindex manually I noticed that the
Category Products indexer takes much time. more than 8 mins
And I've got this exception in
Sentry about 2k time
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: 2160000000 bytes; InnoDB buffer pool size: 2281701376 bytes.
from the exception above: I've updated the buffer pool size to max value allowed but the problem didn't solve.
- I don't have so many products, It's just dummy data.
- I've updated to Magento 2.3.2 today but the problem still exists.
- I don't have this issue on my localhost domain.