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
/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)
