I am working on Magento 2.3.2. When I run re-index command
php bin/magento i:rei Design Config Grid and Customer Config Grid is completed. But it is taking too much time to re-index Category Products and Product Categories
I checked the
SHOW PROCESSLIT; in my database and I am getting the following query which is running from a while.
INSERT INTO `catalog_category_product_index_store1
After a long time, it is displaying
INSERT INTO `catalog_category_product_index_store2
I tried to reset the indexer and again re-index only those two indexers. But the same thing happening.
I have 60k Products in my Magento Store.
It has suddenly happened from a few days in live only. In local, it is re-indexing everything. The issue is only in live. I have the same number of products in local.
Is it any permission issue to any folder like var or generated?
Please guide me on that. Thanks in advance.