Solved

Disable 50% threshold in full text serach in mysql

Posted on 2010-11-16
3
718 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 143

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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

622 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