[Mediawiki-l] Full text search
Alistair Johnson
JohnsonA at rembrandt.co.nz
Tue Jan 18 20:38:54 UTC 2005
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.
More information about the MediaWiki-l
mailing list