Magento – Magento catalogsearch_fulltext reindex

catalogsearchdatabaseindexingmagento-1.9MySQL

I am trying to renidex (through CLI) magento catalog but the routine is hangs (or executing very slow) on catalogsearch_fulltext. I am tried to wait more 8 hours, but it didn't finish. There are 18k SKUs in catalog. Magento installed on a DigitalOcean VPS which has a 4Gb of RAM. I am tried to make truncate catalogsearch_fulltext – but that didn't help.

UPDATE: I am using Magento 1.9

UPDATE 2: I am deleted French and German stores, an reindexing finally finished: "Catalog Search Index index was rebuilt successfully in 03:03:16" It really should work so long?

Best Answer

The problem with Magento CatalogSearch Fulltext, apart the whole indexation takes place on PHP side, that when you search on the frontend, related database tables are locked, that slow downs it dramatically. If you have a possibility to avoid standard fulltext search in Magento, you should do, as it is not developed for huge datasets.

There are different options available like Sphinx, Solr, ElasticSearch that you can implement with less effort and better search results.

Related Solutions

Magento – Understanding data_index Column in catalogsearch_fulltext Table

I investigated and dig into the code. Below is the brief of my findings

When we are creating the search indexes by performing catalog search re-indexation, Magento update the table catalogsearch_fulltext with the product id and data_index. data_index contains the values of all the searchable attributes of the product itself and the associated products like brand, name, etc but it contains the sku only of the product and not of the associated product.

So, when a user is searching with a particular text, then magento tries to match this text with the values present in the data_index. If it gets any matching text then it shows that particular product in the result set.

Example values of data_index : AB2180|AB2180 Polished/Brushed|AB2180 Polished Chrome|AB2180 Brushed Nickel|||||1 Brief of above values : AB2180 : product sku AB2180 Polished/Brushed : product name AB2180 Polished Chrome|AB2180 Brushed Nickel : associated product names

Below are the table and files that helped me to understand

Database Table : catalogsearch_fulltext

CodeFiles or classes :

 - Mage_CatalogSearch_Model_Resource_Fulltext
 - Mage_CatalogSearch_Model_Resource_Fulltext_Engine

Magento – Magento 2 catalog search full text reindex problem

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 ?

Best Answer

Related Solutions

Magento – Understanding data_index Column in catalogsearch_fulltext Table

Magento – Magento 2 catalog search full text reindex problem

Related Topic