MySQL indexes are often used to make performance better. However, they can make performance suffer if you are not using them properly. MySQL Guru Sheeri Cabral explains the pitfalls to avoid with indexes and how to utilize compound indexes to maximize index availability with the least amount of write overhead. Make the most of your indexes!
[youtube mijHsfLxAuA]
Video producer: http://www.technocation.org/