Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

2 Answers 2

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 mysqltuner.pl 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

 
discard

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.