Sphinx Search

[Mickie D]

Originally Posted by ChopSuey

Add to the lower versions? They have wayy better things to do.

That's a silly post, allot of people still use vbulletin 6, 7, 8, 9, etc.

I have 2 million posts and 70,000 members and do not want to upgrade to vb4 for many reasons but server load is the biggest factor.

Anyway I have it working now so no one has to worry about looking after customers that use a earlier version of VB

Mickie

[kmike]

ChopSuey, they already have a working (in production) 3.7 version, as could be seen on most of the IB auto sites. They have decided not to release it - probably to not add it to the number of reasons because of which people stay on vB 3.x.

[kontrabass]

Is anyone using VB4 with VB's Sphinx plugin successfully?

*chirp chirp chirp*

[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

[mute]

Has anyone noticed issues with "Find all posts by user" not showing all of a users recent posts? I'm not certain what's causing it, but even when my delta indexes are up to date, I'm having difficulty finding all of a users current posts. I'm not sure if it has something to do with posts being deleted or what, but it seems like it's sort of wonky.

[hqarrse]

For Vbulletin 4 I suggest using DigitalPoint's sphinx mod. This is the link although you will need to join as a premium member at $25 for a month.

http://articles.digitalpoint.com/con...in-4&nocache=1

It's early days but this has been simple to install and is working well on a forum of just over 3,000,000 posts. I'm still on a development version as I'm moving from a different CMS, but will post if I have any problems once I go live.

[saf-t scissors]

I got this running with boggseric's summary last night.

I'd like to point out this old Orban post, which I found helpful. It's a little out of date, so don't follow the instructions word for word. But it fills in some helpful background information like creating the counter tables.

It's also worth mentioning that I did have to make a few changes to the cron files to get them working properly. It's not a big deal, but helpful to know for those that aren't familiar with shell scripts and would like to plug and play. I'll post my files with comments after I get them cleaned up.

[Alfa1]

It would be great to see step by step instructions for vb 3.8.
Orbans post is for vb 3.6
Is anybody willing to write this?

[JesterP]

Originally Posted by Alfa1

It would be great to see step by step instructions for vb 3.8.
Orbans post is for vb 3.6

Didn't matter for me.

[boggseric]

Originally Posted by Alfa1

It would be great to see step by step instructions for vb 3.8.
Orbans post is for vb 3.6
Is anybody willing to write this?

https://vborg.vbsupport.ru/showpost....&postcount=776