Are there good tools for debugging, profiling, tracing in MySQL?

If I want to debug queries on SQL Server, I'll use the profiler built into SQL St开发者_如何学Pythonudio Management Studio. Do similar tools exist for MySQL?

I'm aware of showing running queries, profiling CPU usage per query, and other techniques, but because I'm going to be spending a lot of time working on query performance over the coming weeks, I'm wondering if tools exist to streamline the debugging process. Both commercial and open source solutions are welcome.

---

Take advantage of dbForge Studio for MySQL (Query Profiler and Session Manager tools).

Also have a look at Debugger for MySQL.