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
Subject
Views
Written By
Posted
4506
April 10, 2013 06:38PM
Re: Innodb FTS problem matching phrases.
2303
April 10, 2013 06:52PM
2223
April 11, 2013 09:02PM
2211
April 12, 2013 12:06PM
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.