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;

2 Answers 2


Yes It safe to Truncate these tables

  • 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, 2017 at 12:13
  • @liyakat / Ashish Jagnani - this qualifies as an answer. Consult the meta section for more info.
    – SR_Magento
    Jan 5, 2017 at 12:59
  • IF this qualifies as an answer can you upvote it Jan 5, 2017 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, 2017 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, 2017 at 10:50

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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