Maintenance:Fixing MySQL to allow Searches of less then 4 Items

From Cerberus Helpdesk Wiki

Searching

Every once in a while someone will ask why they can find a ticket for some reason. You can read more about it here. http://www.cerb4.com/forums/showthread.php?t=2394

How to fix

This worked for me (including searches with wild-card characters):

In /etc/my.cnf add the following lines: (Can be 2 instead of 3 to allow shorter searches)
[mysql]
ft_min_word_len = 3


Then run SQL commands to rebuild indexes:
REPAIR TABLE kb_article QUICK;
REPAIR TABLE message_content QUICK;

Warning

Changing that config setting means you have to rebuild *every* fulltext index on your mysql server, not just the Cerberus ones. (If those are all you have, then that's fine, but just to beware...)