Announcement

Collapse
No announcement yet.

Can't search for three-letter words?

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

  • #16
    Originally posted by Scott MacVicar View Post
    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


    • #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


      • #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


        • #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


          • #20
            Originally posted by Eagle Creek View Post
            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


            • #21
              Originally posted by Wayne Luke View Post
              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


              • #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 - Full / Mobile
                Vote for your favorite feature requests and the bugs you want to see fixed.

                Comment

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