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.
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@gmail.com 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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
2008/9/19 Mark (Markie) newsmarkie@googlemail.com:
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@lists.wikimedia.org