Announcement

Collapse
No announcement yet.

can't change ft_min_word_len=2 (Variable 'ft_min_word_len' is a read only variable)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] can't change ft_min_word_len=2 (Variable 'ft_min_word_len' is a read only variable)

    I want to make seach working when you search with 2 word like "c5"
    and after search I found that I should set variable on my.cnf

    Code:
    [mysqld]
    ft_min_word_len = 2
    [myisamchk]
    ft_min_word_len = 2
    and after seing variable in mysql its didn't change
    Code:
    mysql> show variables like 'ft_min_word_len';
    +-----------------+-------+
    | Variable_name   | Value |
    +-----------------+-------+
    | ft_min_word_len | 3     |
    +-----------------+-------+
    1 row in set (0.00 sec)
    and when set in with mysql command it return with error
    Code:
    mysql> set ft_min_word_len=2;
    ERROR 1238 (HY000): Variable 'ft_min_word_len' is a read only variable

    I restart the server and still didn't change from 3
    also restart mysql doesn't change
    how to make it changed to 2
    Last edited by sahareto; Sun 12 Aug '12, 9:48am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X