Can't search for three-letter words?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jasonlitka
    Senior Member
    • Mar 2006
    • 1489
    • 4.0.x

    #16
    Originally posted by Scott MacVicar
    I'll be doing it in when we have our upgrade to Apache 2.2.4 scheduled, but we got plenty of errors about the index file being corrupted and every single one of them was a table containing a full text index.

    I'll do the changes when we have time, not before. Searching for 3 letter words isn't something that justifies downtime.
    I never said it was. I was just tossing out a few ideas on how you could minimize the downtime.

    EDIT: Wait, where do you see that httpd 2.2.4 was released?
    Jason Litka - Utter Ramblings

    Comment

    • Scott MacVicar
      Former vBulletin Developer
      • Dec 2000
      • 13286

      #17
      2.2.4 is being rolled for approval on the httpd-dev list, we're looking forward to it to fix a few bugs with mod_proxy.

      I tried last night with the indexes while fixing another table, we ended up with.

      Error 'Incorrect key file for table './vbulletin_forum/post.MYI'; try to repair it' on query. Default database: 'vbulletin_forum'. Query: 'INSERT INTO post <snip>', Error_code: 126
      Scott MacVicar

      My Blog | Twitter

      Comment

      • jasonlitka
        Senior Member
        • Mar 2006
        • 1489
        • 4.0.x

        #18
        I can honestly say that I've never had that problem when rebuilding an FT index. Since I switched to the FT search I've moved from a range of 4-10 to 3-12 and now to 3-15 and didn't have a problem on any of those.

        What command are you using to rebuild the indexes?
        Jason Litka - Utter Ramblings

        Comment

        • Eagle Creek
          Senior Member
          • Apr 2003
          • 1206
          • 3.6.x

          #19
          Just wondering: why is a server restart needed?
          http://www.nucia.nl/forum/
          The best way to kill malware; is to kill it together.

          Comment

          • jasonlitka
            Senior Member
            • Mar 2006
            • 1489
            • 4.0.x

            #20
            Originally posted by Eagle Creek
            Just wondering: why is a server restart needed?
            It's not. If you're referring to my post then I meant "MySQL Daemons", not "MySQL servers"
            Jason Litka - Utter Ramblings

            Comment

            • Eagle Creek
              Senior Member
              • Apr 2003
              • 1206
              • 3.6.x

              #21
              Originally posted by Wayne Luke
              There really aren't that many 3-letter words to search for and get meaningful results. The cost of reconfiguring all our servers, restarting them and rebuilding all the indexes plus the overhead with continual use aren't justified.
              That's what I mean .
              http://www.nucia.nl/forum/
              The best way to kill malware; is to kill it together.

              Comment

              • Wayne Luke
                vBulletin Technical Support Lead
                • Aug 2000
                • 73981

                #22
                MySQL is server software... It doesn't necessarily refer to the actual machines or computers.
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud demonstration site.
                vBulletin 5 API

                Comment

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