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@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.
mediawiki-l@lists.wikimedia.org