MySQL Forums
Forum List  »  Full-Text Search

Re: Innodb FTS problem matching phrases.
Posted by: A Fiddaman
Date: April 10, 2013 06:52PM

Having set the innodb_ft_enable_diag_print option on:

keynr=7, '+"House Doctor"'
BOOL search
'doctor' -> 379362/1166 2.51236
'house' -> 379362/1739 2.33875
FTS Search Processing time: 0 secs: 14 millisec: row(s) -1

eynr=7, '+House +Doctor'
BOOL search
'doctor' -> 379362/1166 2.51236
'house' -> 379362/1739 2.33875
FTS Search Processing time: 0 secs: 6 millisec: row(s) 496

keynr=7, '+"House Doctor"'
NL search
'+' -> 379362/0 0.00000
'doctor' -> 379362/1166 2.51236
'house' -> 379362/1739 2.33875
FTS Search Processing time: 0 secs: 15 millisec: row(s) 496

Options: ReplyQuote


Subject
Views
Written By
Posted
3849
April 10, 2013 06:38PM
Re: Innodb FTS problem matching phrases.
1872
April 10, 2013 06:52PM


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.