In this release we expose functionality in the hypernode-api that will make it possible to configure the ft_min_word_len for MySQL. The
ft_min_word_len is the minimum length of the word to be included in a MyISAM FULLTEXT index. So, if you sell things in your Magento shop like wol or a sok then today is your lucky day. You can now change this setting from the default value of
4 to the smaller value
2. In some cases this can solve issues related to product search if you have items with very short names. Take note that doing this might have some impact on performance and will increase the size of your search indexes.
To enable this setting you can use the
hypernode-systemctl commandline tool:
$ hypernode-systemctl settings mysql_ft_min_word_len --value 2 Operation was successful and is being processed. Please allow a few minutes for the settings to be applied. Run 'livelog' to see the progress.
After the setting has been changed make sure to restart MySQL:
$ hypernode-servicectl restart mysql $ mysql mysql> show variables like 'ft_min_word_len'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | ft_min_word_len | 2 | +-----------------+-------+ 1 row in set (0.00 sec) mysql>
Once the setting has been activated you also need to rebuild the full-text indexes with REPAIR TABLE for it to take effect.