Search word length¶
By default ke_search only finds words with a minimum length of four characters. This corresponds to the MySQL setting
ft_min_word_len which is set to
4 by default.
As standard ke_search uses MyISAM as storage engine for the index table.
The value can be adjusted by following these steps:
ft_min_word_lento the desired value in your MySQL configuration
This can be done, e.g. in file
my.cnf. In the example below it will set to
[mysqld] ft_min_word_len = 3
A better way would be on Debian-derived systems to use a file like
/etc/mysql/conf.d/fulltext.cnfto separate the default values in
my.cnfwith your custom settings.
After the adjustment the MySQL server has to be restarted.
Set Basic > Change searchword length in the extension configuration to the same value
Re-index your content
Either by just running the indexer again (full indexing is necessary) or by executing the following SQL command:
REPAIR TABLE tx_kesearch_index QUICK;
Find more information about fine-tuning the full-text search in the MySQL documentation.