A colleague pointed me at the Hack MySQL site which has a couple of nice tools available.

• mysqlreport which can give a nice snapshop of how mysql is performing
• mysqlsla which will analyse your query logs to tell the frequency of each query, its execution time and an EXPLAIN for each query too.

Interesting site anyway, I’ll stay tuned to its RSS!