This is for those who are running larger sites (2-3+ million posts)...

What are you doing for search? Mine has been broken for a couple of years and I just can't seem to find a solution that works well enough to be useful. I'm interested in what you are using and what you have tried.

Right now I'm running MySQL with INNODB for my main server and replicating to a slave which I use for search. By doing this I can run two copies of the posts table (INNO on the master, MyISAM on the slave). I'm using FULLTEXT off the slave but it's just not working and I had to shut searching off entirely.

Most searches using FULLTEXT on the slave are taking in excess of 1000 seconds. Some take as long as 20 minutes. I've tried manual indexing but maintaining the keyword index is a nightmare, ht://dig back in the day, mnoGo but users complain about the output format and I have what I'm doing now. Short of spending 50 large for a Google appliance is there some other option I haven't looked at.

I've considered maintaining a separate posts table just for the posts I want to index but I'm back to doing index maintenance and there is no way to know when a post is fresh or not except the post date and last edit time (no way to know if it's been moved, deleted, trashed, etc) without rescanning the entire posts table and checking each posts (that I know of).

Any help would be appreciated.

bump...

use a php caching engine