Bug #63718 Unable to increase ft_max_word_len variable
Submitted: 11 Dec 2011 18:45 Modified: 12 Dec 2011 4:59
Reporter: Andrew Hushbeck Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.1.41, 5.1.61 OS:Any
Assigned to: CPU Architecture:Any
Tags: fulltext, variable

[11 Dec 2011 18:45] Andrew Hushbeck
Description:
I am unable to increase the ft_max_word_len variable above the default 84 value. When I do, I get the following:

C:\>mysqld --ft_max_word_len=128
111210 23:55:46 [Warning] option 'ft_max_word_len': unsigned value 256 adjusted to 84
111210 23:55:46 [Warning] option 'ft_max_word_len': unsigned value 128 adjusted to 84

Also, when posted for assistance, at least one other user said that they are unable to as well, on a newer version (5.5.18) and a different OS (CentOS): http://serverfault.com/q/339859/91709

256 is the value that I tried to change it to in the GUI, 128 is the value I really need and was the value I tried to modify it to there. Value does not stick like it says there.

How to repeat:
1. Try to set the 'ft_max_word_len' variable to anything above 84
2. Restart
3. Query for variable. Note it is set to 84
[12 Dec 2011 4:59] Valeriy Kravchuk
Verified with 5.1.61 on Mac OS X also. 

As our manual, http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_ft_max_word_len, says nothing about this limit, 84, I'd say this is either a bug or valid documentation request.