Solved

Disable 50% threshold in full text serach in mysql

Posted on 2010-11-16
3
687 Views
Last Modified: 2012-06-21
hi to all , iam new to mysql and i working on full text serach in mysql , i  having french word in my data base , when i used  search words like 'l’agence' in french using Match & against in boolean mode it taken french word as delimiter and serach as 2 words ,to over come this i switch to natural mode but problem was "50% threshold ". i want  disable it  how can i do that in mysql site they mention to change this word "#define GWS_IN_USE GWS_PROB" into #define GWS_IN_USE GWS_FREQ" in myisam/ftdefs.h but i cant able to find that file pls help to solve it iam using apache 2.2.11 and mysql 5.1.36
0
Comment
Question by:adivasystems
3 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 34144247
from what I know, you cannot disable that limitation
0
 
LVL 3

Accepted Solution

by:
dazwillnot earned 500 total points
ID: 34144296
Source: http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html

storage/myisam/ftdefs.h  as opposed to myisam/ftdefs.h
0
 

Author Closing Comment

by:adivasystems
ID: 34614064
its having partial information
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql statement to select and drop 13 49
SQL inner join confusion 15 54
Create a MySQL table as easily as possible 6 38
MySQL Memory Keeps Increasing 4 38
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question