Hi!
On Mar 01, Steve Rapaport wrote:
> I need to change the variable ft_min_word_len, in mysql 4.0.1
>
> The manual doesn't say how:
>
> Here's the closest it comes:
>
> SHOW VARIABLES shows the values of some MySQL system variables. You can also
> get this information using the mysqladmin variables command. If the default
> values are unsuitable, you can set most of these variables using command-line
> options when mysqld starts up.
> See section 4.1.1 mysqld Command-line Options.
>
> (Apparently not this one, it's not mentioned in the link.)
Really ?
`-O, --set-variable var=option'
Give a variable a value. `--help' lists variables. You can find a
full description for all variables in the `SHOW VARIABLES' section
in this manual. *Note SHOW VARIABLES::.
> later in the page...
>
> ft_min_word_len The minimum length of the word to be included in a FULLTEXT
> index. Note: FULLTEXT index have to be rebuilt after changing this variable.
>
> Again no mention of how it can be changed.
>
> Anyone know? I hope I don't have to rebuild the dist...
No, you don't :)
ft_min_word_len is normal mysqld variable, and can be set in mysqld
command-line or in /etc/my.cnf (~/.my.cnf).
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
