Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums

 
 
 
 Category : Home > Databases > MySQL > Installation & Setup     

How to change ft_min_word_len variable


Normally it is not recommended to change variables that control MySQL fulltext index behaviour
(such as ft_min_word_len or ft_max_word_len) but if you really need to...

MySQL config file would usually be found on Windows under C:\Windows\my.ini and on Linux
under /etc/my.cnf Edit the file and add

[mysqld]
ft_min_word_len = 3

The default value is 4 and the above will change it to 3. You can change ft_max_word_len in
the same manner:

[mysqld]
ft_max_word_len = 150

After changing the variable(s) in config file restart MySQL server and you're done. You can
then check the values in phpMyAdmin under "Show MySQL system variables" to make sure your
changes have taken place.


  Options
 
   del.icio.us  |  newsvine  |  digg  |  furl  |  google  |  yahoo  |  Ma.gnolia  |  vigillar  |  reddit  |  technorati  |  icerocket  |  pubsub

       Rate this tip:    

Start discussion or add comment to this tip

  Details
Tip reference : #117
views : 1155
Added on : 10/17/06
Submited by : ingres
 
Send a message Send a message Printer friendly output Printer friendly output
Display this member's tips Display this member's tips (5)
 
 
 Most viewed tips 
  Databases > Oracle > Security : How to unlock Oracle user account  
  Operating Systems > Unix : How to kill Unix user session  
  Databases > Oracle > Performance Tuning : How to enable trace in Oracle  
  Databases > Oracle : Kill user session  
   
  All categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Office Software | TipLib FAQ
 
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com