For anyone interested in DB optimization under Django, I recommend to take a look at Unbreaking Your Django Application presentation[0]. It might be more PostgreSQL-specific at times, but most of the advice is applicable to MySQL as well.

[0] http://www.slideshare.net/OReillyOSCON/unbreaking-your-djang...