Magento – Magento 2 catalog search full text reindex problem

catalogsearchindexingmagento2

I'm facing strange issue in my website. The products are not getting appeared if I reindex only flat and product related reindex. It requires catalogsearch_fulltext reindex. If I dont do catalog search full text reindex products are not getting appeared in frontend.

I'm having 3 stores in my website. So it takes almost 8 hours per store to complete the full text reindex. So to bring one product in my website I have to wait for 24 hours.

How can I resolve this issue? How to bring the product without reindexing catalog search fulltext?

FYI: I'm using elastic search, Magento EE v2.1.7

Best Answer

You can set the cron to update on Schedule.

This way, thanks to the mview pattern, Magento will reindex only the entity_ids which need to be reindexed. (check mview_state and catalogsearch_fulltext_cl tables)

You need to think about incremental update and not full update.

I have the same problem with my customer. It takes 8 minutes to full reindex by stores, I have 31 stores so ...

I am trying to reindex each store in parallel.

Did you find another solution ?

Related Solutions

Magento – Magento Search: Fulltext & Combine (Like and Fulltext) in relation to Relevance

The basic answer is "Magento search doesn't work well in either mode, get another search engine system." I have done all the above except truncating the query and result tables. If you want to waste a lot of time like I wasted a lot of time trying to make a minimal function search system work, feel free to pursue anything you want, but Sisyphus didn't have much return on effort either.

Modules are available for Sphynx, Lucene, Solr. In this instance, Free is lost sales so go for one that implements one of the above and doesn't try to patch the stock Magento search.

Anything 3rd party will give you 80% relevance or better and actually let you sort by relevance.

Stock Magento is in the 20-40% range for return results and that's as good as it gets. Also the random return is based on product order, not relevance order for LIKE so 500 returns probably means the relevant ones are 2/3 the way through.

When I tried it, the Mysql "Fulltext" never added any actual relevance (separate from relevance rating) to the search and defaults to not searching for words that are shorter than 4 characters (no stop-word functions, we'll just ignore everything so that actual 3 character part name NEVER is found).

Magento 2 Product Cache – Fix Index Error Cluster Block Exception

some possible solutions:

ElasticSearch default configuration will not allocate any more disk space when more than 90% of the disk are used overall, it might locked it to read-only mode.

To unlock writes to your cluster (all indexes) using below command (change to your elastic ip address and ports)

curl -XPUT -H "Content-Type: application/json" http://localhost:9200/_all/_settings -d '{"index.blocks.read_only_allow_delete": null}'

if you use other 3rd party search extension such as amasty elastic search etc. use below command to reindex

php bin/magento indexer:reset
php bin/magneto indexer:reindex
php bin/magento indexer:reindex amasty_elastic_relevance_rule_rule amasty_elastic_relevance_rule_product amasty_elastic_popup_data amasty_xsearch_category_fulltext
php bin/magento c:c
php bin/magento c:f

you can find the list of indexes added by the 3rd party extension using below:

    php bin/magento indexer:info

This will give the list of indexes status:

php bin/magento indexer:status

Best Answer

Related Solutions

Magento – Magento Search: Fulltext & Combine (Like and Fulltext) in relation to Relevance

Magento 2 Product Cache – Fix Index Error Cluster Block Exception

Related Topic