Bug #13205 My.cnf Configurable GWS_FREQ Please?
Submitted: 15 Sep 2005 0:26 Modified: 22 Feb 2013 16:33
Reporter: John Crichton Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: FULLTEXT search Severity:S4 (Feature request)
Version:4.1.14 and Above OS:Linux (Slackware Linux 10.1)
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[15 Sep 2005 0:26] John Crichton
May we please have a .cnf configurable option for GWS_IN_USE GWS_FREQ?  The "50% threshold" option seems not to fit in many databases, and modifying source code and recompiling can be difficult and time consuming.

My opinion is that too many results is more relevant than mysteriously receiving no results.  

Thank you in advance!

How to repeat:
select column-name, match (column-names) against ('frequently-used-word') from table-name; 

Running this fulltext query with a word used in over 50% of the records will produce no results.

Suggested fix:
My suggestion is to make "GWS_PROB" the default, then allow administrators to use FREQ (through my.cnf) with LIMIT.
[15 Sep 2005 19:24] John Crichton
Another suggested fix (although asking a for a lot) would be the ability to configure the threshold level (possibly through my.cnf).  This way, the administrator could configure a "75% threshold" or any other percentage (including 0%) if he or she so desires.
[22 Feb 2013 16:33] Sveta Smirnova
Thank you for the feature request.
[22 Feb 2013 16:40] Sveta Smirnova
Currently you can use boolean mode.