Full-Text Search

• Upgrade from 3.23 to 4.0.xx

• Full-Text is a real pig

  • Indexes are large
  • Memory and disk use significant

• Adjust stopword list

  • ft_stopword_file

• Adjust min/max word length

  • ft_min_word_len
  • ft_max_word_len

• Don't overuse it