#percona

The percona-query-digest tool is excellent at tracking down queries that kill performance. The queries can be re-written on modified schemas with better indexes and you're golden. Once that's done you need to institure some healthy happy ways to avoid the problem continuing to recur through a little education and some development routines.