The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Minimum Word Length

Discussion in 'General Discussion' started by wmiles, Oct 14, 2007.

  1. wmiles

    wmiles Member

    Joined:
    Sep 6, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Hi

    I've been asked by a customer is it is possible to implement the use of ft_min_word_len as 3 letters rather than 4.

    My questions are as follows

    1) Can this setting be used on a per domain basis rather than server wide?
    2) How to do it if it can be done per domain?
    3) If it's set server wide do you think its going to cause an issue to server load?

    Cheers in advance.
     
  2. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    It's a relatively simple adjustment to get the search to find 3 letter reults. This was posted on MySQL.com: http://www.mysql.com/doc/en/Fulltext_Restrictions.html

    You can set your ft_min_word_len by adding the following line into the [mysqld] section of your /etc/my.cnf:

    Code:
    set-variable=ft_min_word_len=X
    where X is the integer value you wish to use for your fulltext minimum word length.

    Note:
    You will also need to re-index affected tables for this to take effect."
     
  3. wmiles

    wmiles Member

    Joined:
    Sep 6, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    I found that information already

    I was more asking if in forum user opinion it would cause further load to the server and or whether it would be possible to allow this to one domain only.
     
Loading...

Share This Page