cataloginventory_stock index is running very slow. How to optimize?

[nileshsear2de6]

Hello,

I have magento 2.3.4 and having 16,00,000 products 1 store 1 website. 

cataloginventory_stock index taking more than a day still it is running.

Please do the needful on this so we can reduce the hours to be taken by cataloginventory_stock indexer.

[amitsamsukha]

@nileshsear2de6 ,

kindly plan to upgrade Magento 2.4.1 with elastic search and PHP 7.4 

indexing is really very fast in M2.4
also, try increasing memory in reindexing via 

php -d memory_limit=2048M bin/magento 

kindly Accept as a Solution if this works for you and give Kudos  

[nileshsear2de6]

Is it possible without upgrading.

[amitsamsukha]

@nileshsear2de6 ,

YES, you can setup elastic search with Magento Version2.3.4 

also check your memory with PHP CLI 

to update memory_limit in CLI you can pass that as an argument as shown below 

php -d memory_limit=2048M bin/magento 

[lulacox1972e27]

You need reset index status and then try to run a new re-index process.