Hi everyone,

I got stuck when I wanted to search less than 4 characters.

I share with you the solution to search with a number of characters X.

  • In MYSQL verify the varaibel ft_min_word_len with command :

    SHOW VARIABLES LIKE 'ft_min_word_len'
  • In /etc/mysql/my.cnf add after [myslqd] ft_min_word_len = X

  • Reboot your mysql server :
    /etc/init.d/mysql restart

  • Verify the new value of variable 'ft_min_word_len'

  • If the value is OK, repair ost__search :
    REPAIR TABLE ost__search QUICK

Hope this helps you.

Write a Reply...