[JesterP]

Originally Posted by boggseric

I just set it up using the info in post 1 and the files from post 582

I used the info from this post to make sure it stayed running and this post to setup the crons for delta and nightly.

Other than that the only changes I made were from my previous post to fix the "find more posts by this user" issue.

It is now up and running on my 3.8.4pl2 forums with:
Threads: 799,861, Posts: 11,892,282, Members: 24,815

I set the max amount of of results to 20,000 and it's working great. Searches no longer take my forum to it's knees.

The things I haven't done yet are to remove the indexes from post and convert my tables to innodb.


Total cost? My time reading through this never ending thread and compiling the data above.

I wanted everyone to know boggseric's post is the way to go. Even though I read everything I could find about Sphinx, his post pulled it all together and I am now ready to convert to innodb FINALLY.

Thank you boggseric.

My setup:

Nginx for all web/PHP
Sphinx 0.9.9
vBulletin 3.8.3 80k members 740k posts

My only complaint so far is that it seems to take longer to go to a search result that's listed than clicking on anything else on the site. I'm wondering if the highlighting of the search terms the site does is causing the delay.

Thanks to everyone who contributed to this thread..... it's pure gold.

Jester