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;