Hi,
I'd like to have a full text search in my MediaWiki. I have got a page called 'Linux', containing several occurrances of the word 'tar'. But the search function doesn't find anything!
I have checked the FulltextStoplist.php file, but it doesn't contain the word 'tar'.
If I do a manual search through the mysql tables 'cur' and 'searchindex' I receive several hits...
Can anyone help me?
- Moritz
You probably at least need to change the following parameters in my.cnf (MySQL only indexes words of length >= 4 by default:
[mysqld] ft_min_word_len=3
[myisamchk] ft_min_word_len=3
Stop and restart your mysql server, of course.
You'll also need to rebuild your search index, there's a script to do that in the maintenance area.
regards, -Nick
Moritz Karbach wrote:
Hi,
I'd like to have a full text search in my MediaWiki. I have got a page called 'Linux', containing several occurrances of the word 'tar'. But the search function doesn't find anything!
I have checked the FulltextStoplist.php file, but it doesn't contain the word 'tar'.
If I do a manual search through the mysql tables 'cur' and 'searchindex' I receive several hits...
Can anyone help me?
- Moritz
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
You probably at least need to change the following parameters in my.cnf (MySQL only indexes words of length >= 4 by default:
[mysqld] ft_min_word_len=3
I didn't set this variable and yet the searchindex table contains words like "aaa", "ada", "yr", "tl", "ei", "xz", "rz", "lw", etc.
Best, Plamen
Plamen Gradinarov a écrit :
You probably at least need to change the following parameters in my.cnf (MySQL only indexes words of length >= 4 by default:
[mysqld] ft_min_word_len=3
I didn't set this variable and yet the searchindex table contains words like "aaa", "ada", "yr", "tl", "ei", "xz", "rz", "lw", etc.
It's the mediawiki software which put this words in the search index table, but that does not mean mysql can handle it. You have to change your my.cnf.
Shaihulud
Plamen Gradinarov a écrit :
You probably at least need to change the following parameters in my.cnf (MySQL only indexes words of length >= 4 by default:
[mysqld] ft_min_word_len=3
I didn't set this variable and yet the searchindex table contains words
like
"aaa", "ada", "yr", "tl", "ei", "xz", "rz", "lw", etc.
< It's the mediawiki software which put this words in the search index table, but that does not mean mysql can handle it. You have to change your my.cnf.>
Thank you. Wouldn't that drammatically affect the size of the index and slow down the server? Even now I am having trouble with the Special:Search - the pages do often hang on, the CPU load soars and the result is: "Cannot find server or DNS Error"
- Plamen
If it's that large of a problem, disable the MediaWiki search and defer to Google. ;)
On Thu, 2 Dec 2004 10:20:55 +0200, Plamen Gradinarov plamen@orientalia.org wrote:
Plamen Gradinarov a écrit :
You probably at least need to change the following parameters in my.cnf (MySQL only indexes words of length >= 4 by default:
[mysqld] ft_min_word_len=3
I didn't set this variable and yet the searchindex table contains words
like
"aaa", "ada", "yr", "tl", "ei", "xz", "rz", "lw", etc.
< It's the mediawiki software which put this words in the search index table, but that does not mean mysql can handle it. You have to change your my.cnf.>
Thank you. Wouldn't that drammatically affect the size of the index and slow down the server? Even now I am having trouble with the Special:Search - the pages do often hang on, the CPU load soars and the result is: "Cannot find server or DNS Error"
- Plamen
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
On Thursday 02 December 2004 00:36, Nick Triantos wrote:
[mysqld] ft_min_word_len=3
[myisamchk] ft_min_word_len=3
Thanks, that worked for me! But I also included a
[isamchk] ft_min_word_len=3
in the my.cnf, not sure if it's necessary.
- Moritz
Am 02.12.2004 um 00:14 schrieb Moritz Karbach:
Hi,
I'd like to have a full text search in my MediaWiki. I have got a page called 'Linux', containing several occurrances of the word 'tar'. But the search function doesn't find anything!
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.
regards
Matthias
mediawiki-l@lists.wikimedia.org