I used to use mytop but since 2 years or so, I use innotop now, which is just like mytop but with more features geared towards InnoDB tables: http://innotop.sourceforge.net/

It also works pretty much the same as mytop for MyIsam tables, I use innotop in such away on one of the sites I own.