MySQL Forums
Forum List  »  Install & Repo

The value of ft_max_word_len
Posted by: T. L.
Date: May 25, 2010 08:33AM

Hi, we have a problem to increase the database start up variable ft_max_word_len in configuration file my.cnf.

The default value is 84, if we decrease it then after restart "show variables" it show the new value. But if we try to increase its value over 84 (eg. 141), then after restart we see the default value of 84. Why we cant increase it?

System configuration:
------
MySQL server 5.0.41
Linux 2.6.x

my.cnf:
------
user=mysql
datadir=/data/mysql
tmpdir=/tmp
skip-name-resolve

max_connections = 500
max_user_connections=250
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 5M
read_buffer_size = 3M
sort_buffer_size = 5M
table_cache = 1500
thread_cache_size = 128
wait_timeout = 14400
connect_timeout = 400
max_allowed_packet = 16M
max_connect_errors = 1000
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb
thread_concurrency=4

ft_min_word_len=3
ft_max_word_len=141

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M

Options: ReplyQuote


Subject
Written By
Posted
The value of ft_max_word_len
May 25, 2010 08:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.