Magento CE 2.2巨大的目录索引问题

Updated to Latest Magento 2.2.5

更新至最新的Magento 2.2.5

Index : catalogsearch_fulltext never completes.

索引:catalogsearch_fulltext永远不会完成。

Catalog Size:-

Store View: 10
Category: 33K 
Products: 300K

Following index take huge time (2+hr) to complete :

以下索引需要花费大量时间(2 + hr)才能完成:

catalog_product_category
catalog_product_attribute

and following index never completes

以下索引永远不会完成

catalogsearch_fulltext

Using Elastic Search from Mirasvit as well.

使用Mirasvit的弹性搜索。

Totak Mysql Database Size = ~30+GB

Totak Mysql数据库大小= ~30 + GB

still no results with index

仍然没有索引的结果

1 个解决方案

#1

This is happening because of multiple store view, is actually easy to manage; in Magento 2.2.5, indexers are scoped and multi-threaded to support reindexing in parallel mode. This feature reduces processing time. It parallelizes by the indexer’s dimension and executes across multiple threads. This means that you can catalogsearch_fulltext can be run in parallel mode: the following command runs the Catalog Search Fulltext indexer across three threads:

这是因为多个商店视图,实际上很容易管理;在Magento 2.2.5中,索引器具有作用域和多线程,以支持并行模式下的重建索引。此功能可缩短处理时间。它通过索引器的维度进行并行化,并在多个线程中执行。这意味着您可以在并行模式下运行catalogsearch_fulltext:以下命令跨三个线程运行Catalog Search Fulltext索引器:

MAGE_INDEXER_THREADS_COUNT=3 php -f bin/magento indexer:reindex catalogsearch_fulltext

MAGE_INDEXER_THREADS_COUNT = 3 php -f bin / magento indexer:reindex catalogsearch_fulltext

learn more https://devdocs.magento.com/guides/v2.2/config-guide/cli/config-cli-subcommands-index.html#view-indexer-status

了解更多https://devdocs.magento.com/guides/v2.2/config-guide/cli/config-cli-subcommands-index.html#view-indexer-status

#1