Trent Hornibrook has started a mysql dba blog, so I thought i’d provide some linkage :-)

These two articles cover how to use the mysql explain syntax for “debugging” sql queries so be sure to read part 1 and part 2