Forum Moderators: open

Message Too Old, No Replies

Not mysql variables?

         

matthewamzn

4:43 pm on Jan 19, 2006 (gmt 0)

10+ Year Member



I recently setup a new server. I tried to change the mysql fulltext functions, by altering the my.cnf file.

However my server administrator said that these weren't mysql variables:
ft_min_word_len=1
ft_stopword_file = /etc/noisewords.txt

The altered my.cnf file looked like this:

[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
ft_min_word_len=1
ft_stopword_file = /etc/noisewords.txt

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[myisamchk]
ft_min_word_len=1
ft_stopword_file = /etc/noisewords.txt

coopster

7:47 pm on Jan 19, 2006 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



It's probably the version you are running. The minimum and maximum length of words to be indexed is defined by the
ft_min_word_len
and
ft_max_word_len
system variables which are available as of MySQL 4.0.0.
ft_stopword_file
was added in MySQL 4.0.10.

matthewamzn

9:07 pm on Jan 19, 2006 (gmt 0)

10+ Year Member



Is there anyway to set the min max keyword length, and stopwords with mysql 3.23.58. I now it has fulltext search capabilities. I'm running Plesk CP, which isn't compatible with Mysql 4.

coopster

3:22 pm on Jan 20, 2006 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



I've never attempted it myself. I do not know if it is even possible at that release level. The best I can offer at this point is the manual pages ...

[dev.mysql.com...]