MySQL full-text indexing & TLAs

full-text mysql TLA

Here’s a quick tip - if you run a technical site and have decided to use MySQL’s full-text indexingfeature to make searches faster, you will want to change something out of the box. I’m upgrading the Ogre forum over xmas to phpBB3, and I’d found that the default ‘native’ search index took over 18 hours to build, simply because the forum is so large (and has in fact been ‘pruned’ back to the last 3-4 years now), plus my test server here is a more modest spec.

Read more →