Catalog Search Index refresh running slow or halting/freezing

You no longer need to follow the instructions below, you can use the new tool on Magento Connect instead. Please note. This article applies to Magento 1.4 and greater only. A lot of people are starting to find that with large catalogues that the new indexing manager in Magento 1.4 may be starting to time out when generating Catalog Search Index – Rebuild Catalog product fulltext search index. This usually results in a blank screen when refreshing indexes or a index timeout error This is largely due to a number of factors: the number of products in a catalogue the number of store views the apache/lighttpd timeout setting the php.ini maximum execution time & script input time an already inflated catalogsearch_fulltext MySQL table the lock file is still place from the previous time it ran preventing it running again To remedy this issue, you’ll need to know a few facts. … Continue reading