Many people consider tuning database queries to be some mysterious “dark art” out of a Harry Potter novel; with the wrong incantation, your data turns from a valuable resource into a pile of mush.
Source: LXer – Tune your MySQL queries like a pro