0

With fulltext search for MyISAM, I know that I can specify a stopword file in my.cnf with the following:

ft_stopword_file = '/etc/stopword.txt'

Can the same also be done with fulltext search for InnoDB? I'd like to do something like the following if possible:

ft_stopword_file_innodb = '/etc/stopword.txt'

However, I haven't seen any documentation indicating that stopwords for InnoDB can be stored in a file.

Leo Galleguillos
  • 2,429
  • 3
  • 25
  • 43

1 Answers1

2

No, it cannot natively, hotwired, use a text file out of the box. That is, mysql as shipped. To achieve that you would need to write speciality UDF's which would be absurd considering the simple solution.

The information for custom Stop Words usage is available on this mysql manual page. It shows the rather limited default words out of the gates in the table INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD, how to reset to your own table, and the use of various system variables.

Drew
  • 24,851
  • 10
  • 43
  • 78
  • 1
    Wait. What? They put stuff like that in the MySQL Reference Manual? +10. – spencer7593 Jun 03 '16 at 02:32
  • It was a pathetic answer. My favorite FT search answer is from you spencer. I know one of yours once turned me on to the Natural Language thing. My answer [here](http://stackoverflow.com/a/30677347). Still can't believe you only got 3 upvotes for yours linked at the bottom @spencer7593 – Drew Jun 03 '16 at 02:34
  • It's good answer... one of the politest "RTFM" answers I've ever seen. – spencer7593 Jun 03 '16 at 02:37
  • Thanks. There are some gems tucked away in the pile of dung which SO has become. Try searching for an answer to a question.. and you'll encounter what I refer to as a "great wall of crap". It's no wonder that noobs don't search for answers before flinging more excrement onto the heap. (It seems that SO measures its "progress" by its increasing stench, rather than any decrease in the size of feculent mound). – spencer7593 Jun 03 '16 at 03:57
  • For InnoDB, the link you posted gives examples of stopwords in a MySQL table, but not a text file. – Leo Galleguillos Jun 03 '16 at 08:14
  • That is the way it manages it. Something under its control. Do you need assistance with `load data infile` to bring it in? – Drew Jun 03 '16 at 13:08