http://www.lensovet.net/~sysadmin/w/index.php?action=history&feed=atom&title=Help%3AShort_words_in_searchesHelp:Short words in searches - Revision history2026-05-04T02:03:22ZRevision history for this page on the wikiMediaWiki 1.31.16http://www.lensovet.net/~sysadmin/w/index.php?title=Help:Short_words_in_searches&diff=1844&oldid=prevWadmin: 1 revision(s)2006-07-19T05:34:41Z<p>1 revision(s)</p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #222; text-align: center;">Revision as of 05:34, 19 July 2006</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>Wadminhttp://www.lensovet.net/~sysadmin/w/index.php?title=Help:Short_words_in_searches&diff=1843&oldid=prev65.122.123.130: /* Changing minimum and maximum word lengths in MySQL */2006-02-07T22:57:24Z<p><span dir="auto"><span class="autocomment">Changing minimum and maximum word lengths in MySQL</span></span></p>
<p><b>New page</b></p><div>== Changing minimum and maximum word lengths in MySQL ==<br />
From MySQL's docs on [http://dev.mysql.com/doc/mysql/en/fulltext-fine-tuning.html Fine-Tuning MySQL Full-Text Search]:<br />
<div style="margin-left:1em"><br />
The minimum and maximum length of words to be indexed is defined by the <code>ft_min_word_len</code> and <code>ft_max_word_len</code> system variables (available as of MySQL 4.0.0). See [http://dev.mysql.com/doc/mysql/en/server-system-variables.html Section 5.3.3, “Server System Variables”]. The default minimum value is four characters. The default maximum depends on your version of MySQL. If you change either value, you must rebuild your <code>FULLTEXT</code> indexes. For example, if you want three-character words to be searchable, you can set the <code>ft_min_word_len</code> variable by putting the following lines in an option file (you can simply put these lines in my.cnf):<br />
<pre><br />
[mysqld]<br />
ft_min_word_len=3<br />
<br />
[myisamchk]<br />
ft_min_word_len=3<br />
</pre><br />
<br />
Then restart the server <br />
<pre><br />
mysqladmin shutdown<br />
mysqld_safe &<br />
</pre><br />
and rebuild your <code>FULLTEXT</code> indexes. Also note particularly the remarks regarding '''myisamchk''' in the instructions following this list.<br />
*to do this, simply run the mediawiki rebuild text script by [[Executing a Mediawiki Maintenance Script | executing a mediawiki maintenance script]] found in the wiki/maintenace directory<br />
<pre><br />
php rebuildtextindex.php<br />
</pre><br />
</div><br />
You might want to consult this site [http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html] for further reference.<br />
<br />
== See also ==<br />
* [[Help:Common words, searching for which is not possible]]<br />
* [[Help:Searching]]</div>65.122.123.130