Uploaded image for project: 'translate5'
  1. translate5
  2. TRANSLATE-2645

TermPortal: set mysql fulltext search minimum word length to 1 and disable stop words

    XMLWordPrintable

Details

    • Critical
    • Hide
      Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0.
      This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually.
      If this is the case, please call "./translate5.sh termportal:reindex" or contact us, how to do this.
      Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.
      Show
      Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please call "./translate5.sh termportal:reindex" or contact us, how to do this. Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.
    • Hide
      Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0.
      This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually.
      If this is the case, please call "./translate5.sh termportal:reindex" or contact us, how to do this.
      Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.
      Show
      Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please call "./translate5.sh termportal:reindex" or contact us, how to do this. Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.

    Description

      Regarding the fulltext index for the term attributes there are two todos:

      Disable the minimum word length

      The default for the minimum word length for mysql fulltext search is 3. Parameter ft_min_word_len.

      For TermPortal we need every word to be found, regardless of its length.

      Therefore this needs to be set to 1.

      Since this can only be done in mysql configuration, we need to change that on our server, add it to the installation instructions for translate5 and send it to the admins of self-hosted installations for information.

      disable stopword list

      Make research what is possible / what must be done (DB root rights / ordinary user etc) depending on that make an alter script or place instructions into the important release notes

      make a DB system requirements check

      which checks both above settings if applied

      Attachments

        Activity

          People

            tlauria Thomas Lauria
            marcmittag Marc Mittag [Administrator]
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: