In this post, mysql indexing is explained in easy to understand manner and describe best practices to follow for highest possible performance gain.