It helped me. Especially the part about tricking MySQL to not use an index, without using USE INDEX or FORCE INDEX (which can be very bad if you have a dynamic query or your tables change/grow, something they usually do).
Note that Solution #7: Make MySQL think the problem is harder than it really is can also be applied to GROUP BY. e.g.
GROUP BY id, type, level