Magento 2 Product EAV indexing takes longer time

[radiantweb]

Hello there,

I have a problem for Product EAV indexing that takes approx. 12 to 15 hours to complete. Is there any solutions to fix this indexing in at least 2-3 hours ? I am using Magento 2.3.4. I have migrated from magento 1.9.x.

[Sunil Patel]

Hello,

Please add the following thing into env.php and try it

'MAGE_INDEXER_THREADS_COUNT' => 3

[radiantweb]

FYI: We have 1.6 million products. Also sometimes MySql refuses the connection while indexing.