Solved

Disable 50% threshold in full text serach in mysql

Posted on 2010-11-16
3
662 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]
Comment Utility
from what I know, you cannot disable that limitation
0
 
LVL 3

Accepted Solution

by:
dazwillnot earned 500 total points
Comment Utility
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
Comment Utility
its having partial information
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Creating and Managing Databases with phpMyAdmin in cPanel.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now