I have tons of myisam indexes with ft_min_word_len=4. Now I want to change it to other value, like 3 but without rebuilding old indexes. For old indexes =4 is simply ok.
Will such change be ok from mysql/mariadb point of view and everything will work just fine? I mean old indexes would behave like ft_min_word_len=4 while new (or rebuilt) indexes will behave as ft_min_word_len=2?
Documentation doesn’t really cover that. It only mentions that "
FULLTEXT indexes on
MyISAM tables must be rebuilt after changing this variable" which would be make sense if anyone would want to new setting to work for existing indexes but that isn’t my case.