[Mediawiki-l] Full text search

[Alistair Johnson]

Hey Matthias, thanks for this info - I'd assumed this was a mediawiki issue
- not just a simple mysql fix!

For others interested, this is what I needed to do to get mediawiki
searching 3 character words:

1. On Windows, in my.ini add:
[mysqld]
ft_min_word_len=3
[myisamchk]
ft_min_word_len=3

2. stop and restart the mysql service.

3. then from mysql (I used phpmyadmin):
REPAIR TABLE archive QUICK;
REPAIR TABLE blobs QUICK;
REPAIR TABLE brokenlinks QUICK;
REPAIR TABLE categorylinks QUICK;
REPAIR TABLE cur QUICK;
REPAIR TABLE hitcounter QUICK;
REPAIR TABLE image QUICK;
REPAIR TABLE imagelinks QUICK;
REPAIR TABLE interwiki QUICK;
REPAIR TABLE ipblocks QUICK;
REPAIR TABLE links QUICK;
REPAIR TABLE linkscc QUICK;
REPAIR TABLE math QUICK;
REPAIR TABLE objectcache QUICK;
REPAIR TABLE old QUICK;
REPAIR TABLE oldimage QUICK;
REPAIR TABLE querycache QUICK;
REPAIR TABLE recentchanges QUICK;
REPAIR TABLE searchindex QUICK;
REPAIR TABLE site_stats QUICK;
REPAIR TABLE user QUICK;
REPAIR TABLE user_newtalk QUICK;
REPAIR TABLE watchlist QUICK;

I don't know if you need to do it with all the tables, but it didn't seem to
hurt.

Cheers,

al.

-----Original Message-----
From: Matthias Winkelmann [mailto:winkelmann at someon.com]

MySQL restricts Full Text Searches to 4 letters or more to keep the 
index small. Have a look in the manual. You can change some defines I 
think to change this behavior. Might have become a config option in a 
newer release.