Innotop is great for watching things live. To review long or resource intensive queries, the Percona toolkit scripts create excellent summaries of the MySQL sl

Innotop is great for watching things live. To review long or resource intensive queries, the Percona toolkit scripts create excellent summaries of the MySQL slow query log. I use them to send these weekly reports to our developers: Slow queries, lock waits, transactions with the most rows affected, transaction by highest statement count, largest statements by rows affected, busiest tables, queries doing full table scan or full join, and busy writes.