Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 04 Oct 2010, 10:23
ivanp ivanp is offline
Join Date: Sep 2007
Sphinx search BETA for vBulletin 4.0 speed issue


We've installed Sphinx search BETA for vBulletin 4.0: took more than 12 hours for 15 million posts.

When started, it brought forum to its knees. The reason is 'thread' table locking because it is MyISAM type. So we changed sql_range_step from 10000000 to 128 to avoid table locking. still haven't finished after 16 hours, and it is supposed to run every 10 minutes

'thread' table is MyISAM because it has FULLTEXT index 'titles' used for similar threads generation. Is it safe to remove this index and convert it to InnoDB, if Sphinx search BETA for vBulletin 4.0 has this functionality built in?

Also I am worried about slow Sphinx indexing speed. Didn't have such problem using Orban's Sphinx implementation:

The complete indexing process took about 1 hour vs. 12 hours using the new one.

Please advise. Thanks.
Reply With Quote
Old 19 Nov 2010, 23:20
coffee's Avatar
coffee coffee is offline
Join Date: Oct 2002
Here is an update that may help (Reply No.4):
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 16:39.

Layout Options | Width: Wide Color: