Bug #18859 Can't set full text system variables with the SET statement;
Submitted: 6 Apr 2006 17:35 Modified: 6 Apr 2006 18:36
Reporter: Rick Meier Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.19-nt OS:Microsoft Windows (win32 XP Professional)
Assigned to: CPU Architecture:Any

[6 Apr 2006 17:35] Rick Meier
Description:
I can't set the ft_min_word_len system varaible.

How to repeat:
mysql> set ft_min_word_len = 1;
ERROR 1193 (HY000): Unknown system variable 'ft_min_word_len'

Also tried:
mysql> set @@ft_min_word_len = 1;
ERROR 1193 (HY000): Unknown system variable 'ft_min_word_len'
mysql> set @@ft_min_word_len=1;
ERROR 1193 (HY000): Unknown system variable 'ft_min_word_len'
mysql> set ft_min_word_len=1;
ERROR 1193 (HY000): Unknown system variable 'ft_min_word_len'
[6 Apr 2006 17:39] Paul Dubois
That's right, the only dynamic FT variable is ft_boolean_syntax:

http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html

The others can be set only at server startup.
[6 Apr 2006 18:36] Miguel Solorzano
Thank you for the bug report. Please see Paul's explanation for.
[15 Jun 2006 15:20] Markus Ernst
IMO this is a severe limitation in shared hosting. My ISP will not change MySQL settings at server level, as it will affect all other accounts on the same server, too. Actually I would put transferring this kind of settings to connection or database level high on the wish list.