Enable keyword searches for 3 letter acronyms

Connect as root on demo.neogia.org
Edit /etc/mysql/my.cnf
Add theses lines in the mysqld section

# enable keyword searches for 3 letters acronyms
ft_min_word_len = 3

Restart mysql server

/etc/init.d/mysql restart

Connect to the database and rebuild searchindex

mysql -u wikiuser -p wikidb
Enter password: 
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 69
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> repair table searchindex quick;
+--------------------+--------+----------+----------+
| Table              | Op     | Msg_type | Msg_text |
+--------------------+--------+----------+----------+
| wikidb.searchindex | repair | status   | OK       | 
+--------------------+--------+----------+----------+
1 row in set (0.97 sec)

Retrieved from "http://neogia.org/Enable_keyword_searches_for_3_letter_acronyms"