4

I have a problem with SEARCHING in a Magento store. When I reindexing catalogsearch_fulltext, proccess is not completed I'm waiting more than 2 days and not result. The search not working correctly - don't return results.

I cheched the folowing tables in mysql

catalogsearch_query - ~3 000 000 records

catalogsearch_fulltext - ~300 000 records

catalogsearch_result - ~127 000 000 records

Is it safe to clear them?

TRUNCATE catalogsearch_query;
TRUNCATE catalogsearch_fulltext;
TRUNCATE catalogsearch_result;
Improve this question
2

Yes It safe to Truncate these tables

Improve this answer
6
  • 1
    This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review – liyakat Jan 5 '17 at 12:13
  • @liyakat / Ashish Jagnani - this qualifies as an answer. Consult the meta section for more info. – SR_Magento Jan 5 '17 at 12:59
  • IF this qualifies as an answer can you upvote it – B Karthik Kumar Jan 5 '17 at 13:14
  • @SR_Magento, in answer should be some descriptive not only just like comment, if you agree you can just make coment or add some description why it is safe – liyakat Jan 6 '17 at 3:55
  • @BKarthikKumar You do not up vote answers you don't think merit, actually its more appropriate for you to down vote if you don't like it. – SR_Magento Jan 6 '17 at 10:50
8

It's safe to truncate it but if you had previously created synonyms or redirects you will loose them. Use

 DELETE FROM  `catalogsearch_query` WHERE  `synonym_for` IS NULL AND  `redirect` IS NULL`

and this will only delete rows that don't have a value in them for synonym or redirect

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.