Dear fellows,
one of my 5.5 Drupal installations that has been upgraded from 4.7 last week turns out to be very slow on reindexing the built-in search engine index. This drupal instance has 1750 nodes to index and it takes roughly 2.5 hours, while the servers CPU is constantly at 100%, spent on the mysql process.
I already digged the archives and so forth and did the following:
- played with several settings of "objects to index".
- cleared the index several times.
- truncated/emtpied the search_* tables
- disabled related modules (fuzzy search)
Nothing improved the current situation. I have to confess that the search was already fragile with 4.7, thus forcing me to use the google-search module, which I dislike for various reasons. But in contrast to now, the search didn't work at all in 4.7 (claiming all nodes being indexed, but not yielding any search results at first, then not being able to index at all).
I am looking forward to learn more about this problem, so if there is anyone out there willing to help me here, I'd definetely appreciate this. The site is hosted on my dedicated FreeBSD server, running almost latest PHP, Apache 2.0, MySQL 5.0.45 with eaccelerator-0.9.5.2.
Cheers,
Stephan
