Re: [PHP-DB] Re: fulltext not for me/alternatives
In the source directory, there's a "myisam/ftdefs.h" file. You can change the min word size there. Note that you will have rebuild it, and reinstall. Usually via "make/make install." Also you have to rebuild the indicies. Easiest way is to drop and readd them. 'Luck -Szii - Original Message - From: "Mark Maunder" <[EMAIL PROTECTED]> To: "Ben Edwards" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 21, 2001 8:11 AM Subject: [PHP-DB] Re: fulltext not for me/alternatives > Ben Edwards wrote: > > > I have a bit of a problem with using freetext indexes because there are a > > LOT of important 3 letter words in my database and as I am using shared > > hosting so do not have the option to recompile MySql. Can't quite figure > > why 3 is not the default (car, dog, cat war, man, bed, ). Maybe so you > > would have to recompile to be able to find s_e_x ;). > > Is there a way to get mysql to change the default from 3 to 2 letter words (or > less) that are ignored in fulltext indexes? > I'm running version 4 alpha. I checked the TODO and it's not listed. Is it > possible to make this a config.h option? A minimum of 4 letters for a word to be > included in a fulltext index seems a bit restrictive. > > tnx! > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: fulltext not for me/alternatives
>See the manual, and SHOW VARIABLES LIKE 'ft_%' Looks like this is something new to 4. My ISP has 20+ db servers so reckon it will be a while before they roll 4 out. Will email them. Thanks for the info. However this douse not help me in the immediate future and I still need to find a alternative fullsearch method. Ben ** * Ben Edwards+352 091 429995 * * Homepagehttp://www.gifford.co.uk/~bedwards * * i-Contact Progressive Videohttp://www.videonetwork.org * * Smashing the Corporate image http://www.subvertise.org * * Bristol's radical newshttp://www.bristle.co.uk * * PGP : F0CA 42B8 D56F 28AD 169B 49F3 3056 C6DB 8538 EEF8 * ** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: fulltext not for me/alternatives
>Is there a way to get mysql to change the default from 3 to 2 letter words (or >less) that are ignored in fulltext indexes? >I'm running version 4 alpha. I checked the TODO and it's not listed. Is it >possible to make this a config.h option? As I said I am on a shared host and don't have the option to recompile MySQL. The answer is yes, it is in an .h file (or something like that). > A minimum of 4 letters for a word to be >included in a fulltext index seems a bit restrictive. My point exactly ;) But this is what it is (4 letters). Penelizes us non hardcore commercial users who can't afford our own box. The latest documentation categorically states there is no other way of changing this. ** * Ben Edwards+352 091 429995 * * Homepagehttp://www.gifford.co.uk/~bedwards * * i-Contact Progressive Videohttp://www.videonetwork.org * * Smashing the Corporate image http://www.subvertise.org * * Bristol's radical newshttp://www.bristle.co.uk * * PGP : F0CA 42B8 D56F 28AD 169B 49F3 3056 C6DB 8538 EEF8 * ** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: fulltext not for me/alternatives
Hi! On Oct 21, Mark Maunder wrote: > Ben Edwards wrote: > > > I have a bit of a problem with using freetext indexes because there are a > > LOT of important 3 letter words in my database and as I am using shared > > hosting so do not have the option to recompile MySql. Can't quite figure > > why 3 is not the default (car, dog, cat war, man, bed, ). Maybe so you > > would have to recompile to be able to find s_e_x ;). > > Is there a way to get mysql to change the default from 3 to 2 letter words (or > less) that are ignored in fulltext indexes? > I'm running version 4 alpha. I checked the TODO and it's not listed. Is it > possible to make this a config.h option? A minimum of 4 letters for a word to be > included in a fulltext index seems a bit restrictive. Well, if it's not in the todo, it's probably, already done, isn't it ? See the manual, and SHOW VARIABLES LIKE 'ft_%' Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: fulltext not for me/alternatives
Ben Edwards wrote: > I have a bit of a problem with using freetext indexes because there are a > LOT of important 3 letter words in my database and as I am using shared > hosting so do not have the option to recompile MySql. Can't quite figure > why 3 is not the default (car, dog, cat war, man, bed, ). Maybe so you > would have to recompile to be able to find s_e_x ;). Is there a way to get mysql to change the default from 3 to 2 letter words (or less) that are ignored in fulltext indexes? I'm running version 4 alpha. I checked the TODO and it's not listed. Is it possible to make this a config.h option? A minimum of 4 letters for a word to be included in a fulltext index seems a bit restrictive. tnx! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
