Axel Boldt wrote:
The only way to make mysql index shorter words is by recompiling and setting MIN_WORD_LEN to a different number. They claim that changing this variable from the current value of 4 to 0 will enlarge the index by a factor of 20. So maybe we should go with 2. After that, the indexes have to be rebuilt.
Wow, factor of 20! That's pretty severe. 2 seems good enough for now.
I'll try this out in a few days time.