Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I use MySQL as my database engine. How can I see how the database engine resolves queries internally?

share|improve this question
up vote 2 down vote accepted

It'd help if we know what you wanted to use the tool for.

From my experience, even if such a thing were available for MySQL, it's not something I'd use for analysing/tuning performance. For general database setup I've found does a very good job. While for schema / query tuning, I use mysql_slow_log_parser along with some crude scripts to prioritize problem areas.

For monitoring availability, I use Nagios - which also monitors all sorts of other services.

Some discussion of the same topic on Stackoverflow

There's several websites and books on the subject - mysqlperfromanceblog is a good one

share|improve this answer

If all you want to see is how sql queries are resolved internally, use EXPLAIN (aka DESCRIBE)

"The EXPLAIN statement can be used either as a way to obtain information about how MySQL executes a SELECT statement or as a synonym for DESCRIBE"

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.