issue: https://linear.app/comm/issue/ENG-3349/test-setting-innodb-ft-min-token-size
innodb-ft-min-token-size sets the minimum length of words stored in an InnoDB FULLTEXT index. We set it to 1, because we want words of any length to be indexed.
innodb-ft-enable-stopword set to 0 tells innodb to not use its list of stopwords. We want to handle them ourselves in js, and just not insert them into the search table.
Details
Details
Run keyserver in docker and checked that the variables are indeed set to those values (by connecting to the db and running SHOW VARIABLES LIKE 'innodb_ft%';). Added to the message_search table rows with words of length 1 and 2, and checked that MATCH AGAINST query finds them. Checked that innodb stopwords also match.
Diff Detail
Diff Detail
- Repository
- rCOMM Comm
- Lint
Lint Not Applicable - Unit
Tests Not Applicable
Event Timeline
Comment Actions
This looks ok, but we should also update the databases in our local environments. Do we have a plan for this?