In this release we have added a new setting to the hypernode-api to make it possible to disable the built-in stopword file for MyISAM search indexes. In MySQL, the default stopword list for MyISAM tables makes it so that some common words are ignored in certain queries. This means that if you have products or brands in your store that contain words that appear in the default list of stopwords they might not properly show up in your search results.
If this affects you, you can now disable this default behavior by using the hypernode-api or by using the hypernode-systemctl command-line tool.
$ hypernode-systemctl settings mysql_disable_stopwords --value True
Operation was successful and is being processed. Please allow a few minutes for the settings to be applied. Run 'livelog' to see the progress.
If you wish to re-enable the default behavior you can run:
$ hypernode-systemctl settings mysql_disable_stopwords --value False
Operation was successful and is being processed. Please allow a few minutes for the settings to be applied. Run 'livelog' to see the progress.
You can check what the current setting is on your Hypernode from the MySQL shell:
# Default behavior: enabled
mysql> SHOW VARIABLES LIKE 'ft_stopword_file';
+------------------+------------+
| Variable_name | Value |
+------------------+------------+
| ft_stopword_file | (built-in) |
+------------------+------------+
1 row in set (0.01 sec)
# Newly configured behavior: disabled
mysql> SHOW VARIABLES LIKE 'ft_stopword_file';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| ft_stopword_file | |
+------------------+-------+
1 row in set (0.00 sec)
Note that you might need to restart MySQL and re-index your MyISAM Full-Text Indexes for this to take effect.