List:General Discussion« Previous MessageNext Message »
From:Matt W Date:September 11 2003 3:00am
Subject:Re: FULLTEXT feature requests
View as plain text  
Hi Shane,

----- Original Message -----
From: "Shane Allen"
Sent: Wednesday, September 10, 2003 7:16 PM
Subject: FULLTEXT feature requests

> The only reason that we are unable to use a stock build of mysql is
> because
> 1) we use GWS_FREQ as our GWS_IN_USE, not GWS_PROB

Why is that exactly...? To get around the 50% threshold? Like the manual
says, "by doing this you *severely* decrease MySQL's ability to provide
adequate relevance values for the MATCH() function. If you really need
to search for such common words, it would be better to search using IN
BOOLEAN MODE instead, which does not observe the 50% threshold."

> 2) we have a custom stopword list

This is run-time configurable. :-) Look at the ft_stopword_file
variable. Every "word" in the file is used as a stopword. "Word" being
defined the same as the indexing parser uses.

> Is there any reason that these two settings, like FT_MIN_WORD_LENGTH,
> cannot be moved to runtime-configurable params? Obviously, changing
> either setting would require a rebuild of the FT index(es), but then,

I just wish ft_min_word_len would be 3 by *default*, so we wouldn't have
to change it. :-D


> --
> Shane Allen <shane@stripped>

FULLTEXT feature requestsShane Allen11 Sep
  • Re: FULLTEXT feature requestsMatt W11 Sep