In Oracle RDBMS there is a way of pulling the top 10 worst queries (as far as resource usage)

Does anyone know how to get this from mysql... (if it's possible)

Now that I've got a larger volume of data I'm going tuning crazy on my web applications. I've thought of writing a script to poll the processlist command for any queries taking longer than a threshold. This just tells me length of time. Not resource consumption.