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.
Please add the following thing into env.php and try it
'MAGE_INDEXER_THREADS_COUNT' => 3
FYI: We have 1.6 million products. Also sometimes MySql refuses the connection while indexing.