•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,803 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,419 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 1328 | Replies: 0
 |
•
•
Join Date: Jul 2006
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I need to set ft_min_word_length=3, so that my users can perform boolean fulltext searches for words of three characters instead of four. However, I share the MySQL server with other customers of my ISP.
My ISP's administrator is willing to change this system variable, provided I can show him an authoritative source that says doing so won't break anything if other customers don't rebuild their FULLTEXT indexes.
The description on http://dev.mysql.com/doc/refman/5.1/...ne-tuning.html contains no warnings; the text only implies that setting ft_min_word_len=3 will have no effect until you rebuild your FULLTEXT indexes (which should continue to work as they did before).
The following quote from my admin's latest email explains his problem:
Anybody know of an authoritative source that explains the consequences?
My ISP's administrator is willing to change this system variable, provided I can show him an authoritative source that says doing so won't break anything if other customers don't rebuild their FULLTEXT indexes.
The description on http://dev.mysql.com/doc/refman/5.1/...ne-tuning.html contains no warnings; the text only implies that setting ft_min_word_len=3 will have no effect until you rebuild your FULLTEXT indexes (which should continue to work as they did before).
The following quote from my admin's latest email explains his problem:
•
•
•
•
Can you find any authoritative source that actually says that the only consequence is that text searches won't find any 3-character words because the fulltext index won't contain them until it's rebuilt? The MYSQL manual doesn't clearly say this, and it does say that "you must rebuild your fulltext index."
There are quite a few other MySQL databases on the server, many of them automatically created when installatron is used, and I have no idea if any of them use fulltext searches. I can't afford the risk of any of them breaking. So all I need is some authoritative source that says that existing databases will not be affected.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
•
•
•
•
3d agplv3 apple battery blue screen computer dell development drivers email eudora finance firefox games gnu gpl graphics ibm intel internet java laptop linux microsoft microsystems mobile mozilla news open open source open-source opengl openoffice operating power recall red hat rhel safety software sony source sun super system ubuntu vista wesnoth windows xp
- Windows 2K source code? (Windows NT / 2000 / XP / 2003)
- Can't view source codes (Web Browsers)
- Beware of Bad Capacitors (source of much bizarre behavior) (Motherboards, CPUs and RAM)
- View Source in IE6 (Web Browsers)
- PCModKingdom Source Code (IT Technologies and Trends)
Other Threads in the MySQL Forum
- Previous Thread: Mysql Error
- Next Thread: Help With Messages in Mysql Stop Overwriting
