min word length with fulletext search

[Free WordPress Themes]

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

[Free WordPress Themes]

Thanks,

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

[Free WordPress Themes]

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?

[Free WordPress Themes]

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?

[Free WordPress Themes]

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

[Free WordPress Themes]

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]

[37.987]

Yahoo crawler, Googlebot, Baidu Spider, Gigabot, Msnbot