Today’s fun MySQL fact
If you create a full text index on a table it will fool everyone by looking like it is an actual index, but not in fact be useful as an index to anyone and the database will go back to table scanning everything.
Fixing this took the peak load on a db server from 20 or so to 0.2, I think. It’s hard to measure because top’s overhead is becoming significant.



41
