Clarify explicitly why "EAV indexer" should be enabled/disabled when different search engines are used

Open ilnytskyi opened this issue 5 years ago • 4 comments

Topic clarification/correction request

When trying to get information why we should use ES search or Mysql search there is no exact explanation how EAV indexer affects those scopes

Topic Link

https://devdocs.magento.com/guides/v2.3/config-guide/elasticsearch/configure-magento.html https://devdocs.magento.com/guides/v2.3/extension-dev-guide/indexer-batch.html

Description

Not that much info is clear on this page about EAV indexer https://devdocs.magento.com/guides/v2.3/config-guide/elasticsearch/configure-magento.html

A bit more info available here https://devdocs.magento.com/guides/v2.3/extension-dev-guide/indexer-batch.html But the pages are not linked. Then It is not clear how EAV indexer behaves and inceracts with Mysql search and ES, it is not clear where the catalog_product_index_eav table used.

e.g.

As of Magento 2.3, under certain circumstances, you can disable this indexer to improve performance. (Its indexation takes about 5 minutes on a large Magento 2 Commerce performance profile.)