MySQL text search - 3-letter words?

[David Gerard-2]

Our internal wiki uses the built-in MySQL text search. We're
sysadmins, so three-letter abbreviations abound. The default is for
MySQL to search only on words of four or more letters - how do we
change this to three or more?

(This is undoubtedly in the manual, but I couldn't find it ...)


- d.

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l@...
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

[Mark (Markie)]

see http://www.mediawiki.org/wiki/Manual:$wgDBminWordLen

this is obsolete using MySQL 4+ so see
http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html for details
on changing ft_min_word_len

regards

mark

On Fri, Sep 19, 2008 at 11:29 AM, David Gerard <dgerard@...> wrote:

> Our internal wiki uses the built-in MySQL text search. We're
> sysadmins, so three-letter abbreviations abound. The default is for
> MySQL to search only on words of four or more letters - how do we
> change this to three or more?
>
> (This is undoubtedly in the manual, but I couldn't find it ...)
>
>
> - d.
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l@...
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l@...
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

[David Gerard-2]

2008/9/19 Mark (Markie) <newsmarkie@...>:

> see http://www.mediawiki.org/wiki/Manual:$wgDBminWordLen
> this is obsolete using MySQL 4+ so see
> http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html for details
> on changing ft_min_word_len


Yep, I found it just after sending this message and it works nicely :-)

The page as written worked for me - please remove the obsolete bits!

Various blogs on MySQL warn that 3-letter searches can really slow the
server, but ours is an intranet wiki with ten users and no caching or
proxying whatsoever, and I can't say I notice a difference in
performance.


- d.

_______________________________________________
MediaWiki-l mailing list
MediaWiki-l@...
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l