Enable MySQL Fulltext search on 5.6 gig post table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • telc
    Senior Member
    • Oct 2001
    • 239
    • 3.5.x

    #16
    Originally posted by hichew
    Any suggestion to move from vB default search to Fulltext search on 5.6 gig post table?

    There's no way using admincp to do this task (browser will time out)

    Seems like I should do this using SSH meanwhile I turn off the forum.

    ALTER TABLE post ADD FULLTEXT INDEX (title,pagetext)
    ALTER TABLE thread ADD FULLTEXT INDEX (title)

    Then what's next?

    Did you notice any improvement in less server load after switching to fulltext?

    Comment

    • hichew
      Senior Member
      • Dec 2003
      • 158

      #17
      Originally posted by telc
      Did you notice any improvement in less server load after switching to fulltext?
      mm actually i didnt notice any changes after changing to fulltext search on speed.
      the db is now 11gb.

      Comment

      • cirdok2
        Senior Member
        • Aug 2004
        • 412
        • 3.6.x

        #18
        Originally posted by hichew
        mm actually i didnt notice any changes after changing to fulltext search on speed.
        the db is now 11gb.
        From 5.6 to 11Gb?

        Comment

        • hichew
          Senior Member
          • Dec 2003
          • 158

          #19
          yup it almost doubled the size of "post" table.
          but ppl are happy now..

          it took mysql 3 hours during the change to fulltext search

          Comment

          • cirdok2
            Senior Member
            • Aug 2004
            • 412
            • 3.6.x

            #20
            Originally posted by hichew
            yup it almost doubled the size of "post" table.
            but ppl are happy now..
            Thanks for the answer.

            Do you know why this happen? I didn't know the switch from vBulletin search to fulltext affected the post table.

            Comment

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