Announcement

Collapse
No announcement yet.

Which tables are necessary for fulltext vb search?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Which tables are necessary for fulltext vb search?

    I'm looking to replicate_db_table only the necessary tables for vbulletin fulltext searching, so that I can increase the speed of replication since the replication thread is only single threaded.

    I know at least post, thread, user....

    Which other tables are necessary?

    Thanks!

  • #2
    Hello,

    Thank you for contacting vBulletin Support.

    To my knowledge these are the two queries one has to change:

    ALTER TABLE vb_post ADD FULLTEXT INDEX (title,pagetext)
    ALTER TABLE vb_thread ADD FULLTEXT INDEX (title)

    Indicating these are the only two tables we use for FULLTEXT search.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X