Announcement

Collapse
No announcement yet.

Chaning from vBulletin search engine to MySQL Fulltext search

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

  • Chaning from vBulletin search engine to MySQL Fulltext search

    Hi

    I am running a forum with vbulletin 3.5.1

    106,632 members

    943,659 posts

    94,199 Threads


    Today I tried to convert from vBulletin search engine to MySQL Fulltext search using the admincp but I always got page timeout..

    So I decided to move to ssh and run the queries manually...

    I ran this first and took 2.2 minutes with no errors
    ALTER TABLE thread ADD FULLTEXT INDEX (title)


    Then I ran this query
    ALTER TABLE post ADD FULLTEXT INDEX (title,pagetext)

    This query was running for 1 hour and the server load was so high reached up to 35 % until I got my site suspended ....

    now my site is back I was wondering

    1-How can I find out where did the query reach so I don't have to start all over again and kill the server.

    Note : post tables has the two new fields pagetext and title filled all with data from postid 3 to post id 1029336.

    2- Is there a way to get back to vBulletin search and remove all the new changes knowing that I still have the postindex table ...

    I appreciate ur time and effort to solve my problem.




  • #2
    I responded here:

    http://www.vbulletin.com/forum/showt...29#post1035529
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

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