MySQL FullText Search
Don’t ever use MySQL FTS if you can help it. And if you do use it, in 5.1.x atleast DO NOT EVER USE IN BOOLEAN MODE. It’s like driving with the parking brakes on, seriously, it slows MySQL down that much. Why? No idea. But, like I said, you shouldn’t be using FTS anyway.