MySQL Bugs: #18859: Can't set full text system variables with the SET statement;

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:	Windows (win32 XP Professional)
Assigned to:		CPU Architecture:	Any

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'

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.

Thank you for the bug report. Please see Paul's explanation for.

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.