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.