min word length with fulletext search

Hi,

I need to use the full text search feature on some reseller machine. Now I need to lower the value for the minimun string length in searches:

from the manual:

The minimum and maximum lengths of words to be indexed are defined by the ft_min_word_len and ft_max_word_len system variables. (See Section 5.2.3, ?System Variables?.) The default minimum value is four characters; the default maximum is version dependent. If you change either value, you must rebuild your FULLTEXT indexes. For example, if you want three-character words to be searchable, you can set the ft_min_word_len variable by putting the following lines in an option file:

[mysqld]
ft_min_word_len=3

what does they mean with "putting the following lines in an option file:"

where and how to place an option file?

[Join us @ facebook]

The option file is the my.cnf. As this is a reseller machine and you don't have root access, you can try to execute this query:

SET GLOBAL ft_min_word_len=3

Thanks,

will say I have to use this query before every search query?

no success...

Error

SQL query:

SET GLOBAL ft_min_word_len =3

MySQL said: Documentation
#1193 - Unknown system variable 'ft_min_word_len'

[Join us @ facebook]

The query I gave you is to set the variable, and yes - if it worked - you should use it whenever you start a connection.

Now this is not working because your host maybe has a lower version of mysql?

Now this is not working because your host maybe has a lower version of mysql?

no, I use mysql5

[Join us @ facebook]

I am not sure about this. Maybe only the root user has rights to play with these variables.

Have you contact your host?

I am not sure about this. Maybe only the root user has rights to play with these variables.

Have you contact your host?

yes I send them an email yesterday, I think they need to place an option file for one of my db users or I need to take a VPS (is a VPS good for fulltext searches in a table with 1.5mio records?)

[Join us @ facebook]

No VPS wont be good for that

No VPS wont be good for that

I need a server with more memory right?

[Join us @ facebook]

I think full text search requires both memory and processing capabilities.

Of course you can use some way to cache results and this will help you use less resources.

[Guest]

[62.885]

Googlebot, facebooklog22