MySQL Forums
Forum List  »  Full-Text Search

Re: How configure Mysql Full Text Search to match formatted numbers like 10.415?
Posted by: Rick James
Date: January 18, 2015 11:29AM

Consider the following issues in your test case:
* If more than half the rows contain a particular word ("Service"), that word is not considered (at least in MyISAM). (The "50% rule".)
* The default setting for MyISAM is ft_max_word_len = 4; did you decrease that? If not, then A&O is ignored in MyISAM. Sorry, I should have observed that 'New' is 3 characters. Note that innodb_ft_min_token_size defaults to 3.

Perhaps you would like to modify the test case in the bug report before they jump on you for those issues.

There are differences between the two implementations of FULLTEXT.
See this for the settings you are using:
SHOW VARIABLES LIKE '%ft%';
If you change any settings, you will need to rebuild the FT index(es).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How configure Mysql Full Text Search to match formatted numbers like 10.415?
1968
January 18, 2015 11:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.